Question: Create an Entity - Relationship Diagram ( ERD ) based on the following entities and their relationships. The ERD should visually represent the structure of
Create an EntityRelationship Diagram ERD based on the following entities and their relationships. The ERD should visually represent the structure of the database, including entities, attributes, primary keys, foreign keys, and the relationships between entities. Use standard ERD notation eg rectangles for entities, diamonds for relationships, and lines to connect them
### Entities and Attributes:
User
UserID Integer Primary Key
First Name String
Middle Name String
Last Name String
Gender String
Date of Birth Date
House Number String
Street Name String
City String
State String
Zip Code Integer
Phone Number String
User Type String: Student, Faculty, Admin
Login
UserID Integer Primary Key, Foreign Key references User
Email String
Password String
Student
StudentID Integer Primary Key, Foreign Key references User
Student Year String
Student Type String
Undergraduate
StudentID Integer Primary Key, Foreign Key references Student
DepartmentID Integer Foreign Key references Department
Undergraduate Student Type String
Graduate
StudentID Integer Primary Key, Foreign Key references Student
DepartmentID Integer Foreign Key references Department
Program String
Graduate Student Type String: MastersPhD
Faculty
FacultyID Integer Primary Key, Foreign Key references User
Specialty String
Rank String
Faculty Type String
Admin
AdminID Integer Primary Key, Foreign Key references User
Access Level Integer
Department
DepartmentID Integer Primary Key
Department Name String
ChairID Integer Foreign Key references Faculty
Email String
Phone Number String
Course
CourseID String Primary Key
Course Name String
DepartmentID Integer Foreign Key references Department
Number of Credits Integer
Description String
### Relationships:
User to Login: OnetoOne
User to Student: OnetoOne
User to Faculty: OnetoOne
User to Admin: OnetoOne
Student to Undergraduate: OnetoOne
Student to Graduate: OnetoOne
Faculty to Department: OnetoMany
Department to Course: OnetoMany
Course to Enrollment: OnetoMany
Student to Enrollment: OnetoMany
### Additional Instructions:
Ensure that all relationships are clearly labeled with cardinality eg onetoone, onetomany
Use appropriate symbols for primary keys and foreign keys.
Include any necessary subtypes and their relationships as outlined in the original prompt.
The final diagram should be clear, organized, and easy to read.
Please provide the ERD in a digital format eg PDF PNG suitable for presentation.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
