Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERD and normalization 3NF

3422863Apr 16 2017 — edited Apr 16 2017

is this relationship is true in 3NF normalization? and what can i do with the (phone number), it is Determines all rows? please any one help me to convert this relationship to 3NF and in Correct relationship.

note: the primary key of patients = PID, Doctors=DID, consultation= CID

erd.PNG

***Moderator action (Timo): Userr this question has no connection to . I'll move it over to the space.***

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2017
Added on Apr 16 2017
3 comments
836 views