The UNIVERSITY Database You have been approached by a university for the design

Question

The UNIVERSITY Database You have been approached by a university for the design and implementation of a relational database system to provide information on the courses it offers, academic departments that run the courses, academic staff, and students enrolled. Students and academic staff will mainly use the system Assume the following requirements were collected for this application * Department: The university is organized into departments. Each department is identified by a unique - Course: Each department runs several courses. Each course is associated with a course ID, title .Faculty: Faculties are identified by their unique ID. Each faculty has an associated department (department * Student: Students are identified by their unique ID. Each student has an address, a name, * Term: The university maintains a list of terms specifying the term ID, term description, start date and end * Section: The university maintains a list of all classes (sections) taught. Each section is identified by a identification number (department ID), name, and budget. credits, department ID, and may also have associated prerequisites. ID), a name, room ID, and salary birthdate, phone, student type, and major ID date section ID, course ID, section number, room ID, start time, day, maximum count, term ID, and an end time A section can be used in only one course but can be studied by many students. The department has a list of teaching assignments specifying the sections each faculty is teaching. * Registration: The university has a list of all student course registrations specifying the associated sections *Location: The university maintains a list of classrooms specifying the room ID, building, room number * Major: The university has a list of all majors. Each major is identified by a unique number (major ID) and each student has taken (or registered for), midterm grade, and final grade capacity, room type, and room description. a 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. Also please include the data which needs to be inserted

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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