Question: Normalize the given ERD diagram This is my attempt. I would like to know if it is correct and if not for it to be

Normalize the given ERD diagram 

GetAttachmentThumbnail.png




This is my attempt. I would like to know if it is correct and if not for it to be corrected. 

ERD(2).png


 
 

PROFESSOR PK PROF ID INTEGER PROF LNAME VARCHAR(50) PROF FNAME VARCHAR(50) Column name Column type Entity Primary Key STUDENT INTEGER Column PK STUD ID STUD FNAME STUD LNAME CLASS PK CLASS_ID INTEGER H+ CLASS NAME VARCHAR(255) teaches FK PROF ID INTEGER FK COURSE ID INTEGER FK ROOM ID INTEGER Foreign Key generates VARCHAR(50) VARCHAR(50) STUD STREET VARCHAR(255) STUD CITY STUD ZIP VARCHAR(50) VARCHAR(10) ENROLL OPK STUD ID INTEGER PK CLASS ID INTEGER GRADE VARCHAR(3) Cardinality (0..") -Relationship Cardinality (1) COURSE PK COURSE ID INTEGER COURSE NAME VARCHAR(255) ROOM PK ROOM_ID INTEGER ROOM LOC VARCHAR(50) ROOM CAP VARCHAR(50) FK CLASS_ID INTEGER

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!