Question: Can you create an entity relationship diagram using the following entities, attributes, and relationship: Student: Attributes: StudentID ( PK ) , FirstName, MiddleInitial, LastName, SSN
Can you create an entity relationship diagram using the following entities, attributes, and relationship:
Student:
Attributes: StudentID PK FirstName, MiddleInitial, LastName, SSN Address Street City, State, ZIP BirthDate, Gender, PhoneNumbers multivalued Class, MajorDepartmentID FK MinorDepartmentID FK DegreeProgram
Department:
Attributes: DepartmentID PK Name, DepartmentCode unique College
Course:
Attributes: CourseID PK CourseName, CourseDescription, CourseNumber unique SemesterHours, OfferingDepartmentID FK
Section:
Attributes: SectionID PK Semester, Year, SectionNumber, CourseID FK
Instructor:
Attributes: InstructorID PK SSN Name, Rank, AssignedDate, BelongsToDepartmentID FK
Enrollment:
Attributes: EnrollmentID PK StudentID FK SectionID FK Grade
Prerequisite:
Attributes: PrerequisiteID PK CourseID FK PrerequisiteCourseID FK
Relationships:
Student Department:
Type: ManytoOneDescription: A student belongs to one major department or General Studies if undecided and optionally one minor department.
Department Course:
Type: OnetoManyDescription: A department offers multiple courses.
Course Prerequisite:
Type: OnetoMany SelfreferencingDescription: A course can have multiple prerequisites.
Course Section:
Type: OnetoManyDescription: Each course has at least one section.
Section Instructor:
Type: ManytoManyDescription: Each section may have one or more instructors; an instructor can teach multiple sections.
Student Section Enrollment:
Type: ManytoManyDescription: A student can enroll in up to six sections, and a section can have multiple students.
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
