Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4: Orders (orderId, customerId, dateOrdered, dateRequired, status) Customer(customerId, customerLastName, customer Street, customerCity, customer State, customerZip) Order Details (orderId.productId, quantity, lineNumber, amount) Products (productId, name, description, quantity, unitPrice) Account (account Number, customerId, date Opened, credit Card, mailing Street, mailing City, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of your choice. Make sure to have at least 4 tuples in each table. Make sure that all tables exhibits entity integrity and referential integrity constraints. Make sure to use good table layout in your answer. 2.3 (3 Points) For each of the following queries, write a relational algebra expression to answer the query: a) Find the id and last names of all customers who live on St. Anny St. in Blaine. b) Find the Customer last names and street address of all customers who have an order. c) Find the names, street address, and cities of residence for all customers who have ordered product number 310794. 2.4 (2 point) For each of the following relational algebra expressions, explain the output of the expression in words: a) credit card(OmailingZip-55444(account) b) customer_ID,accountNumber(customerCity="chicago (customer Daccount) Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4: Orders (orderId, customerId, dateOrdered, dateRequired, status) Customer(customerId, customerLastName, customer Street, customerCity, customer State, customerZip) Order Details (orderId.productId, quantity, lineNumber, amount) Products (productId, name, description, quantity, unitPrice) Account (account Number, customerId, date Opened, credit Card, mailing Street, mailing City, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of your choice. Make sure to have at least 4 tuples in each table. Make sure that all tables exhibits entity integrity and referential integrity constraints. Make sure to use good table layout in your answer. 2.3 (3 Points) For each of the following queries, write a relational algebra expression to answer the query: a) Find the id and last names of all customers who live on St. Anny St. in Blaine. b) Find the Customer last names and street address of all customers who have an order. c) Find the names, street address, and cities of residence for all customers who have ordered product number 310794. 2.4 (2 point) For each of the following relational algebra expressions, explain the output of the expression in words: a) credit card(OmailingZip-55444(account) b) customer_ID,accountNumber(customerCity="chicago (customer Daccount)
Expert Answer:
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these databases questions
-
Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. The R&C Stores database includes the...
-
Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. ) The Avion Sales database includes the...
-
Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to...
-
John and Jane Darling are newlyweds trying to decide among several available rentals. Alternatives were scored on a scale of 1 to 5 (5 best) against weighted performance criteria, as shown in Table....
-
The IASB requires a reconciliation between the effective tax rate and the governments statutory rate. Of what benefit is such a disclosure requirement?
-
At Martinez Company, checks are not pre numbered because both the purchasing agent and the treasurer are authorized to issue checks. Each signer has access to unissued checks kept in an unlocked file...
-
Recent financial statements for The Hoechst Group, a German conglomerate with operations in agriculture, chemicals, pharmaceuticals, and veterinary products are pre- ver sented as follows: The...
-
Wendy Dwyer established Outlaw Computer Services on January 1, 2011. The effect of each transaction and the balances after each transaction for January are shown below in the integrated financial...
-
Carla Vista needs to borrow $7 million for an upgrade to its headquarters and manufacturing facility. Management has decided to borrow using a five-year term loan from its existing commercial bank....
-
The propeller in Prob. 9.1 is replaced with a six-blade turbine 400 mm in diameter, and the fluid to be agitated is a pseudoplastic power law liquid having an apparent viscosity of 15 P when the...
-
You have collected data on monthly profits of a group of traders over time and you wish to model the evolution of trading profits and its dependence on traders characteristics, including gender,...
-
Simplify: 1 +42 4 2
-
The Government of Canada recently signed new preferential trade agreement, and has agreed to pay subsidies to turkey farmers to compensate for increased competition they may face from imports. You...
-
K Find f'(-3) if f(x)= +3 - 10x. 6 f'(-3)= (Simplify your answer. Type an integer or a fraction.)
-
How can mediation and arbitration be used to resolve conflicts, and what are their advantages and limitations compared to direct negotiations?
-
Find the volume of a pyramid with a height of 2 0 cm and a rectangular base with dimensions of 4 cm and 9 cm .
-
[C++] Need help with doubly linked list program ... My copy constructor, operator=, and explicit constructor are not working as I'd like them to. After some debugging: --- upon creating a node in...
-
Propose a reasonable mechanism for the following reaction. OH
-
Define the following terms: superclass of a subclass, superclass/subclass relationship, IS-A relationship, specialization, generalization, category, specific (local) attributes, and specific...
-
What is object-based storage? How is it superior to conventional storage systems?
-
What is a statistical database? Discuss the problem of statistical database security.
-
Figure 1-2 shows that organizational culture and the design of an AIS influence one another. What does this imply about the degree to which an innovative system I developed by one company can be...
-
One interesting property of digital assets is that they can be reproduced and dis tributed via the Internet at very little cost. What are some of the implications of having a product with a marginal...
-
Figure 1-2 shows that developments in IT affect both an organizations strategy and the design of its AIS. How can a company determine whether it is spending too much, too little, or just enough on...
Study smarter with the SolutionInn App