Question

Deck Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the department. In addition, Deck would like the database to include each instructor’s basic contact information, such as ID number, name, office location, and phone number. Currently, Deck has nine instructors (seven full-time faculty members and two adjuncts) in the department. For each course, Deck would like to keep track of the course ID, title, and number of credit hours. When courses are offered, the section of the course receives an ID number, and with that number, the department keeps track of which instructor is teaching the course. Finally, Deck needs to be able to keep track of the IT students and to know which courses each student has taken. The information he would like to know about each student includes ID number, name, and phone number. He also needs to know what grade the student receives in each course. Deck has asked you to create an ERD from the information described above, and then create a normalization structure in 3NF.

Answer 1

Answer: END Diagran ERD diagram for the given data provided: Dept DID DName Courses CID CTitle CCreditHours DeptID IName IAddressoffice Students Sections SID CID IName SPhoneNo CID 3-Normal Form . The third normal form implementation of the given data is placed below . PK indicates the primary key . FK indicates the foreign key 1. Course(CID (PK), CTitle, CCreditHours, DeptID(FK)) 2. Dept(DID PK), DName) 3. Instructor(Ins_ID(PK), IName, IAddressOffice, IPhoneNumber, DeptID(FK)) 4. Sections(SID(PK), CID (FK), IName) 5. Students(StudentID PK), SName, SPhoneNo, CID (FK)