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 Entity-Relationship 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 (e.g., rectangles for entities, diamonds for relationships, and lines to connect them).
### Entities and Attributes:
1.**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)
2.**Login**
- UserID (Integer, Primary Key, Foreign Key references User)
- Email (String)
- Password (String)
3.**Student**
- StudentID (Integer, Primary Key, Foreign Key references User)
- Student Year (String)
- Student Type (String)
4.**Undergraduate**
- StudentID (Integer, Primary Key, Foreign Key references Student)
- DepartmentID (Integer, Foreign Key references Department)
- Undergraduate Student Type (String)
5.**Graduate**
- StudentID (Integer, Primary Key, Foreign Key references Student)
- DepartmentID (Integer, Foreign Key references Department)
- Program (String)
- Graduate Student Type (String: Masters/P.h.D)
6.**Faculty**
- FacultyID (Integer, Primary Key, Foreign Key references User)
- Specialty (String)
- Rank (String)
- Faculty Type (String)
7.**Admin**
- AdminID (Integer, Primary Key, Foreign Key references User)
- Access Level (Integer)
8.**Department**
- DepartmentID (Integer, Primary Key)
- Department Name (String)
- ChairID (Integer, Foreign Key references Faculty)
- Email (String)
- Phone Number (String)
9.**Course**
- CourseID (String, Primary Key)
- Course Name (String)
- DepartmentID (Integer, Foreign Key references Department)
- Number of Credits (Integer)
- Description (String)
### Relationships:
- User to Login: One-to-One
- User to Student: One-to-One
- User to Faculty: One-to-One
- User to Admin: One-to-One
- Student to Undergraduate: One-to-One
- Student to Graduate: One-to-One
- Faculty to Department: One-to-Many
- Department to Course: One-to-Many
- Course to Enrollment: One-to-Many
- Student to Enrollment: One-to-Many
### Additional Instructions:
- Ensure that all relationships are clearly labeled with cardinality (e.g., one-to-one, one-to-many).
- 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 (e.g., PDF, PNG) suitable for presentation.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!