Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management Accounting And Control

Authors: Don R. Hansen, Maryanne M. Mowen, Liming Guan

6th Edition

324559674, 978-0324559675

More Books

Students also viewed these Databases questions