The College wants to expand the database to cover the different dates and times

Question

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.

So I know I need to create a new table (TestGroup) but I need help with the entire thing. Please actually read the question and don't just send me the ER diagram back as it has been done 3 times already!

These are the steps that need to be taken

New Tables/Fields listed + Basic description on change to a database you will be making

1NF & Dependencies

Convert to 2-3NF + Final Table & DBDL

ER Diagram

Department Course Major DepartmentCode Cours eNum DepartmentName Code (Fky Description Course Title DepartmentCode (FK) NumCredits has prereq is prereq. Office Advises Prereq CourseNum StudentNum (FKO DepartmentCode (FK) Faculty Num (Fkyo CourseNum/1 (FK) Department Code (FK) Faculty Faculty Num LastName FirstName State PostalCode Current Rank ate Office Num (FK) DepartmentCode (FK) Section RegistrationRequest ScheduleCode Student Num (FK) SemesterCode FK) Schedule Code CFk SemesterCode (FK) SectionLetter primary- Time Schedule Codell (FK alternate Room CurrentEnrollment Maximum Enrollment Faculty Num Course Num DepartmentCode (FK) Semester StudentClass SemesterCode StudentNum (FK) Student Schedule Code (Fky StartDate Student Num SemesterCode (K) EndDate ExamStart Date Grade ExamEndDat FirstName WithdrawalDate LocalStreet Student Grade Local City CourseNuma LocalState Department Code (FK) LocalPostalCode StudentNum (FK) PermStreet Semester Code (FK) PermCity PermState Grade PermPostalCode Credits Earned Credits Taken Grade Points Credits arned GPA TotalPoints Class Standing

Explanation / Answer

Invoice (InvoiceNumber, CustomerNumber, InvoiceDate, InvoiceTotal, InvoiceBalance)

FK CustomerNumber Customer

InvoiceLine (InvoiceNumber, PartNumber, NumberShipped)

FK InvoiceNumber Invoice

FK PartNumber Part

Customer (CustomerNumber, Last, First, Street*, City*, State*, ZipCode*, TotalBalance, TerritoryID)

FK TerritoryID Territory

SK Last, First

SK ZipCode

Part (PartNumber, PartDescription, UnitPrice, WarehouseID*)

FK WarehouseID Warehouse

AK PartDescription

Assembly (AssemblyNumber, AssemblyDescription, BinNumber*)

PartAssembly (PartNumber, AssemblyNumber, QuantityRequired)

FK PartNumber Part

FK AssemblyNumber Assembly

Warehouse (WarehouseID, Location)

SK Location

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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