Answered step by step
Verified Expert Solution
Question
1 Approved Answer
database question create an ER model users at the admintstration level of the university easily viewing/tracking various information about student how many student in department
database question
create an ER model
users at the admintstration level of the university easily viewing/tracking various information about student how many student in department well as information about sections, subject, department, and teachers. - Data Model: We need to store information about university management system; The university keeps track of each National ID number student's name, student number, current address and phone, address and phone, birthdate, gender, level, major department, minor department, The name of the student should have first, middle, and last names. The address should have apartment number, street number, city, state, postal code. Both National ID number and student number must be unique for each student. - Each college has college number and college name - Each department must be described by a name, department code and phones. Code must be unique for each department. - Each course has a course name, description, course number, number of credit hours and level number,. The course number should be unique for each course. - Each section has an instructor name, semester, year, section number. The section number must be unique and each course can have multiple sections taught during same semesteriyear. - A teacher has teacher id ,name (first name,last name ), email and salary Other requirements are as follows. 1- Every colleges has many departments. 2- Each student belongs to a major department. 3- Each department offers many course and each course offers by many department 4- Each section may be part of multiple courses. Sections are only identified through the course offering them 5- Each student can be enrolled in an arbitrary number of courses, and an arbitrary number of students can be enrolled in a course. 6- Each teacher teaches many course. 7- Each teacher work for one department. 8- Each teacher manages one departmentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started