Question

Design a database suitable for a university registrar. This database should include information about students, departments, professors, courses, which students are enrolled in which courses, which professors are teaching which courses, student grades, TA's for a course (TA's are students), which courses a department offers, and any other information you deem appropriate. Note that this question is more free-form than the questions above, and you need to make some decisions about multiplicities of relationships, appropriate types, and even what information needs to be represented.

Answer 1

Hello there, see step by step explanation for answers

Step-by-step explanation:

A database design for a University Registrar. The following requirements are for designing a Database Schema.

It should include:

1. Information about Students .

2. Information about Departments.

3. Information about Professors.

4. Information about courses.

5 . student Grades.

6. TA's for a course.

7. Department offering different courses.

For Designing Database for Registrar System We need to define various

1. Entity: Student, Course, Instructor, Course offering.

2. Attributes of Entities:

(a) Student entity has Sid, name, program as its attributes

(b)Course has Course_n, title, credits, and syllabus as its attributes

(c) instructor has iid ,name ,dept, title as its attributes

(d) course offering has section_no ,time, room, year ,semester as its attributes

3. Relationship among various entities

(a) enrolls

(b) teaches

© is offered

E-R Diagram for University Registrar

This Diagram shows student entity enrolls various courses which can be having teaches relationship with instructor. Course is being offered by relationship is offered by course offering .

A database design for a University Registrar. The following requirements are for designing a Database Schema.

It should include:

1. Information about Students .

2. Information about Departments.

3. Information about Professors.

4. Information about courses.

5 . student Grades.

6. TA's for a course.

7. Department offering different courses.

For Designing Database for Registrar System We need to define various

1. Entity: Student, Course, Instructor, Course offering.

2. Attributes of Entities:

(a) Student entity has Sid, name, program as its attributes

(b)Course has Course_n, title, credits, and syllabus as its attributes

(c) instructor has iid ,name ,dept, title as its attributes

(d) course offering has section_no ,time, room, year ,semester as its attributes

3. Relationship among various entities

(a) enrolls

(b) teaches

© is offered

E-R Diagram for University Registrar

This Diagram shows student entity enrolls various courses which can be having teaches relationship with instructor. Course is being offered by relationship is offered by course offering .