Introduction to Database - MS SQL Server - Due within 24 hours. Scenario 2-2: Ch

Question

Introduction to Database - MS SQL Server - Due within 24 hours.

Scenario 2-2: Choosing Data Types 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?

• Radius of a planet

• Value of pi ()

• Salary

• Person’s date of birth

• Length of a board

• Numbers of music players sold

Scenario 2-4: Extracting Data from a Database You are a database administrator for the AdventureWorks Corporation, and a service manager needs your help extracting data from the company’s database. Therefore, after opening SSMS and accessing the AdventureWorks database, specify the basic SELECT statements you would use to retrieve the required information from the Products Sub category table.

1. What commands would return all the rows and columns in the Product Category table?

2. What commands would you type and execute to return only the ProductSubcategoryID,ProductCategoryID, Name, and ModifiedDate columns?

3. What commands would you type and execute to return rows where the word bike appears somewhere in the Name column?

4. In the existing query window, what commands would you use to add a column alias to the Name column to clarify it as the subcategory name?

5. In the existing query window, what command would you use to sort the previous result set?

--------------------x-------------------x-----------------------x---------------------

You work for a company that handles patient billing for a local hospital. The owner of your company read a news article recently about a data breach at a major company that handles sensitive data. Thousands of credit card numbers were compromised by the breach. This has seriously damaged the company’s reputation. The owner is concerned that the same thing can happen to the company. The owner called a meeting of senior IT staff to discuss data security. At the meeting your boss was tasked with creating a report on data security. Your boss has asked you, the senior database administrator, to help work on the report. Specifically your boss wants you to find out:

1- Post a link to information about two regulations or laws that your company has to comply with.

2- Why do you think those laws or regulations apply?

Summarize your findings in a post. Remember to properly cite any sources used in your post.

Explanation / Answer

Scenario 2-2:

Radius of a planet (radius): The datatype of the variable that holds the value of radius of a planet is DOUBLE.

The radius of a planet can be measured in kms or meters. When it is measured in meters, it requires a large number to hold it.

Value of pi (): The datatype of the variable that holds the value of pi is FLOAT.

Example: The pi value will be 3.14

Salary: The datatype of the variable that holds the value of salary is FLOAT.

Person’s date of birth: The datatype of the variable that holds the value of date of a birth of a person is DATE. Format of date in MYSQL is YYY-MM-DD.

Length of a board: The datatype of the variable that holds the value of length of the board is FLOAT

Numbers of music players sold: The datatype of the variable that holds the value of numbers of music players sold is INT.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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