What other constraints can you think of for this database

Assignment Help Basic Computer Science

Reference no: EM131054261

Consider the following six relations for an order-processing database application in a company:

Here, Ord_amt refers to total dollar amount of an order; Odate is the date the order was placed; and 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?

Reference no: EM131054261

Questions Cloud

Single-step or multiple-step income statement : Identify the type of income statement: Is it a single-step or multiple-step income statement? Are there any extraordinary items or discontinued operations on the income statement?

What purpose photographic placards in crime scene photograph : What is the purpose of photographic placards (references) in a crime scene photograph? What is the purpose of taking two sets of photographs, one with placards, and one without?

Dollars worth of sales are generated : A firm hs net working capital of $462, net fixed assets of $2,217, sales of $6,000, and current liabilities of $800. How many dollars worth of sales are generated from every $1 in total assets?

Interest on investment in special college fund : Cynthia will begin college in 10 years and Don's financial advisor says that she can earn 8% interest on an investment in a special college fund. How much will Don have in the fund when Cynthia begins college?

What other constraints can you think of for this database : 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?

What is the difference between war driving and war chalking : What is the difference between War Driving and War chalking? What do you get from a cloud provider when you sing up for an infrastructure as a service (laaS) cloud computing model?

Create an expense on the income statement : Why do capital expenditures increase assets while other cash outflows, like paying salary, taxes, etc., do not create any asset, and instead instantly create an expense on the income statement that reduces equity via retained earnings? Explain in ..

Nominal rate of return on the bond : If a bond provides a real rate of return of 2.89 percent at a time when inflation is 3.21 percent. What is the nominal rate of return on the bond?

Question regarding the real rate of return : Last year, a bond yielded a nominal return of 7.37 percent while inflation averaged 3.26 percent. What was the real rate of return?

User Account

All Pages