Question

ERD Primary Key Problems A partial ERD diagram for the student registration process is depicted below. Examples of the in- formation desired to be tracked for each entity is included below the title of the entity. List ALL of the tables you would need to include in your database for this portion of the ERD diagram. Also list a Primary Key(s) and any Foreign Key(s) that would be included in each table (if there would be no Foreign Key, write "none"). Registration for Each Se- mester Students (Information needed in- cludes semester, date of registration, etc.) (Information needed in- cludes name, age, major, etc Inventory of Classes (Information needed in- cludes class name and de- scription, time held, etc.) Professors (Information needed includes name, hire date, education background, etc.) WRITE YOUR ANSWERS IN THE TABLE BELOW: Table Name ForeignKey(s)- Primary Key(s)

Answer 1

Solution:

Table: Inventory of Class

Primary Key: InventoryID

Foreign Key: RegistrationID, ProfessorID

Table: Registration for each semester

Primary Key: RegistrationID

Foreign Key: studentID

Table: Students

Primary Key: studentID

Foreign Key:

Table: Professors

Primary Key: ProfessorID

Foreign Key:

some other tables which can be added in the database are:

Table: Course

Primary Key: CourseID

Foreign Key: ProfessorID, studentID

Table: Department

Primary Key: DepartmentID

Foreign Key: ProfessorID, courseID

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)