3. Suppose you are asked to build a database application P for a bicycle rental shop. Assume your database is to track customers, bicycles, and rentals. Explain the steps that need to be taken to develop this application. Specify entities and their relationships. Build an E-R diagram. Ensure your diagram shows both minimum and maxi- mum cardinalities. Transform your E-R diagram into a relational design.

3. Suppose you are asked to build a database application P for a bicycle rental shop. Assume your database is to track customers, bicycles, and rentals. Explain the steps that need to be taken to develop this application. Specify entities and their relationships. Build an E-R diagram. Ensure your diagram shows both minimum and maxi- mum cardinalities. Transform your E-R diagram into a relational design.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 3TD

See similar textbooks

Similar questions

The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.
Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.
Please written by computer source Part I - Modeling You are building a database for a comic book store customer management system. Given the database specification below, your job is to turn the specification into an ER diagram. Your notation must be consistent with the notation used in our lecture notes. You can use all constructs and notations discussed in our lecture notes and nothing else (i.e.. oven notations used in the textbooks but not in our lectures cannot be used). Your ER diagram should capture all the information and constraints in the specification but, at the same time, be minimal. It means that redundant entities, relationships, attributes and constraints should be avoided. You may use any drawing tool of your choice (for example, Dia, diagrams.net, Lucidchart, etc.) to draw your ER diagram. Hand drawings will not be accepted. Database Specification The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should…
ER Modeling 3. You will prepare an ER diagram describing the schema of a University database. High Achievers University (HAU) would like you to design a database that tracks its adminis- trative operations, and helps them monitor their energy usage across campus. HAU consists of departments, research groups, and employees. For each department, the database should record the department name, and the department's unique identifier. Research groups belong to exactly one department, and the database stores the research group ID, name, and its monthly budget. Each research group has to have at least one employee working in it, and is assigned at most one room as workspace. For each employee, the University assigns a unique employee ID, and records the employee's last name, first name, telephone number, address, salary, gender, data of birth, and his/her years of service. An employee may work in zero or more research groups. An employee may be a department chair. If so, they can be the chair…
Consider the E-R diagram for a university database as shown in Figure 1. What is NOT true about instructorand department?(a) A department may have many instructors.(b) An instructor may be associated with multiple departments.(c) An instructor may exist without being associated with any department.(d) none of the above
Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints. Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. Consider the following set of requirements for a UNIVERSITY database that isused to keep track of students’ transcripts. The university keeps track of each student’s name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications…
Design a relational database schema from the Car Sharing IS domain class diagram. Output should look like image number 2
ER-diagrams are high-level design of the Database. The given ER-diagram describes the Dentist office and service details. are there strong and weak entities, recursive relationships and different attribute types are involved ? would you identify what eachentity are relationship are and to describe all constraintsrelated to them