Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 1.37PAE
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 solutionStudents have asked these similar questions
19. 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 = 456
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.
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.
Chapter 1 Solutions
Modern Database Management (12th Edition)
Ch. 1 - Prob. 1.1RQCh. 1 - Match the following terms and definitions:...Ch. 1 - Prob. 1.3RQCh. 1 - Prob. 1.4RQCh. 1 - Prob. 1.5RQCh. 1 - How are relationships between tables expressed in...Ch. 1 - What does the term data independence mean, and why...Ch. 1 - Prob. 1.8RQCh. 1 - Prob. 1.9RQCh. 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.20PAECh. 1 - Prob. 1.21PAECh. 1 - Prob. 1.22PAECh. 1 - Prob. 1.23PAECh. 1 - Prob. 1.24PAECh. 1 - Prob. 1.25PAECh. 1 - Great Lakes Insurance would like to implement a...Ch. 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 - Prob. 1.33PAECh. 1 - Prob. 1.34PAECh. 1 - Prob. 1.35PAECh. 1 - Prob. 1.36PAECh. 1 - Prob. 1.37PAECh. 1 - Consider the project data model shown in Figure...Ch. 1 - Prob. 1.39PAECh. 1 - Prob. 1.40PAECh. 1 - Helen Jarvis wants to determine the most important...Ch. 1 - In this chapter, we described four important data...
Knowledge Booster
Similar questions
- 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.arrow_forwardQuestion 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.arrow_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
- Do 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. 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_forwardHow can we choose which model to use while constructing our table with Microsoft Access serving as the basis?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.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 LearningDatabase 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