Make an Erd diagram on the scenario University Course Registration System. And you can see this below phots and do changes i that. But make sure Your ER Diagram must include at least FIVE entities. There is no upper bound on how many entities you choose, but you are advised to include no more than ten. Design your ER Diagram with all entity names, attribute names, primary and foreign keys, relationships, cardinality and participation indicated. You will need to normalize all of your entities, to resolve any many to many relationships. Observe the following restrictions when creating your scenario: • Include a specialization hierarchy, with super types and overlapping or disjoint sub types • Include entities to model time-variant data • Include an example of both composite and surrogate primary keys • One (or more) of your entities must have a numeric field • One (or more) of your entities must contain an alphanumeric (varchar) field • Do not have include cyclic relationship (A->B->C->A) Your attribute names, primary and foreign keys should be indicated as per the conventions given in the lecture slides (i.e. attributes as proper nouns, primary key underlined and foreign keys in italic.

The Student, Instructor and Professor entities may have a super-type and sub-type relationships i.e. A Person entity may act as a super-type entity. The Student, Instructor and Professor are sub-type entities. This is required in your assignment specification. . You must use the symbols as show. i.e. Dis-joint (D) vs Overlap (O) & Complete (double line) vs Incomplete (single line).
You must show Identifying or non-identifying relationships. Also called Weak vs strong relationship. (i.e. dotted line vs Solid line). e.g. Department vs Instructor should be a dotted line. Need to check the while diagram.
You need to have a time variant data in an entity.. .  
You need an entity that has a composite primary key. Suggest that you have the StudentCourse (StudentID, CourseID, DateEnrolled, grade) 

 

Transcribed Image Text:

Course PK CourselD CourseName FK DepartmentID Professor PK ProfessorlD ProfessorNAme FK DepartmentID Department PK DeparttmentID FK PK ID DepartmentNAme StudebtCourse StudentID FK CourselD Student PK StudentID studentNAme FK gender Address Instructors PK InstructorID InstructorName FK DepartmentID Course PK CourselD CourseName FK DepartmentID Professor PK ProfessorlD ProfessorNAme FK DepartmentID Department PK DeparttmentID FK PK ID DepartmentNAme StudebtCourse StudentID FK CourselD Student PK StudentID studentNAme FK gender Address Instructors PK InstructorID InstructorName FK DepartmentID

Answer rating: 100% (QA)

Based on the given scenario for a University Course Registration System and the requirements listed lets discuss the points that are covered by the pr... View the full answer