Question: Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust#, Cname, City) ORDER (Order#, Odate, Cust#, Ord_Amt) ORDER_ITEM (Order#, Item#,

Consider the following six relations for an order-processing database application in a company:
CUSTOMER (Cust#, Cname, City)
ORDER (Order#, Odate, Cust#, Ord_Amt)
ORDER_ITEM (Order#, Item#, Qty)
ITEM (Item#, Unit_price)
SHIPMENT (Order#, Warehouse#, Ship_date)
WAREHOUSE (Warehouse#, City)
Here, Ord_Amt refers to total dollar amount of an order; Odate is the date the order was placed; Ship_date is the date an order (or part of an order) is shipped from the warehouse. Assume that an order can be shipped from several warehouses. Specify the foreign keys for this schema, stating any assumptions you make. What other constraints can you think of for this database?

Step by Step Solution

★★★★★

3.36 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Strictly speaking a foreign key is a set of attributes but when that set contains only one attribute ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2276).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the following relations for an order-processing application database at ABC, Inc. ORDER (O#, Odate, Cust#, Total_amount) ORDER-ITEM (O#, I#, Qty_ordered, Total_price, Discount%) Assume that...

Consider the following relational schema and SQL query. The schema captures information about employees, departments, and company finances (organized on a per department basis). Emp(eid: integer,...

Consider the following set of normalized relations from a database used by a mobile service provide to keep track of its users and advertiser customers. Assume that the mobile service provider has...

Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust#, Cname, City) ORDER (Order#, Odate, Cust#, OrdAmt) ORDERITEM (Order#, Item#, Qty) ITEM...

Need some help with this practice assignment, use the below images (Relational Model) to complete questions. Purpose: How to get familiar with the Relational Model basics. 1. (3.11 Elmasri-6e) -...

Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust\#, Cname, City) ORDER (Order\#, Odate, Cust\#, Ord_Amt) ORDER_ITEM (Order\#, Item\#,...

Amber Corporation holds 70 percent of Newtop Company's voting common shares but none of its preferred shares. Summary balance sheets for the companies on December 31, 20X1, are as follows: Neither of...

The average price of milk per gallon was $2.48 in 1995 and $3.42 in 2010. The consumer price index was 152.4 in 1995 and 218.1 in 2010. Therefore, the real price of milk in 2010 expressed in 1995...

The value of an investment after one or more time periods is called the: Group of answer choices true value. future value. present value. discounted value. complex value.

Describe a current process that you are utilizing in your project work, which has the potential for becoming a Best Practice process for the organization.

Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each...

When is the concept of a weak entity used in data modeling? Define the terms owner entity type, weak entity type, identifying relationship type, and partial key.

Under what conditions can an attribute of a binary relationship type be migrated to become an attribute of one of the participating entity types?

Your Christmas ski vacation was great, but it unfortunately ran a bit over budget. All is not lost: You just received an offer in the mail to transfer your $12,800 balance from your current credit...

emaining Time: 39 minutes, 57 seconds. zuestion Completion Status: BID OR ASK? SHARES PRICE Bid 500 $32.50 Bid 300 $32.50 Bid 400 $32.56 Bid 1.000 $32.60 Bid 400 $32.64 Bid 1,200 $32.64 Bid 300...

Assume a file containing a series of integers is named numbers.txt and exists on the computer's disk. Write a program that displays all of the numbers in the file. In python 3.0 please provide a...