Customer Resource Management Database You have been tasked t

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.

Solution

1.      Customer ID number :- VARCHAR as customer ID can be a mix of characters and numbers.

2.      Customer First Name :- CHAR as name will always be character.

3.      Customer Middle Initial :- CHAR as name will always be character.

4.      Customer Last name :- CHAR as name will always be character.

5.      Customer street address :-VARCHAR as street address can be a mix of characters and numbers.

6.      Customer City :- CHAR as name will always be character.

7.      Customer State :- CHAR as name will always be character.

8.      Customer Zip :- INTEGER(p) where p is precision as zip code is always numerical.

9.      Customer Phone number :-INTEGER(p) where p is precision as Phone number is always numerical.

10. Customer Company ID Number :-VARCHAR as customer company ID number can be a mix of characters and numbers.

11. Customer Company Name :- VARCHAR as customer company name can be a mix of characters and numbers. Ex. 3i InfoTech

12. Customer Company’s net worth :- DECIMAL(p,s) This will store an exact numerical with precision p and scale s. For example Decimal(5,2) is a number that has 3 digits previous to the decimal and 2 digits after the decimal. The net worth will always be in terms of money so we will use Decimal as the data type.

13. Customer Company’s Earnings-Per-Share Ratio DECIMAL(p,s) This will store an exact numerical with precision p and scale s.

14. Customer Company Number of Employees :-INTEGER(P) it stores integer numerical with no decimals with precision p and the number of employees will be always a number.

15. Customer Company Incorporation Date :- DATE as this data type stores date.

16. Customer Company Overview—IE :-VARCHAR as customer company overview-IE can be mix of characters and numbers