Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 2, Problem 2P
Explanation of Solution
Crow’s Foot notation:
In the Crow’s Foot model by the three-pronged crow’s foot to exhibit the “many” side relationship.
- In this notation, “1”is represented as a short line segment.
- “M” is represented as three-pronged crow’s foot.
- The relationship name is represented above the relationship line.
Crow’s Foot ERD (Entity Relationship Diagram):
- The business rule in the problem 1 in the textbook describes about the relationship between AGENT and CUSTOMER and it is written as follows.
- One agent can have many customers, but each customer has only one agent...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the “1” to the “M” side, regardless of the orientation of the ERD components.)
FIGURE P2.15 THE CROW’S FOOT ERD FOR PROBLEM 15
9. Write the business rules that are reflected in the ERD shown in Figure P2.17.
FIGURE P2.17 THE CROW'S FOOT ERD FOR PROBLEM 17
THEATER
MOVIE
shows
recoves
REVIEWER
REVIEW
writes
Draw the EER diagrams for the following problems using UML notation, Crow’s Foot notation and Chen notation:
A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors. Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle registration number. The majority parking spaces are under cover and can be allocated for use by a member of staff for a monthly rate. Parking spaces that are not under cover are free to use when available. Up to twenty covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor’s vehicle license number.
Chapter 2 Solutions
Database Systems: Design, Implementation, & Management
Ch. 2 - Prob. 1RQCh. 2 - What is a business rule, and what is its purpose...Ch. 2 - How do you translate business rules into data...Ch. 2 - Prob. 4RQCh. 2 - Explain how the entity relationship (ER) model...Ch. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - Prob. 8RQCh. 2 - Prob. 9RQCh. 2 - Prob. 10RQ
Ch. 2 - What is a relationship, and what three types of...Ch. 2 - Give an example of each of the three types of...Ch. 2 - What is a table, and what role does it play in the...Ch. 2 - Prob. 14RQCh. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - Prob. 17RQCh. 2 - Prob. 18RQCh. 2 - Prob. 19RQCh. 2 - Prob. 21RQCh. 2 - Prob. 22RQCh. 2 - Prob. 1PCh. 2 - Prob. 2PCh. 2 - Prob. 3PCh. 2 - Prob. 4PCh. 2 - Prob. 5PCh. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Prob. 7PCh. 2 - Prob. 8PCh. 2 - Typically, a hospital patient receives medications...Ch. 2 - Prob. 10PCh. 2 - Prob. 11PCh. 2 - Prob. 12PCh. 2 - Prob. 13PCh. 2 - Prob. 14PCh. 2 - Prob. 15PCh. 2 - Prob. 16PCh. 2 - Prob. 17P
Knowledge Booster
Similar questions
- Assignment: Problem #7 from Chapter 4 of the textbook. The case study is United Helpers. With the use of Microsoft Visio, draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, optionalities, connectivities and cardinalities. In addition, be sure to include a heading on your ERD with a brief descriptive title, your name, and a date. It is suggest that you write out business rules but the rules do not need to be submitted. 7. How would you (graphically) identify each of the following ERM components in a Crow’s Foot notation? an entity the cardinality (0,N) a weak relationship a strong relationshiparrow_forwardDraw the EER diagrams for the following problems using UML notation, Crow’s Foot notation and Chen notation: A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors. Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle registration number. The majority parking spaces are under cover and can be allocated for use by a member of staff for a monthly rate. Parking spaces that are not under cover are free to use when available. Up to twenty covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor’s vehicle license number.…arrow_forwardFrom the use case model of your case study(any case study), list the basic flow of events for your most important use case List two alternate flows of events for the use case identified in the question abovearrow_forward
- The property X can be found in two different entity sets A and B, but their names are unimportant for this discussion. How may the design be improved if the two Xs are unrelated?arrow_forwardDraw 1 . Question diagramarrow_forwardWrite a miscellaneous problem show diagram, and must be multiple choice and show workarrow_forward
- draw Entity Relationship Diagram (ERD) for scenairo: “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager. Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking. The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a payment, the mother needs the…arrow_forwardI need to create a UML diagram from this questionarrow_forwardConvert the Chen diagram below to UML notation.Draw the class, association, and multiplicity.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 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