Database Systems the Complete Book 2nd Edition An online se

###

Database Systems the Complete Book (2nd Edition)

An on-line seller of computers wishes to maintain data about orders. Customers can order their PC with any of several processors, a selected amount of main memory, any of several disk units, and any of several CD or DVD readers. The fact table for such a database might be:

Solution

1)

In the common meanings of the terms, quant and price would be dependent attributes, and the others would be dimension attributes.

2)

There is no one right answer. Here is a reasonable choice.

We have assumed that there is an ID attribute for every attributes of Orders; the ID\'s show in the tuples of Orders and link those tuples to tuples of the dimension tables. We utilize the same names for attributes of Orders and their corresponding dimension tables.

Customer (customerID, customerName, customerAddress, phone, creditCard)

Date(day, month, year)

Proc(proc ID, manufacture, model, name, speed)

Disk(diskID, manufacture, model, cylinders, capacity, surfaces, rotSpeed)

CD(cdID, manufacture, type, speed)