Post your Solutions to the Oct 14 In-Class Exercise to this thread.

Best,

Chris

Student(ID, Fname, Lname, Major) ID -> Fname, Lname Precourse(course_id, pre_cousre_id) course_id -> pre_course_id Course(course_id, section_id) course_id -> section_id Section(section_id, intructorName, classroom, time, slot, taken) section_id -> instructionName, classroom, time, slot, taken

Student(StudentID, FName, LName) StudentID -> FName, LName

Class(ClassName, Department) ClassName -> Department

Sections(SectionID, ClassName, Time, Location) SectionID -> ClassName, Time, Location

Enrolled(StudentID, SectionID)

Student(SID, name, major) SID -> name, major Course(COURSEID, department, classNumber) COURSEID -> department, classNumber

StudentTakesCourse(SID,COURSEID)

Student_id (FD) -> fname ,lname

class_id (FD) -> class_name ,class_section

STUDENT(<u>student_id</u> , fname, lname) Course(<u>class_id</u>, class_name, class_section) Enrolled(student_id, class_id)

Student (student_id, first_name, last_name, major)

Classes (class_name, class_id, department)

Section (section_id, time, location)

TakesClass (student_id, class_id)

Student(ID, name, major) ID -> name, major Course(courseId, name, section, department, location) courseId -> name, section, department, location

Enroll(ID, courseId)

<pre> Student(studentID, firstName, lastName, major) Class(courseID, department, classNumber) StudentTakesCourse(studentID, courseID)

studentID -> firstName, lastName, major courseID -> department, classNumber

<pre>

Dependencies: Course, Student ID-> Class ID Student ID -> student name Class ID -> room number Class ID -> Professor

Tables: Classes Taken (Course, student ID, class ID) Students( Student ID, Student Name) Courses( Class ID, room number, Professor)

Student Id, fname, lname, classes taken

Functional dependencies: Student id -> fname Student id -> lname Student id -> fname, lname Student id -> fname, lname, classes taken

Classes: Class name, class id, section name, class time, instructor

Class name, class id -> section name, class time, instructor