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

  Describe a job which is usually done by an individual

describe a job which is usually done by an individual, which you believe would be made better by having people work in teams, elucidate why.

  Define the key issues associated with employee rights

Define the key issues associated with employee rights and responsibilities in healthcare organizations and What are the unique aspects of employee relations in healthcare

  What is the goal of employee development

What is the relationship between employee training and employee development and are both necessary within an organization

  Understanding the nonverbal behavior

Explain a nonverbal behavior and suggest at least 3-different meanings that could be assigned to that behavior.

  What pricing technique will you use

Prepare a BUSINESS Plan - Required clear in BUSINESS plan and most of the information present in the presentation of a draft of Hormuz

  Strategic management advantages and risksunderstand what

strategic management advantages and risksunderstand what strategic management is what some of the advantages and risks

  Impact of implementing a specific staffing policy

How do you assess the impact of implementing a specific staffing policy?

  Leadership styles explained in solution

Was he authoritarian and he Was transformational or transactional, or both

  Summary of an annual performance from the business strategy

Summary of an annual performance from the Business Strategy Game(BSG) the name of the company that I was in is Elite Shoes. The Summary has to be on Elite Shoes. I have attached a copy of the instructions per the Instructor.

  Write a paper on how to become a better leader

Write a paper on how to become a better leader using leadership concepts including but not limited to leadership style

  School violence policies and disproportionate punishment

Show the Decatur School Board's decision to adopt a "no tolerance on school violence" in terms of fairness.

  Discuss different problems in an organization

Discuss and explain at least three different problems in an organization can have that would require interventions and with the rationale for each and use at least two sources to support your assessment.

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