00:01
Hello students, so to design a relational database for a university registrar's office, we can create the table for the classes, instructors, students and the grades.
00:10
Here is a simplified example class table.
00:13
Here the field i am taking class id, which is primary key, class name, instructor id, which will be the foreign key, meeting time, location, enrollment.
00:23
So here i have taken some attributes for this attributes values.
00:27
So class id, suppose it is one and class name, it's suppose math 101, instructor id is 101 and meeting time is when the class will start.
00:37
So here is 9am and location in which room the lecture will go.
00:43
So here the room number a and enrollment is 30.
00:47
So how many students are there? total 30.
00:50
So in this way we can fill the class table.
00:53
Now instructor table.
00:54
So in the instructor table fields, i have taken instructor id, which will be the primary key, instructor name and the department.
01:01
So here the instructor id, which is the foreign key for the class.
01:04
So here 101, 102 i am taking and the instructor name will be the professor smith, professor johnson and the department will be math and history from which department these two professors belong.
01:18
Now student tables.
01:19
In the student table, i am taking the fields three student id, which is a primary key, student name and name of the student and the major.
01:27
The major will in major section, the subject will come.
01:31
So here student id, suppose 1001 and the student name is alice and major is bio.
01:40
So suppose bio is a major for the students.
01:43
So in this way we can fill the major and for 1002 the major is computer science and name is bob...