1 / 9

E-R Diagram for a University Enterprise

E-R Diagram for a University Enterprise. Schema Diagram. Relational Schemas. Classroom ( building , room-number , capacity) Department ( dept-name , building, budget) Course ( course-id , title, dept-name, credits) Instructor ( ID , name, depart-name, salary)

mufutau-lawrence
Download Presentation

E-R Diagram for a University Enterprise

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. E-R Diagram for a University Enterprise

  2. Schema Diagram

  3. Relational Schemas Classroom (building, room-number, capacity) Department (dept-name, building, budget) Course (course-id, title, dept-name, credits) Instructor (ID, name, depart-name, salary) Section (course-id, sec-id, semester, year, building, room-number, time-slot-id) Teaches (ID, course-id, sec-id, semester, year) Student (ID, name, dept-name, tot-cred) Takes (ID, course-id, sec-id, semester, year, grade) Advisor (s-ID, i-ID) Time-slot (time-slot-id, day, start-time, end-time) Prereq (course-id, prereq-id)

  4. Sample Queries • A list of the names of those instructors who are in the Physics department. • Find the ID, name, department and salary for those instructors whose salary is greater than $80000. • Find the ID (only) for those instructors whose salary is greater than $80000. • Find the names of all instructors whose department is in the Watson building. • Find the ID numbers for those courses that were taught in the Fall 2009 semester, the Spring 2010 semester, or both. • Find the ID numbers for those courses that were taught in the Fall 2009 semester and in the Spring 2010 semester. • Find the ID numbers for those courses taught in the Fall 2009 semester, but not in the Spring 2010 semester. • Find those instructor salaries that are not the maximum. • Find the largest instructor salary. • Find the names of those computer science instructors, along with the titles of all courses that the instructor teaches. • Find the monthly salary for each instructor; include the instructor name in the result. • Find the average salary for each department; include the department name in the result. • Final the ID numbers for those students who have taken all courses offered in the Biology department.

More Related