Database Design Assignment

Part 1

Customer Resource Management Database

You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in your database:

Customer ID number

Customer First Name

Customer Middle Initial

Customer Last name

Customer street address

Customer City

Customer State

Customer Zip

Customer Phone number

Customer Company ID Number

Customer Company Name

Customer Company's net worth

Customer Company's Earnings-Per-Share Ratio (scaled to tenths of a percent)

Customer Company Number of Employees

Customer Company Incorporation Date

Customer Company Overview-IE What is their primary product or service?

For each item required for your database (listed above) select the appropriate data type and provide a rationale as to why you chose a particular data type for that entry. Submit you answer in a MS Word document.

Part 2

Answer the questions (75-150 words)

Why do we need databases? Why cant we just store data in spreadsheets?