Seacrest Bedding is changing from a file-oriented system to a relational database system. Identify and design at least three tables that would be needed to capture data for a sales transaction. Each table should include a primary key, three non-key attributes, and foreign keys as necessary. Make up data values for two records within each table
What will be an ideal response?
Answer: Customer table; ID (primary key), name, street address, city, state, zip code, phone number, credit limit, salesperson ID (foreign key)
Salesperson table; ID (primary key), name, street address, city, state, zip code, phone number, hire date, commission rate, base salary
Sales table; sales invoice number (primary key), date, amount, sales tax, shipping charge, shipping method, customer ID (foreign key), salesperson ID (foreign key)
Inventory table; item ID (primary key), description, size, color, warehouse location, list price, quantity on hand
Sales-Inventory table; sales invoice number and item ID (concatenated primary key), quantity sold, sales price, extended amount
Students should also make up data values for two separate records for each table.
You might also like to view...
Carolyn, who is interested in marketing her company's diet products in Asia, studies the acceptable behavior, norms, and values in Asian markets. In this scenario, Carolyn studies her product's _______ in the Asian markets.
A. comparability B. billability C. partibility D. docility E. dissidence
Egan Company, a publicly-traded company, divides its operations into several operating segments. Determine which of the following segments are reportable and reconcile the reportable segments to the consolidated revenues and profits
External Revenues Intersegment Revenues Expenses Assets Travel agency $ 621,000 $ 700,000 $ 1,597,000 $ 1,540,000 Hotels 4,543,000 644,000 2,315,000 7,787,000 Amusement parks 2,400,000 220,000 1,570,000 1,940,000 Theater 2,180,000 116,000 2,640,000 1,441,000 Pro soccer team 700,000 - 898,000 1,340,000 Corporate-level items 100,000 - 250,000 200,000 Total $10,544,000 $1,680,000 $9,270,000 $14,248,000