Friday, June 8, 2007

Question 69

The chart below shows the output from of a transaction detail report by sales office and by customer. Of the related database tables obtained by this form, which table is in third normal form? Here, trasaction numbers are serial numbers by customer and discounts are calculated by multiplying the discount rate by product and the unit price.

a) Customer (Customer_number, Customer_name, Customer_business_category_code, Business-category_name)
b) Product (Product_code, Product_name, Unit_price, Discount_rate)
c) Transaction (Custome_number, Total_amount, Total_discount, Consumption_tax, Same-day_transaction_amount)
d) Transaction details (Transaction_number, Product_code, Qty, Amount)

answer

No comments: