Developing new database system

Reference no: EM13171416

The following data is to be used in developing a new database system for a fictitious company:

Customer name
Customer address
Date of purchase
Amount of purchase
Item purchased
Quantity purchased
Salesperson
Invoice number
Item number

Design a set of relational tables to store this data. Do all of the data items need to be stored in a table? If not, which ones do not need to be stored, and why not?
Identify what data should be included in each table.

Reference no: EM13171416

Questions Cloud

Changing nature of scientific theories : Write an essay in which you use an example from the history of science that demonstrates the changing nature of scientific theories.

Hazards-emergencies and catastrophes used synonymously : The terms hazards, disasters, emergencies, and catastrophes are used synonymously, without consideration for their true differences. After reading your text please provide five examples of each term and explain why each of these examples would fall i..

Important concepts applicable to implementing IT project : There are two elements the IT manager must understand, track and skillfully intervene about where necessary. The first is to insure the CONTENT to be discussed in the meeting is appropriate, on-target and in the detail necessary to the task.

Persuaded to change an attitude-value-belief or behavior : Describe a time in which you were persuaded to change an attitude, value, belief, or behavior. Explain how you felt before the argument and why you felt this way.

Developing new database system : Design a set of relational tables to store this data. Do all of the data items need to be stored in a table? If not, which ones do not need to be stored, and why not? Identify what data should be included in each table.

Effectiveness more important to organizational performance : A college professor told her students, "The purpose of a management course is to teach students about management, not to teach them to be managers." Do you agree or disagree with this statement? Why or Why not?

Demonstrates the changing nature of scientific theories : Write an essay in which you use an example from the history of science that demonstrates the changing nature of scientific theories.

Soldier morale during world war II : Samuel Stouffer's study of soldier morale during World War II led to what conclusion?

Environmental analysis-political-economic and demographic : When conducting a Case Study Analysis based on the online educational institute Kaplan University, I need in depth the External Analysis. Within this I need the General environmental analysis (political, economic, demographic,environmental, etc)

User Account

All Pages