Question:you are designing several databases for a clien

Assignment Help Business Management
Reference no: EM13671451

The question:You are designing several databases for a client. While designing the databases, you come across the following listed data items. Which data type would you use to store each of these pieces of information and why?

These are my answers, but I'm not sure I understood. It is for SQL database.
Radius of a planet- Data type int. Juiper is the largest planet with a radius of 43,441 mi which makes it too larger for the smallint datatype.
Value of pi (π)- Data type varchar because the value of pi has a variable length
Salary- smallmoney, because salary would be a money type between 214,748.3648 to 214,748.3647
.Person's date of birth- Data type date*, because a person's date of birth would be between 0001-01-01 through 9999-12-31 and no time is required
Length of a board- Data type tinyint, because the length of a board should be between 0 to 255.
Numbers of music players sold- Data type tinyint, because numbers of music players sold should be between 0 to 255.

Reference no: EM13671451

Questions Cloud

University number of students : University Number of Students
How will this sabotage affect the results : How will this sabotage affect the results - However, Sandy and you were industrial spies, employed by the EF Pencil Co. and sent to ECON6351 to cause as much trouble as possible.
The unique thing that hapen the to early israelites : The unique thing that hapen the to early Israelites
Introduction to operating systems : Introduction to Operating Systems
Question:you are designing several databases for a clien : The question:You are designing several databases for a client.
Compute the internal rate of return for the cash flow : Compute the internal rate of return for the cash flow
The importance of employee socialization to an organization : Describe an effective employee onboarding program and the importance of employee socialization to an organization
What competitive advantage can the companies : 1.What competitive advantage can the companies described in the case derive from the useof faster technology and co-location of servers with the exchanges? Which would you sayare sustainable and which ones temporary or easily imitable? Justify ..
What is the probability of an unfavorable seismic survey : What is the probability of an unfavorable seismic survey?

Reviews

Write a Review

Business Management Questions & Answers

  Creating a powerpoint on roles of participants in hiring

Creating a PowerPoint on the roles of participants in the hiring process - Formulate a plan, including a flowchart, on the participants' roles for the hiring process. Include the following:

  Define google strategy

Discuss and define Google strategy.

  Command style management practices

What is the difference between command style management practices of the past and "participatory style" management practices of the present?

  Description of culture

A knowledge of culture has been responsible for Disney's success in Tokyo, and ignorance of culture is responsible for the company's large losses in Paris.

  Describe ceo of macys terry lundgren address

Describe the CEO of Macy's, Terry Lundgren and address - Empowerment - managers lead employees by sharing power, responsibility, and decision making with them

  Addresses continuous improvement opportunities

What are some continuous improvement opportunities you may recommend in your existing organization to avoid complacency?

  1 on the basis of home depots response to environmentalist

1. on the basis of home depots response to environmentalist issues describe the attributes power legitimacy urgency of

  What laws have been disrupt

What laws have been disrupt here if any, What are Gant's damages? Are there any additional facts that we require to find out in order to resolve this dispute.

  Determine the application or technology and related

read the following 2002 article merging it at daimlerchrysler this company no longer exists but for the purposes of

  Collective agreementswhat should unions and employers do in

collective agreementswhat should unions and employers do in order to successfully administer a collective agreement?

  Budgeting amp forecasting three environmental conditions

budgeting amp forecasting three environmental conditions impacting a forecastfind a minimum of three current

  Question about the prison study

Show the findings of this study. What is the application of Zimbardo's findings to similar, real-life events happening today

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd