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?