Yioop - PHP Search Engine

-- Oct 14 In-Class Exercise Thread

student(student_id,first_name, last_name) student_id -> first_name, last_name

classes(course_id, course_name, instructor_name, course_section) course_id -> course_name, instructor_name, course_section

enroll(student_id, course_id)

student(student_id,first_name, last_name) student_id -> first_name, last_name classes(course_id, course_name, instructor_name, course_section) course_id -> course_name, instructor_name, course_section enroll(student_id, course_id)

-- Oct 14 In-Class Exercise Thread

Students(student_ID, student_name, student_year)

Course(course_id, course_name, instructor_name)

Sections(course_section_id, section_number, time, location) Registration(student_ID, course_id, course_section_id)

Students(student_ID, student_name, student_year) Course(course_id, course_name, instructor_name) Sections(course_section_id, section_number, time, location) Registration(student_ID, course_id, course_section_id)

-- Oct 14 In-Class Exercise Thread

Course(course_id,class_name,class_info_json) Student(student_id,first_name,last_name,some_info) EnrollStatus(corse_id,student_id,status)

student_id ->first_name,last_name,some_info

course_id-> class_name,class_info_json

(course_id,student_id)->status

(Edited: 2020-10-14)

Course(course_id,class_name,class_info_json) Student(student_id,first_name,last_name,some_info) EnrollStatus(corse_id,student_id,status) student_id ->first_name,last_name,some_info course_id-> class_name,class_info_json (course_id,student_id)->status

-- Oct 14 In-Class Exercise Thread

Student(first_name, last_name, id) Class(class_id, class_name) Section(section_id, room_number, time) Enroll(id, class_id)

-- Oct 14 In-Class Exercise Thread

Student(studentID, fName, lName, major, year) Course(courseID, courseName, professor, preReq) studentId->fName,lName,major,year courseID->courseName, professor, preReq

(Edited: 2020-10-14)

Student(studentID, fName, lName, major, year) Course(courseID, courseName, professor, preReq) studentId->fName,lName,major,year courseID->courseName, professor, preReq

-- Oct 14 In-Class Exercise Thread

Person(ID, fName, lName) Prof(ID, salary) course(cID, courseName, startTime, duration, room) taken(sID, cID, grade) teaches(profID, cID)

-- Oct 14 In-Class Exercise Thread

student(id, first_name, last_name): id -> first_name, last_name
course(id, name): id -> name
section(id, course_id): id -> course_id
enrollment(student_id, section_id, status): student_id, section_id -> status

(Edited: 2020-10-19)

;student(id, first_name, last_name): id -> first_name, last_name ;course(id, name): id -> name ;section(id, course_id): id -> course_id ;enrollment(student_id, section_id, status): student_id, section_id -> status

-- Oct 14 In-Class Exercise Thread

CS174 Student Registration System

Student(SID, FirstName, LastName) Course(CID, Cname, Pre-req) Section(SecId, building, instructor, time)

FD's:

SID --> FirstName, LastName CID --> Cname, pre-req SecId--> building, instructor, time

(Edited: 2020-10-19)

CS174 Student Registration System Student(SID, FirstName, LastName) Course(CID, Cname, Pre-req) Section(SecId, building, instructor, time) FD's: SID --> FirstName, LastName CID --> Cname, pre-req SecId--> building, instructor, time