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 (T.A's are students), which courses a department offers, and any other information you deem appropriate.

For designing a database suitable for a University registrar, the following information is included which are Information about Students, Information about Departments, Information about Professors, Information about courses, Student Grades,TA's for a course, Department offering different courses.

In creating the database registrar system the following values are defined such as Entity, Attributes of entities,The relationship among entities.

Explanation:

Solution

The following requirements are for designing of database for a University registrar.

The Database Schema includes the following:

Information about Students
Information about Departments.
Information about Professors.
Information about courses.
Student Grades.
TA's for a course.
Department offering different courses.

Now,

For the design of Database for Registrar System we need to define the following:

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

(2) Attributes of Entities:

Student entity has Sid, name, program as its attributes
Course has Course_n, title, credits, and syllabus as its attributes
Instructor has iid ,name ,dept, title as its attributes
Course offering has section_no ,time, room, year,semester as its attributes

(3) Relationship among various entities:

Enrolls
Teaches
© is offered

Note: kindly find an attached copy of the E-R Diagram for University Registrar below, and his 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.

lhmarianateixeira lhmarianateixeira · Answer 2 · 2022-01-18T19:20:56+01:00

In this exercise we have to use computing knowledge more specifically database, so we can say:

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

2)Attributes of Entities:

3)Relationship among various entities:

In develop in mind or physically the collection of data recorder order the following principles exist delineate to a degree Entity, Attributes of object that exists,The connection with nature of a being.

The following necessity exist for crafty of collection of data for a University recorder. The Database Schema contain the following:

Information about Students

Information about Departments.

Information about Professors.

Information about courses.

Student Grades.

TA's for a course.

Department donation various courses.

Now, for the design of Database for Registrar System we need to give description the following:

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

2) Attributes of Entities: Student entity has Sid, name, program as its attributes

Course has Course_n, title, credits, and syllabus as its attributes

Instructor has iid ,name ,dept, title as its attributes

Course offering has section_no ,time, room, year,semester as its attributes

3) Relationship among various entities

See more about database at brainly.com/question/6447559