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 4, Problem 4P
Explanation of Solution
Entity Relationship (ER) Diagram:
The following figure illustrates the ER Diagram for given business rules using Crow’s Foot notation:
Explanation:
The above ERD, contains several entities such as “Customer”, “Invoice”, “Vendor”, “Product”, “Salessrep” and “Inv_Line”. Each entity has its own attributes.
- A customer can generates invoice form several sales representatives...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Using a document at your own school (for example, a class schedule), determine the attributes present in the document. Using your knowledge of the policies at your school, determine the functional dependencies present in the document. Use these dependencies to create a set of tables and columns that you could use to produce the document.
Create and ERD based on the Crow's Foot Model, using the following requirements. Include Primary Keys, Foreign Keys, and Relationship types (weak/strong):
1. An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative.
2. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices.
3. An INVOICE can include many detail lines(INV_LINE), each of which describes one product bought by the customer.
4. The product information is stored in a PRODUCT entity.
5. The product's vendor information is found in a VENDOR entity.
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them.
This data is stored in a relation (table) named PROJECT:
PROJECT (ProjectID, EmployeeName, EmployeeSalary)
Assuming that all functional dependencies are apparent in this data, which of the following are true?
ProjectID → EmployeeName
ProjectID → EmployeeSalary
(ProjectID, EmployeeName) → EmployeeSalary
EmployeeName → EmployeeSalary
EmployeeSalary → ProjectID
EmployeeSalary → (ProjectID, EmployeeName
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
Similar questions
- When we say that "Requirements need to be both full and consistent," what exactly do we mean by those two words?arrow_forwardWhat's the difference between overlapped and separate constraints?arrow_forwardGiven the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salim Housni 2000 200-B Salim Housni 2000 200-C Salim Housni 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE ProjectID --> EmployeeName (....) ProjectID --> EmployeeSalary (....) ProjectID , EmployeeName -->EmployeeSalary (....) EmployeeName --> EmployeeSalary (....) EmployeeSalary --> ProjectID (....) EmployeeSalary --> EmployeeName , ProjectID (....)arrow_forward
- Consider the File Structure for the XYZ Company Project Management data given below. Then, respond to each of the following questions related to the structure. ProjectCode ProjectManager MgrTelephone MgrLocation ProjBidPrice 31-205A Sami A. Allen 773-555-1216 2900 S. Federal St. Chicago, IL 60616 $46,000 37-403B Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle Creek, MI 49015 $1,342,000 33-906T Daisy B. Burns 773-555-8821 2543 W. Foster Ave. Chicago, IL 60625 $847,320 29-107D Alice M. Zane 773-555-1219 7202 Harrison Ave. Rockford, IL 61112 $1,449,000 21-929A Dean P. Pence 773-555-2222 6302 N. Northwest Hwy. Chicago, IL 60631 $903,117 41-386C Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle Creek, MI 49015 $1,805,000 26-903C Sami A. Allen 773-555-1216 123 Lane St. Chicago, IL 60616 $78,081 29-227A Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle…arrow_forwardUsing the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules:- A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. A patient may pay the bill directly, or…arrow_forwardQuestion 1: Create an ERD that can be implemented for a medical clinic, using at least the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor, and each appointment references a single patient. Emergency cases do not require an appointment. However, an emergency is entered into the appointment book as "unscheduled" for appointment management purposes. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. Each visit updates the patient's records to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be…arrow_forward
- What do we mean by "full and consistent" when we say that requirements should be?arrow_forwardRegional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-33 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary)A. Assuming that all functional dependencies are apparent in this data, which of the following are true? 1. ProjectID → EmployeeName 2. ProjectID → EmployeeSalary 3. (ProjectID, EmployeeName) → EmployeeSalary 4. EmployeeName → EmployeeSalary 5. EmployeeSalary → ProjectID 6. EmployeeSalary → (ProjectID, EmployeeName) B. What is the primary key of PROJECT? C. Are all the nonkey attributes (if any) dependent on the primary key? D. In what normal form is PROJECT? E. Describe two modification anomalies that affect PROJECT. F. Is ProjectID a determinant? If so, based on which functional dependencies in part A? G. Is EmployeeName a determinant? If so, based on…arrow_forwardCreate an ERD using Visio or any other tool for the following scenario. Your ERD should show all the tables, attributes for each table and identify all primary and foreign keys. A hair salon has many customers and many stylists - the first name, last name, and phone number need to be stored for customers and stylists. The hair salon offers many services - hair cutting, styling, coloring, permanents, etc. Each service has a cost and the estimated time. Customers schedule appointments with a stylist. The appointment can consist of one or more than one service - i.e. a person may want a hair cut and coloring. Some customers purchase products at their appointments. A product has a brand, description, category and price. Please show all work and the finished diagram. Thank you!arrow_forward
- Create a Crow’s Foot ERD to include the following business rules for the EaonCo company: Each sales representative writes many invoices. Each invoice is written by one sales representative. Each sales representative is assigned to one department. Each department has many sales representatives. Each customer can generate many invoices. Each invoice is generated by one customer.arrow_forwardWhat are the key distinctions between overlapping and disjoint constraints, and how do you distinguish between the two?arrow_forwardUsing the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. Show all connectivities, relationship…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage