A Professor wants a database for his new University that will maintain data for the following entities with their attributes: a. Courses: title, credits, syllabus and prerequisites b. Course offered: course ID, year, semester, section number, instructor(s), timings and classroom. c. Students: student_ID, name and program d. Instructors: Instructors_ID, name, department and title They require a proper model to help with the enrolment of students into courses and rightfully graded after the course is rolled out. Construct an E-R diagram for the professor's University. Indicate all Primary keys, relationships and constraints. Document all assumptions that you make about the mapping constraints.

A Professor wants a database for his new University that will maintain data for the following entities with their attributes: a. Courses: title, credits, syllabus and prerequisites b. Course offered: course ID, year, semester, section number, instructor(s), timings and classroom. c. Students: student_ID, name and program d. Instructors: Instructors_ID, name, department and title They require a proper model to help with the enrolment of students into courses and rightfully graded after the course is rolled out. Construct an E-R diagram for the professor's University. Indicate all Primary keys, relationships and constraints. Document all assumptions that you make about the mapping constraints.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Data standardization usually focuses on fixing _ of data while data cleaning usually focuses on fixing _ of data. A- The entity; data dictionary B- The attribute; the entity C- The entity; the attribute D- Data dictionary; the entity
A DreamHome database has following tables. Branch (branchNo, street, city, postcode) Staff (staffNo, fName, lName, position, sex, DOB, salary, branchNo) PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo) PrivateOwner (ownerNo, fName, lName, address, telNo) Which is the correct relational algebra to express the following query? List the city and street of all branches which assistant staff’s salary is not greater than 9000 and age is at least 31. ( ) $$\Pi_{branchNo,street,city}(\sigma_{position='assistant' \wedge salary≤9000 \wedge DOB>'1-Jan-1990'} (Staff \bowtie Branch))$$ ( ) $$\sigma_{branchNo,street,city}(\Pi_{position=’assistant’ \wedge salary≤9000 \wedge DOB>’1-Jan-1990’}(Staff \cap Branch))$$ ( ) $$\sigma_{branchNo,street,city}(\sigma_{position=’assistant’ \wedge salary<9000 \wedge DOB>31}(Staff \bowtie Branch))$$ ( ) $$\Pi_{branchNo,street,city}(\sigma_{position=’assistant’ \wedge salary≤9000 \wedge…
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
You receive the following requirements for a caterer's database: For a customer, store a customer ID, last name, first name, billing address, and phone number For an order, store an order number, order date, event date, customer ID, description of services, and total price for services When designing this database, which step do you take first? a. Identify the customer ID and order number as unique identifiers. b. Identify and name the entities CUSTOMER and ORDER c. Identify customer ID, last name, first name, billing address, and phone number as attributes d. Create a CUSTOMER table that includes all the customers' attributes as columns
Question 7 On ERD, you can create attributes with the same name in different Entities. Question 7 options: True False
T. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
CASE STUDYStudy the DreamHome case study presented below to answer the following questionsDreamHome is a company that provides rental services to both home owners and clients. This case study describes the users’ requirements specification for the DreamHome database system.BranchesDreamHome has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market.StaffMembers of staff with the role of Supervisor are responsible for the…
Produce the 3NF for the following: Scenario 1 This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts (in other words, not a database but a flat one table file) You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the IN of the data OrderDate 10/20/2010 10/20/2010 10/20/2010 10/21/2010 10/21/2010 10/23/2010 10/21/2010 10/23/2010 10/23/2010 OrderNum 21608 PartNum AT94 DR93 NumOrdered 11 1 Description QuotedPrice $21.95 $495.00 $399.99 $329.95 S595 00 $794.95 $150.00 $495.00 00 0621S Iron 21610 Gas Range 21610 21613 DW11 Washer KL62 Dryer Dishwasher Home Gym Microwave Oven Gas Range Treadmill 21614 21617 ктоз 21617 CDS2 4. 21619 DR93 1. 21523 KV29
Database