If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > How to translate the ER model in the relational model

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-15-11, 14:16
Bracinac Bracinac is offline
Registered User
 
Join Date: Jan 2011
Posts: 2
How to translate the ER model in the relational model

How should look a relational model for example in Figure

Person(id(pk),..)
City(idc(pk),....)
Attached Thumbnails
How to translate the ER model in the relational model-dcidb.gif  
Reply With Quote
  #2 (permalink)  
Old 01-16-11, 14:07
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Without some insight into what you've covered in class so far, we're more likely to lead you astray than to do your homework assignment correctly. Of course we aren't all that likely to do your assignment correctly anyway, but that is beside the point.

If you can give us the URL for your assignment or your instructor's email address, we could do a much better job helping you.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
  #3 (permalink)  
Old 01-16-11, 18:45
Bracinac Bracinac is offline
Registered User
 
Join Date: Jan 2011
Posts: 2
OK, like I said, for a given ER model is necessary to make a SQLServer db.
here we have two entities:
Person and City with attributes:

Person (personID, name, height)
City (CityID, zipcode, cityname, population)

and relationship:
person -> born in -> City
person -> live in-> City

Can this be done in next way:

Person (#personID, name, height, $CityID, $place_of_birth_ID, $place_of_residence_ID)
City (#CityID, zipcode, cityname, population, #place_of_birth_ID,#place_of_residence_ID )

# - primary key
$ - foreign key
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On