Question: 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

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

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 department

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 Databases Questions!