quastion is draw ER digram ? Project Description: You need to develop a management information system to help users at the administration level of the university easily viewing/tracking various information about students , information about number modules had taken by students , information about departments, Name of the lecturers are teach the course and information about courses . Data Model: We need to store information about university organized into colleges .each college has college number, college name. Each department has dep_number dep_name and locations .each lab has number and lab name . We store each student's number, name(last_name,first_name)address contain (zip, street city), birthdate, age . Each department offers several coursers. Each course identified by code,coures_name .each course has many perquisite and Students enroll in many course by semester and year. Each lecturer has lecturer _id , lecturer name ,mails ,salary address Each course is taught by a lecturer from the appropriate department, and each lecturer teaches many students. Each department has many office .each office has number, name and phone . Each lecturer has a unique office. Each course has many sections and section has section _id, semester and year, Section identified by course Each teachers may have a number of DEPENDENTs. For each dependent, we keep track of their name, sex, birthdate. Other requirements are as follows. 1- Every college has many departments. 2- Each college has many labs. 3- Each teacher manage one department. 4- Each teacher works for one department 5- Each course enroll by many student Below are some tables in the schema of the database: 1- college {col_no, name} 2- department{dep_number, col_no,dep_name} In each relation, the underlined attribute is the primary key of that relation.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 6HOA

See similar textbooks

Related questions

Concept explainers

Question

quastion is draw ER digram ?
Project Description: You need to develop a management information system to help users at the administration level of the university easily viewing/tracking various information about students , information about number modules had taken by students , information about departments, Name of the lecturers are teach the course and information about courses .

Data Model: We need to store information about university organized into colleges .each college has college number, college name. Each department has dep_number dep_name and locations .each lab has number and lab name . We store each student's number, name(last_name,first_name)address contain (zip, street city), birthdate, age . Each department offers several coursers.

Each course identified by code,coures_name .each course has many perquisite and

Students enroll in many course by semester and year. Each lecturer has lecturer _id , lecturer name ,mails ,salary address Each course is taught by a lecturer from the appropriate department, and each lecturer teaches many students.

Each department has many office .each office has number, name and phone . Each lecturer has a unique office.

Each course has many sections and section has section _id, semester and year,

Section identified by course

Each teachers may have a number of DEPENDENTs.

For each dependent, we keep track of their name, sex, birthdate.

Other requirements are as follows.

1- Every college has many departments.

2- Each college has many labs.

3- Each teacher manage one department.

4- Each teacher works for one department

5- Each course enroll by many student

Below are some tables in the schema of the database:

1- college {col_no, name}

2- department{dep_number, col_no,dep_name}

In each relation, the underlined attribute is the primary key of that relation.

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.