A university registrar's office maintains data about the following entities: courses including number, title, credits, syllabus, and prerequisites; course offerings, including course number, year, semester, section number, instructor, timings, and classroom; students, including student- id, name, and program; and instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an E-R diagram for the registrar's office. Document all assumptions that you make about the mapping constraints.

A university registrar's office maintains data about the following entities: courses including number, title, credits, syllabus, and prerequisites; course offerings, including course number, year, semester, section number, instructor, timings, and classroom; students, including student- id, name, and program; and instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an E-R diagram for the registrar's office. Document all assumptions that you make about the mapping constraints.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 8HOA: Create a table named REP_CONTRACTS containing the columns listed in the following chart A composite...

See similar textbooks

Similar questions

List the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade.
A university registrar's office maintains data about the following entities: courses including number, title, credits, syllabus, and prerequisites; course offerings, including course number, year, semester, section number, instructor, timings, and classroom; students, including student- id, name, and program; and instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an E-R diagram for the registrar's office. Document all assumptions that you make about the mapping constraints. اضف ملف
A university registrar's office maintains data about the following entities: (a) courses, including number, title, credits, syllabus, and prerequisites; (b) course offerings, including course number, year, semester, section number, instructor (s), timings, and classroom; (c) students, including student-id, name, and program; and (d) instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an E-R diagram for the registrar's office. Document all assumptions that you make about the mapping constraints.
Requirement analysis: Course evaluation must have a student, the students relation contains a unique student id, full name for each student, email address, phone number, address and date of birth. For each course, the courses contain course id, course name and credit. Each student can take many courses. For each Instructor, the instructors contain id, name and email. Each instructor can instruct many courses. For each section, the sections contain section id, year and semester. Students are able to evaluate the current courses. ER-diagram: Please complete the ER diagram using Microsoft word. Instructor ID Full name Email Student ID Full name Email Phone number Address Date of birth Course ID Course title Description Credit Section ID Year Semester Please Complete the diagram on MS word.
1. Display the last name and salary for all employees whose salary is not in the range of $5,000 and $12,000. 2. Display the employee last name, job ID, and start date of employees hired between February 20, 1998, and May 1, 1998. 3. Display the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50. 4. Display the last name, job, and salary for all employees whose job is sales representative or stock clerk and whose salary is not equal to $2,500, $3,500, or $7,000. 5. Display the last name, salary, and commission for all employees whose commission amount is 20%. Note: this question is related from database subject.
Your university runs many hundreds of courses each semester and needs to keep track of key information on each one. Among the data needed for each course would be the following: - University course identification number - Department course ID and section number (for multiple sections of the same course) - Number of credits for the course Days and times the course meets - Room in which the course meets (building ID and room number) Maximum course enrollment Campus on which the course is held - Name of the course instructor - Number of students currently enrolled and the student ID of each such student - Course status: open (for additional enrollment), closed, or canceled You must be able to change the value of each of these ten data items and, upon request, display all of this information. Initially, the values of the first seven items are known–the last three aren't. Design and implement an abstract data type that can be used to model this university course entity.
how to build a bookstore database with Entities for Tables Books This entity will store information about the books in the bookstore, such as title, author, publisher, and publication date. The table could also include additional fields such as genre, language, and the number of pages. Authors This entity will store information about the authors of the books in the bookstore, such as name, date of birth, nationality, and biography. The table could also include additional fields such as gender, education, and awards. Bookstore Members This entity will store information about the bookstore members, such as name, address, phone number, email address, and membership status. The table could also include additional fields such as date of birth, occupation, and membership type.
After sending your resume to an employer, he/she asked you for references. For each and every reference, you have to give the following information: Select one : a. name, place of work, and phone number b name , phone number , and email c , name , address , and email d . name , phone number , and address
A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number • Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale The average price of a computer was sold by the retailer In which months less than 100 computers were sold
Create own tables List the details of any works of art (including the Artist who created the work) that have more than three copies recorded in the database (i.e., a work that is listed in the database three times). List the details of any work of art (including the Artist who created the work) that has a Surrealist style. List the details of the works of art (including the Artist who created the work, and the acquisition and asking price details) currently held in the gallery (e., works of art that have not been sold). List the sales for each customer (e., when a customer purchases a work of art from the Gallery, a transaction line is created. For a purchase, there will be values in the DateSold and SalesPrice columns). The query should include the details of the customer, the transaction and the work of art purchased. List the names of the deceased artists and the number of years of age they were when they died (for example, an artist born in 1950 and deceased in 2001 has an age of…
Display job Title, the difference between minimum andmaximum salaries for jobs with max salary in the range10000 to 20000. (Database Systems)
Question 2: For the following table find the relevant Functional Dependencies and resolve them till third normal form. Course Code Course Title Level Mode of Attendance Course Fee Start Date End Date Student ID Num. 14111 14332 14378 Student Name Alan Briggs Susan McBride David Adair 23 Business Accounting 3 Part Time £55.00 20/08/2016 24/08/2016 Student Address 24 Abbey Park, Bangor, BT19 1RT 19 Belmont Road, Bangor, BT19 3TR 14 Grange Park, Bangor, BT19 4TF Student Telephone 028 91468665 07798754623 Department Tutor Dept Head Student DOB 10/08/94 Business Trevor Albright Mr Alan Parkes 028 91584630 06/11/87 07891834277 to Enrolment Date 10/06/16 028 91488930 01/03/93 03/07/16 07891454235 05/07/16 Enrolled By:- Andrea Gilchrist David Smythe Andrea Gilchrist