Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Students also viewed these Databases questions

Question

107 MA ammeter 56 resistor ? V voltmeter

Answered: 1 week ago

Question

Generally If Drug A is an inducer of Drug B , Drug B levels will

Answered: 1 week ago