Question: Conceptual Modeling: Create a conceptual model for the below requirements using the ER Model ( Specify your relationship types ) or EER model. You can
Conceptual Modeling: Create a conceptual model for the below requirements using the ER Model Specify your relationship types or EER model. You can use drawing tools to create your ER models.
Based on the project requirements and description provided, here's a conceptual database design:
Entities and Attributes:
Employee:
EmplID Primary Key
Name
SSN
Phone
Email
Address
Office Location
Date of Hire
Role FacultyStaff
DepartmentID Foreign Key referencing Department
Faculty:
Rank
Specialization
Areas of Research Interests
Areas of Teaching Interests
Staff:
Position
Department:
DepartmentID Primary Key
Name
Phone
Office Location
Chairperson Foreign Key referencing Employee
Chairperson Start Date
Secretary Foreign Key referencing Employee
Secretary Start Date
Course:
CourseID Primary Key
Course Name
Course Code
Hours
Credits
Description
DepartmentID Foreign Key referencing Department
CourseSection:
SectionID Primary Key
CourseID Foreign Key referencing Course
Semester Year
Room Number
Schedule
InstructorID Foreign Key referencing Employee
Major:
MajorID Primary Key
Name
Description
Type of Degree
Total Credits Required
AdvisingFacultyID Foreign Key referencing Employee
Student:
EmplID Primary Key
First Name
Middle Initial
Last Name
Date of Birth
Email
Phone
Address
Graduate:
EmplID Primary Key, Foreign Key referencing Student
Graduation Year
Degree Earned
Honors
GPA
Current Job TitleOccupation
EmployerID Foreign Key referencing Employer
Employer:
EmployerID Primary Key
Employer Name
Industry
Address
CheatingIncident:
IncidentID Primary Key
Date
Description
Resolution
StudentID Foreign Key referencing Student
SectionID Foreign Key referencing CourseSection
Enrollment:
StudentID Foreign Key referencing Student
SectionID Foreign Key referencing CourseSection
Grade
Relationships:
Employee FacultyStaff: OnetoOne An employee can either be faculty or staff
Employee Department: ManytoOne Many employees can belong to one department
Faculty Major: ManytoMany A faculty member can advise multiple majors, and a major can have multiple advising faculty
Department Course: OnetoMany One department can offer multiple courses
Course CourseSection: OnetoMany One course can have multiple sections
CourseSection Instructor: ManytoOne Many sections can be taught by one instructor
Major Student: ManytoMany A student can pursue multiple majors, and a major can have multiple students
Student Graduate: OnetoOne One student can become one graduate
Graduate Employer: ManytoOne Many graduates can work for one employer
CourseSection Enrollment: ManytoMany Many students can enroll in many course sections
Student CheatingIncident: OnetoMany One student can have multiple cheating incidents
CourseSection CheatingIncident: OnetoMany One course section can have multiple cheating incidents
This design captures the relationships between various entities involved in managing employees, courses, majors, students, graduates, employers, and incidents like cheating. Adjustments can be made based on specific business rules and requirements.
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
