A... In Concepts of Database Management (8th Edition) Appendix A Excercises: Dis

Question

A... In Concepts of Database Management (8th Edition)

Appendix A

Excercises:

Discuss the effect of the following changes on the design for the Marvel College requirements:

1. More than one instructor might teach a given section of a course, and each instructor must be listed on the time schedule

2. Each Department offers only a single major

3. On the registration request form, a student may designate any number of alternates along with his or her primary choice. These alternates are listed in priority order, with the first one being the most desired and the last one being the least desired.

4. The College wants to expand the database to cover the different dates and times for final exams. There will be several groups/blocks for each semester identified by a TestGroupID that sections will be assigned to. Each TestGroup will be assigned a Date and Time for the final exams.   All sections assigned to a specific TestGroupID will have the exam on the same Date and Time.

I NEED

DBDL

1NF + Dependencies

, 2NF, and 3NF

FOR EACH QUESTION PLEASE.

Explanation / Answer

1.

1NF:

Course(DepartmentCode, CourseNum, CourseTitle, NumCredits)

Faculty (FacultyNum, LastName, FirstName)

2NF:

Course(FacultyNum, DepartmentCode, CourseNum, CourseTitle, NumCredits)

Faculty (FacultyNum, CourseNum, LastName, FirstName)

3NF:

Course(FacultyNum, DepartmentCode, CourseNum, CourseTitle, NumCredits)

Faculty (FacultyNum, CourseNum, LastName, FirstName)

Address (Street, City, State, PostalCode)

2.

1NF:

Major(MajorNum, Description)

Department (DepartmentCode, DepartmentName, Location)

2NF:

Major(MajorNum, Description,DepartmentCode)

Department (DepartmentCode, DepartmentName, Location)

3NF:

Major(MajorNum, DepartmentCode)

Department (DepartmentCode,MajorNum, DepartmentName, Location)

3.

1NF:

Student(StudentNum, LastName, FirstName, LocalStreet. PermState)

RegistrationRequest(ScheduleCode, SemesterCode)

2NF:

Student(StudentNum, LastName, FirstName, LocalStreet. PermState)

RegistrationRequest(StudentNum,ScheduleCode, SemesterCode)

3NF:

Student(StudentNum, LastName, FirstName, LocalStreet. PermState)

RegistrationRequest(StudentNum, StudentNum,ScheduleCode, SemesterCode)

4.

1NF:

Semester(SemesterCode, StartDate, EndDate, ExamStartDate,ExamEndDate, WithdrawalDate)
Section(Sectionletter, Time, Room, CurrentEnrollment, MaximumEnrollment)

2NF:

Semester(SemesterCode, TestGroupID , StartDate, EndDate, ExamStartDate,ExamEndDate, WithdrawalDate)
Section(Sectionletter, Time, Room, CurrentEnrollment, MaximumEnrollment)

3NF:

Semester(SemesterCode, TestGroupID ,StartDate, EndDate, ExamStartDate,ExamEndDate, WithdrawalDate)
Section(Sectionletter, SemesterCode, Time, Room, CurrentEnrollment, MaximumEnrollment)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.