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
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. 20RQCh. 2 - Prob. 22RQCh. 2 - Prob. 23RQCh. 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. 16P
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_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_forwardQ2/II draw the entity relationship for each of the following: 1-" a student studies one or many modules and a module is studied by one or many students". 2-" a manager leads one or many employees and an employee is led by one and only one manager". 3-" a manager leads one or many employees and an employee is led by one and only one manager and if there is a manager who has no employees to lead". 4- "a classroom has one and only one lecturer to manage and a lecturer has one and only one classroom". 5- "each classroom has one or many students registered in and a student has one or many classrooms to be registered in".arrow_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_forwardUse case diagram Use tool to draw Please provide Correct answerarrow_forwardDraw 1 . Question diagramarrow_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_forwardExplain this diagram in terms of proper and improper handoff.arrow_forwardDraw 1st diagram.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