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

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

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
Get step-by-step solutions from verified subject matter experts
