Design a database that keeps track of customer information

Assignment Help Database Management System

Reference no: EM131803761

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.

Reference no: EM131803761

Questions Cloud

Why are agile requirements adopted : Why are agile requirements adopted when requirements are difficult to specify? Please provide specific details, at least five if you can.

Compute the present value of each options : Compute the Present Value of each of these options if you expect the interest rate

Review the foreign corrupt practices act : Review the Foreign Corrupt Practices Act online. Write a brief paragraph explaining how this statute relates to Moore's dilemma.

Major models of ultimate reality : Friedrich Nietzsche and Martin Luther King, Jr. are representatives of 2 major models of ultimate reality:

Design a database that keeps track of customer information : Design a database that keeps track of customer information. Add other fields that hold customer information in addition to the CustID.

How method envisions moving into foreign markets : What is innovative about how method envisions moving into foreign markets? Would method's strategy for global expansion work for other companies or industries?

Determining the supply of haircuts : If the price rises to $15 per haircut, barbers will work much longer hours, and the supply of haircuts will increase to 300.

Quality and its maintenance of your selected company : Quality and its maintenance of your selected company

Using a news article from the last eight weeks : Presidents play many roles. Using a news article from the last eight weeks, demonstrate which is most important and why.

User Account

All Pages