Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
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
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.
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. 21RQCh. 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. 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_forwardThe 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 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_forward
- Draw the Crow’s Foot solution of the business rules given below: A driver may receive many (driving) assignments. Each (driving) assignment is made for a single driver. A truck may be driven in many (driving) assignments. Each (driving) assignment is made for a single trucarrow_forwardManagement of information Systemarrow_forwardIt's possible to have a main key and a candidate key for the same characteristic.arrow_forward
- Draw an Entity Relationship Diagram for all of those below. (a simple one) Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for each course there is a unique code and title (not necessarily unique). There might be several lecturers in a course. Each course requires one or more text books. Each text book is used in at least one course. A text book is identified by a unique ISBN, and its title, authors, publisher and year of publication are known. Each course has a unique code. The bank has many customers. Every customer has at least one account with the bank. An account may be shared by several customers. Each customer has a unique number, type, the opening date and the balance. A flight carries many passengers on a specific airplane. Each airplane has a unique number, while each flight has a code (unique), destination and origin. A passenger has a name, passport number and nationalityarrow_forwardDraw a State Transition Diagram for the following B&B problem: Tom and Sue are starting a bed-and-breakfast in a small New England town. They will have three bedrooms for guests. They want a system to manage the reservations and to monitor the expenses and profits. When a potential customer calls for a reservation, they will check calendar, and if there is a vacancy, they will enter the customer name, address, phone number, dates, agreed upon price, credit card number, and room number(s). Reservation must be guaranteed by 1 day’s payment. Reservations will be held without guarantee for an agreed upon time. If not guaranteed by that date, the reservation will be dropped.arrow_forwardDraw an Entity Relationship diagram for modeling the following system. Use relational modelling techniques in your design. You are free to make reasonable assumptions for your model unless they conflict with the definition below. Also explain your design with a paragraph. [Caution: Create your solution using paper and pen. Then put the image of your solution here. Drawing/writing with computer tools will not be accepted. Also include your name and signature in the solution paper]Problem definition: “There is a need to keep track of data for a hospital. The hospital building consists of several departments. Each department is identified with its name. For each department, the following data should also be stored: the number of floors, opening hour, and closing hour. Each department has a number of rooms. Each room is identified by its room number, but there might be rooms with the same name in different departments. At each department, many doctors and nurses can work.A doctor is…arrow_forward
- Systems analysis and designarrow_forwardData modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forwardWhat are the key differences between the various UML diagrams, and how exactly are those differences manifested? Give a succinct explanation for each of the options.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:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author: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:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning