Yioop - PHP Search Engine

Oct 14 In-Class Exercise Thread.

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

Best,

Chris

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

-- Oct 14 In-Class Exercise Thread

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

(Edited: 2020-10-14)

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

-- Oct 14 In-Class Exercise Thread

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

Class(ClassName, Department) ClassName -> Department

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

Enrolled(StudentID, SectionID)

(Edited: 2020-10-14)

Student(StudentID, FName, LName) StudentID -> FName, LName Class(ClassName, Department) ClassName -> Department Sections(SectionID, ClassName, Time, Location) SectionID -> ClassName, Time, Location Enrolled(StudentID, SectionID)

-- Oct 14 In-Class Exercise Thread

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

StudentTakesCourse(SID,COURSEID)

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

-- Oct 14 In-Class Exercise Thread

Student_id (FD) -> fname ,lname

class_id (FD) -> class_name ,class_section

STUDENT(student_id , fname, lname) Course(class_id, class_name, class_section) Enrolled(student_id, class_id)

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)

-- Oct 14 In-Class Exercise Thread

Student (student_id, first_name, last_name, major)

Classes (class_name, class_id, department)

Section (section_id, time, location)

TakesClass (student_id, class_id)

(Edited: 2020-10-14)

Student (student_id, first_name, last_name, major) Classes (class_name, class_id, department) Section (section_id, time, location) TakesClass (student_id, class_id)

-- Oct 14 In-Class Exercise Thread

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

Enroll(ID, courseId)

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

-- Oct 14 In-Class Exercise Thread

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

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

<pre>

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

-- Oct 14 In-Class Exercise Thread

 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)

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)

-- Oct 14 In-Class Exercise Thread

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

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