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.