Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 1.44PAE
Program Plan Intro
Explanation of the meaning of lines that connect CUSTOMER to ORDER and ORDER to INVOICE and the representation of its business.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
PK
SectionNo CourseName
1
Faculty
CourseNo
3305
Credits
MIS
3
TO0123456
3305
MIS
3
TO0235145
3307
4309
System Analysis
E-commerce
2
3
TO0123456
1
T00976550
(Business rule: A course may offer multiple sections)
1. Is the relation in the first normal form? Answer Yes or No. If your answer is
"yes", explain why you think that way. If your answer is No, explain why and
then normalize it to the 1st normal form. The relation should be in the 1NF
before you answer the second part of the question below.
2. Normalize the above relation(s) to the 2nd normal form. Please show the resulting
relations.
TAL Distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many customers. Using this information, convert the following unnormalized relation to fourth normal form.
Question 6.
Consider the following relation:
Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity)
FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address
FD2 - Customer_ID -> Customer_Name, Customer_Address
FD3 - Product_ID -> Product_Description, Price
FD4 - Order_ID, Product_ID -> Order_Quantity
What are the candidate keys of this relation?
Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF.
Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF.
Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.
Chapter 1 Solutions
Modern Database Management
Ch. 1 - Prob. 1.1RQCh. 1 - Prob. 1.2RQCh. 1 - Prob. 1.3RQCh. 1 - Prob. 1.4RQCh. 1 - Prob. 1.5RQCh. 1 - Prob. 1.6RQCh. 1 - Prob. 1.7RQCh. 1 - How are relationships between tables expressed in...Ch. 1 - What does the term data independence mean, and why...Ch. 1 - Prob. 1.10RQ
Ch. 1 - Prob. 1.11RQCh. 1 - Prob. 1.12RQCh. 1 - Prob. 1.13RQCh. 1 - Prob. 1.14RQCh. 1 - Prob. 1.15RQCh. 1 - Prob. 1.16RQCh. 1 - Prob. 1.17RQCh. 1 - Prob. 1.18RQCh. 1 - Prob. 1.19RQCh. 1 - Prob. 1.20RQCh. 1 - Prob. 1.21RQCh. 1 - Prob. 1.22RQCh. 1 - Prob. 1.23RQCh. 1 - Prob. 1.24RQCh. 1 - Prob. 1.25RQCh. 1 - Prob. 1.26RQCh. 1 - Prob. 1.27PAECh. 1 - Prob. 1.28PAECh. 1 - Prob. 1.29PAECh. 1 - Prob. 1.30PAECh. 1 - Prob. 1.31PAECh. 1 - Prob. 1.32PAECh. 1 - Great Lakes Insurance would like to implement a...Ch. 1 - Figure 1-22 shows an enterprise data model for a...Ch. 1 - Prob. 1.35PAECh. 1 - Prob. 1.36PAECh. 1 - Prob. 1.37PAECh. 1 - Prob. 1.38PAECh. 1 - Prob. 1.39PAECh. 1 - Prob. 1.40PAECh. 1 - Prob. 1.41PAECh. 1 - Prob. 1.42PAECh. 1 - Prob. 1.43PAECh. 1 - Prob. 1.44PAECh. 1 - Consider the project data model shown in Figure...Ch. 1 - Answer the following questions concerning Figures...Ch. 1 - Prob. 1.47PAECh. 1 - Helen Jarvis wants to determine the most important...Ch. 1 - In this chapter, we described four important data...
Knowledge Booster
Similar questions
- Question 8 Consider the below tables Customer CustomerNo (PK) Order Order No CustomerName 110 114 11 Ali AlMansoori 12 Sarah Sulaiman 13 Maha Al Ali OrderDate 10/01/2018 11/01/2018 116 14/01/2018 118 12/01/2018 120 14/01/2018 122 17/01/2018 CustomerAddress Block A, No. 6, Khalifa B Aljazeera Tower, Aprt 180, Corniche Rd Etihad Tower, Aprt 2022, Hamdan ST Order Amount 17000 8000 21000 22000 42500 50100 CustomerNo (FK) 11 12 12 13 11 13 Write a query to display the order number, order amount for all orders made by customer Sarah with amount greater than 8000, displaying orders made later first.arrow_forward19. Draw the query tree for the SQL statement below, then draw the optimized heuristic tree. PID is the Primary key of Provider SELECT Provider.Name, Networking.Name, Show.Name, Show.Description FROM Provider, Network, Show WHERE Provider.PID = Network.PID AND Show.NetworkID = Network.NetworkID AND Show.Rating > 4 AND Provider.PID = 456arrow_forwardConsider the following relation: Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity) FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address FD2 - Customer_ID -> Customer_Name, Customer_Address FD3 - Product_ID -> Product_Description, Price FD4 - Order_ID, Product_ID -> Order_Quantity What are the candidate keys of this relation? Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF. Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF. Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.arrow_forward
- How can we choose which model to use while constructing our table with Microsoft Access serving as the basis?arrow_forwardDo the tables in figure 1entity exhibit entity integrity? Why or why not?arrow_forwardGarden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services.arrow_forward
- Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services. Suppose Garden Glory decides to add the following table: SERVICE-FEE (PropertyID, ServiceID, Description, Amount) Add this table to what you consider to be the best design in your answer to part B. Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure 2-31? If not, modify the design so that this data will work. State the assumptions implied by this…arrow_forwardGarden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate)SERVICE (ServiceDate, Description, Amount) PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate)arrow_forwardGarden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services. Given your assumptions, comment on the appropriateness of the following designs: PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher: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