Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
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 French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected:
There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager.
The database will keep the start date and the end date for each manager.
The bakery needs to keep Employee’s name, ID number, Phone number, address, sex, position, and the salary.
Each employee work for a specific department.
Each employee has a supervisor.
Some employees have more than one position.
To keep contact with customers and provide customer services and marketing, the bakery requires customer’s name, address, Cnumber (which is unique for each customer), email, and the phone number.
The bakery sells many products, each product has a name and a price, and the calories’ amount.
The manager will be responsible of…
The French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected:
There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager.
The database will keep the start date and the end date for each manager.
The bakery needs to keep Employee’s name, ID number, Phone number, address, sex, position, and the salary.
Each employee work for a specific department.
Each employee has a supervisor.
Some employees have more than one position.
To keep contact with customers and provide customer services and marketing, the bakery requires customer’s name, address, Cnumber (which is unique for each customer), email, and the phone number.
The bakery sells many products, each product has a name and a price, and the calories’ amount.
The manager will be responsible of…
A university wants to set up a database to record details about its staff, the departments they belong to and the training they attended. The purpose of developing the database is keep the staff information such as staff identity number, staff name, staff address, staff telephone number, staff job title and staff salary. As for the staff telephone number, the database allows keeping more than one of the staff telephone numbers. For the department information, the database keeps the name of the department and its location. It is required that every staff belongs to at least one department. Also, it is required that each department has exactly one staff to lead the department. To improve staff self-development, the university encourages every staff to attend courses. Hence, the database keeps the course information such as the course name, course duration, and course cost. Each staff is required to attend at least one course. For one course, the university can approve a number of staff…
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 - What is a derived attribute? Give an example. What...Ch. 4 - Prob. 11RQ
Ch. 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. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11C
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
- You have been hired as an intern at the local community center. The center has a number of sports programs for youth. You have been asked to create a database to keep track of the programs and the youths who participate in these sports activities. The Community Center database must support the following requirements:i. For an activity, store its number and name, for example, 051, Track. Each activity has a cost associated with it.ii. For a participant, store his or her number, first name, and last name as well as the name, home telephone number, and cell telephone number of the parent or guardian primarily responsible for the participants.iii. One participant can enroll in many activities, and one activity can include many participants. One parent/guardian can have many participants.Based on these requirements:1. Identify and list the entities and attributes of those entities. 2. Identify and list the functional dependencies. 3. Without creating a set of dependency diagrams, write the…arrow_forwardThe 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, and Team colors Player: Player ID 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: Parent ID number, Parent last name, Parent first name, Home phone number, and Home address (Street, City, State, and Zip code) The following relationships must be defined: Team is related to Player. Team is related to Coach. Player is related to Parent. Connectivities and participations are defined as follows: A Team may or may not have a Player. A Player must have a…arrow_forwardWe would like to design a database to store information that is related to a charity agency, the database requirements are as follows: Information kept about each employee: Employee identification number (unique for each employee), username and password, name for each employee, date of birth, phone, and email. Information kept for each Donation: Donation identification number (unique for each donation), donation date, and donation type. Information kept for each donor: Donor identification number (unique for each donor), the donor name, the donor name stored separately (first name, second name, and last name), the donor address also stored separately (street number, street name, zip code, city), the phone, and the email. Information kept about each item donated: Item identification number (unique for each item), item name, and quantity. Information kept for each needed/supported family: Family name, number of members in the family, nationality, address, income, and phone…arrow_forward
- Based on the information given above, draw the conceptual EERD where you should include the enhanced features. You are required to design a database for a car championship. The requirements are as follows:In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race.Every race would have a specific race ID and a race name. In a race would consists of many cars and each race would have a record of the…arrow_forwardRead the scenario and answer the questions that follow Scenario You have been tasked to design a database for a new bank. The specifications for the database include: customer details include their name, address, phone, and National Identification number. A national identification number is required for each customer for all account types. A customer’s contact address includes street, city and country as well as two phone numbers (cellphone, office line). One customer can own at least one account and every account is identified by its numbers, type and balance. . A customer may own a savings, cheque or loan account. Questions i. Using an appropriate tool, draw the conceptual diagram for the proposed database. ii. Develop the logical model. iii. Define the physical schema for the proposed database. iv. Write SQL statements to implement the database. v. Populate each of the identified tables with 2 records.arrow_forwardBased on the information given below, draw the conceptual EERD where you should include the enhanced features. You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race. Every race would have a specific race ID and a race name. In a race would consists of many cars and each race would have a record of…arrow_forward
- An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.arrow_forwardWe would like to design a database to store information that is related to a charity agency, the database requirements are as follows: • Information kept about each employee: o Employee identification number (unique for each employee), username and password, name for each employee, date of birth, phone, and email. • Information kept for each Donation: o Donation identification number (unique for each donation), donation date, and donation type. • Information kept for each donor: o Donor identification number (unique for each donor), the donor name, the donor name stored separately (first name, second name, and last name), the donor address also stored separately (street number, street name, zip code, city), the phone, and the email. • Information kept about each item donated: o Item identification number (unique for each item), item name, and quantity. • Information kept for each needed/supported family: o Family name, number of members in the family, nationality, address, income, and…arrow_forwardA learning company wants to set up its database. They are trying to keep track of the following: student ID, name, grade level, the subject they need help in, and their contact and payment information. They also want to keep track of the teacher’ information such as their ID, name, subject matter expertise, and times available and rate. They will like to keep track of which student is assigned to which teacher and their meeting schedule as well. Question 1: List all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table Question 2: Use the normalization technique and form the 3NF tablesarrow_forward
- A Cougars Real Estate Inc. (CRE) sells houses. People who want to sell their houses sign a contract with CRE and provide information on their house such as the current owner’s SSN, the owner’s name, the address of the house, the number of rooms, the number of baths, and the square feet of the house to a staff of CRE who is responsible for the management of house information. Then, the information is entered into the database by the staff of CRE. This information is kept in a database and a subset of this information is sent to the citywide multiple listing service used by all real estate agents. CRE works with two types of potential buyers. Some buyers have an interest in one specific house. In this case, advising specialists of CRE (advising specialists don’t manage the house information) print information from its database, which the advising specialists use to help show the house to the buyer. Other buyers seek CRE’s advice in finding a house that is wider than 2000 sq ft. In this…arrow_forwardA Cougars Real Estate Inc. (CRE) sells houses. People who want to sell their houses sign a contract with CRE and provide information on their house such as the current owner’s SSN, the owner’s name, the address of the house, the number of rooms, the number of baths, and the square feet of the house to a staff of CRE who is responsible for the management of house information. Then, the information is entered into the database by the staff of CRE. This information is kept in a database and a subset of this information is sent to the citywide multiple listing service used by all real estate agents. CRE works with two types of potential buyers. Some buyers have an interest in one specific house. In this case, advising specialists of CRE (advising specialists don’t manage the house information) print information from its database, which the advising specialists use to help show the house to the buyer. Other buyers seek CRE’s advice in finding a house that is wider than 2000 sq ft. In this…arrow_forwardThe administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College'sTravel Far But Slowly (TFBS) Center. Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required, destination,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author: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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
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