Customer Resource Management Database You have been tasked to develop a set of t

Question

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.

Explanation / Answer

Customer ID number :- VARCHAR as customer ID can be a mix of characters and numbers. Customer First Name :- CHAR as name will always be character. Customer Middle Initial :- CHAR as name will always be character. Customer Last name :- CHAR as name will always be character. Customer street address :-VARCHAR as street address can be a mix of characters and numbers. Customer City :- CHAR as name will always be character. Customer State :- CHAR as name will always be character. Customer Zip :- INTEGER(p) where p is precision as zip code is always numerical. Customer Phone number :-INTEGER(p) where p is precision as Phone number is always numerical. Customer Company ID Number :-VARCHAR as customer company ID number can be a mix of characters and numbers. Customer Company Name :- VARCHAR as customer company name can be a mix of characters and numbers. Ex. 3i Infotech 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 before 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 datatype. Customer Company’s Earnings-Per-Share Ratio (scaled to tenths of a percent) :- DECIMAL(p,s) This will store an exact numerical with precision p and scale s. 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. Customer Company Incorporation Date :- DATE as this datatype stores date. Customer Company Overview—IE :-VARCHAR as customer company overview-IE can be mix of characters and numbers.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.