This question asks you to develop a database from spreadsheet data.

You are given a sample list of transactions for Online Management Training Inc,

which includes columns below:

Cust ID Region Payment Source Amount Product Time of Day

(A) Design a database that keeps track of customer information. Add other

fields that hold customer information in addition to the CustID. Indicate

at least two tables in the relational database that will hold the data

above.

(B) Show the attributes and fields in each table. Indicate the primary key in

each table.

(C) Draw an entity relationship diagram. Make up

sample data with three rows of data in each table.