1. Provide a comparative description of the three major data types. Specifically, give your own narrative on what the data types are; how they differ from each other; what the data looks like; and where each data type is most commonly used. 

2. Discuss, own words, the database design tools that help analysts understand the structure of a database. Include a description of the database elements they include and why these tools are important.

3. Remember the Database Roles? Pick your top four favorites and tell me why the people in each of those roles are important in your job as a data analyst. Keep your answer for each role to no more than a paragraph. Roles: Application Programmer, Database Designer, Data Integration Engineer, Database Administrator

4. A Database Management System (DBMS) can mean many things. Please type nice one-paragraph description (own words) of what a DBMS is, what it does, and why it's important. 

5. As relates to the Relational Model, own words, describe the three types of relationships. Give a full paragraph for each type that discusses the relationship, including three practical examples of where and how the relationship type would be used.  

6. A null value in a column is a major cause for poor query results. Describe, own words, what a null value is and isn't; why it can cause problems, and how you should write queries that deal with the problem? 

7. Your boss asked the following question of your coworker:

Provide a list of businesses in Portland, Oregon, with orders for more than 5,000 units last year (assume they are talking about 2019).

Your coworker turned in the following query, which does not provide the right results. Your job is to debug the query. Describe two problems that you see. 

SELECT CompanyName, PurchasedUnits, OrderDate FROM Sales

WHERE (CompanyCity = 'Portland') OR (PurchasedUnits > 5000) AND

(OrderDate >= '2019-01-01' AND OrderDate < '2019-12-31');

8. This query is meant to answer the question: 

Provide a list of all orders that have "skate board" in their description. 

However, it seems to miss a number of orders. Your job is to debug the query and make it work correctly. There are two problems with the query:

SELECT CustomerName, OrderDate, PurchaseOrder, ProductName FROM Sales

WHERE ProductDescription LIKE 'Skate Board%';

Answer rating: 100% (QA)

1 Comparative Description of Data Types Numeric Data Type Numeric data types represent numerical values including integers whole numbers and floatingpoint numbers numbers with decimal points These dat... View the full answer