Schema Department (dept id, dept name, budget) Course (course_id, title, credits

Question

Schema Department (dept id, dept name, budget) Course (course_id, title, credits, dept_id, prerequisite) Faculty (faculty_id, name, room_id, dept_id, salary) Student fstudent_id, last _name , first_name, street, city, state, zip, birth date, major_id, phone, student type) Term {term id, term desc , start_date , end date} Section section id, course_id , section_number, term_id, faculty_id , day, max_count, start time end time, room id} Registration {student id, section id , midterm grade, final grade) Major {major_id , major desc) Location (room id, building, room_no, capacity, room_ type , room_description)

Explanation / Answer

1) Below are create table statements which create the tables in the database.

As per the Chegg policy, I am allowed to answer only one part of the question. Kindly understand and post the remaining as new one.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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