Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Help in ER Model

    Hi all,

    I have a project in ER model, I did it but my professor told me that in my design the doctor can describe only one drug in each prescription!!

    I attached a picture for the ER model.

    Any suggestions please ?
    Attached Thumbnails Attached Thumbnails Project_1.png  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    your professor is right

    move the trade name FK into the PK for the Prescription table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    Quote Originally Posted by r937 View Post
    your professor is right

    move the trade name FK into the PK for the Prescription table
    Thank you for replying me, but would you please explain it more for me ? What do you mean by 'PK' ?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by salelyani View Post
    What do you mean by 'PK' ?
    primary key

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •