Database Systems: Design, Implementation, & Management
11th Edition
ISBN: 9781285196145
Author: Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 4, Problem 21RQ
Explanation of Solution
Entity Relational (ER) Diagram:
The following figure illustrates the ER Diagram for given business rules in Crow’s Foot notation:
Explanation:
The above ER diagram contains several entities such as “PARENT”, “REGISTER”, “PLAYER”, “COACH”, “TEAM” and “COLOR”. Each entity has its own attribute.
- The relationship between “PARENT” and “PLAYER” is M: N...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The local city youth league needs a database system to help track children who sign up to play soccer .Data needs to be kept on each team,the children who will play on each team,and their parents.Also data needs to be kept on the coaches for each team.Draw a data model with the entities and attributes described here.Entities required:Team,Player,Coach and Parent.Attributes required:Team:Team ID number,Team name,andTeam Colors,Player:PlayerID number,Player first name,Player last name,and Player age Coach: Coach ID number Coach First Name,Coach Last Name,and Coach home phone number Parent:ParentID number Parent last name ,Parent first name,Home phone number, and Home Address with street ,city ,state and zip code.The following relations must be defined:Team is related to Player.Team is related to Coach.Player is related to Parent.Conectivities and participation are define as follows:A Team may or may not have a Player.A Player must have a Team.A Team must have many Players.A Player has…
A public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario very carefully and draw entity relationship diagram (ERD) for the given system by identifying entities, attributes and relationship among these entities.
A hospital consists of various specialized wards where each ward has its unique ID, name and capacity (total number of beds for patients in each ward). Multiple patients can be admitted in each ward on the recommendations of the doctor. Each doctor has a unique id, name, specialization and etc. Furthermore, a specialized team of doctors in each ward will take care of admitted patients and suggest treatment for the patients (such as medication, recommended tests, date of admission, and date of discharge). Each ward…
Air-india want to create database to stores details about an airline’s fleet, flights, and seat bookings. Again, it’s a hugely simplified version of what a real airline would use, but the principles are the same. Draw an ER diagram based on the information given.Consider the following requirements list: • The airline has one or more airplanes.• An airplane has a model number, a unique registration number, and the capacity to take at most 100 passengers.• An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time.• Each flight is carried out by a single airplane.• A passenger has given names, a surname, and a unique email address.• A passenger can book at most 5 seats on a flight.[7](b) Convert the diagram 1(a) in relational model.
Chapter 4 Solutions
Database Systems: Design, Implementation, & Management
Ch. 4 - Prob. 1RQCh. 4 - What is a strong (or identifying) relationship,...Ch. 4 - Prob. 4RQCh. 4 - Suppose you are working within the framework of...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Discuss the difference between a composite key and...Ch. 4 - What two courses of action are available to a...Ch. 4 - Prob. 11RQCh. 4 - Discuss two ways in which the 1:M relationship...
Ch. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Briefly, but precisely, explain the difference...Ch. 4 - What are multivalued attributes, and how can they...Ch. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - What two attributes must be contained in the...Ch. 4 - Describe precisely the composition of the...Ch. 4 - Prob. 21RQCh. 4 - Prob. 1PCh. 4 - Create a complete ERD in Crows Foot notation that...Ch. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9C
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.Similar questions
- Develop a simple data model for a student database that includes student data, student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete entity relationship diagram that shows how these tables are related to one another.arrow_forwardThe many-to-many relationship between entities is not supported by which data model? Please explain the model's advantages and disadvantages.arrow_forwardDraw the ERD of the database that could be used to support the operations of the business described in the case Business Case: Bike with Us • Bike with Us is a bicycle rental company which has several offices in different neighborhoods of Montreal. Each office is identified by a Station_Code and its geographical location (i.e., latitude and longitude). • Each office is assigned one or more employees for different tasks. Attributes of employees include Employee_ID and Employee_Name. An employee must be assigned to only one rental office. • For each office, there is always one employee assigned to check bicycle conditions. • The office rents several classes of bicycles: road, mountain, electric bike, touring, folding, fixed gear. Each bicycle is managed by one office. Customers might rent bicycles from different offices in the city. • Bicycles are to be described by data such as: make, year of production, uses (purpose), size, registry number, purchase price, purchase date, rent…arrow_forward
- Exercise 3 Manufacturer A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Assumptions A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. List of Entities and the Attributes List of Relationship and Cardinalities Draw the Conceptual Model Draw the Logical Model with…arrow_forwardAir West Airlines is a regional carrier that operates primarily in the southwestern United States. Draw an ER diagram to capture the following information in a database for the airline company. An airport is identified by a unique airport code and has a location which consists of (city, state), an elevation, and one or more phone numbers. An airport may have several flights to arrive at it and depart from it. A flight has a unique flight number, a base fare, and the number of seats. A flight can arrive at one or more airports and depart from one or more airports. For each arrival, the scheduled arrival time should be recorded. For each departure, the scheduled departure time should be recorded. Each flight has one or more staff members in its crew. Each staff member (who may be an attendant or a pilot, but not both) has a unique ID number, a name, and a hire date. A staff member may be assigned to several flights. Each flight attendant has a date for an advanced certification. Each…arrow_forwardWhich data model does not support the many-to-many relationship between entities? Explain that model with advantages and disadvantages?arrow_forward
- The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.arrow_forwardDevelop a simple data model for a student database that includes student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete ER diagram that shows how these tables are related to on another.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning