Assignment

Short Answer questions Part 1:

1. What is the difference between a database and a DBMS?

Would you consider a DBMS an intermediator between you and the database? Explain your answer.

2. Conduct a search and identify the popular DBMS used in business?

3. Conduct a search and identify an article that describes how databases are used to improve a business. Write a brief summary of the article and provide a link.

4. What is you major? How are databases used to improve the productivity of your particular major? Cite your sources used to answer this question.

5. What type of statements are used to CREATE Tables? DDL or DML?

6. What type of statements are used to INSERT Rows into a Table? DDL or DML?

7. What type of statements are used to UPDATE Rows in a Table? DDL or DML?

8. What type of statements are used to remove a table? DDL or DML?

9. What are some possible tables that you would include if you were building a University database?

10. Pick a table from question 9 and identify potential Columns that would be included in each table.

11. Are all Primary Keys also Candidate Keys? Explain.

12. What makes for a good Primary Key?

13. What are the main disadvantages of using composite Primary Kays?

14. Why do surrogate keys make great primary keys?

15. What is the purpose of a foreign key? Why are they needed in a relational database?

Short Answer Questions Part 1:

1. How does the Rule of One Theme relate to Normalization? Would you consider this part of, or all of the normalization process? Explain.

2. In your own words, describe a DELETE unintended consequence problem. Provide an example.

3. In your own words, describe an UPDATE unintended consequence problem. Provide an example.

4.In your own words, describe an INSERT unintended consequence problem.

5. Describe an example of a Rule of One Instance problem. How would you fix this problem?

6. Consider A→ B. In this example, what is A (determinate or functionally dependent)? What is B (determinate or functionally dependent)?

7. Consider ABDPC. If A → B, D, P, C and P → C, is this normalized to 3rd NF? If not, explain. In addition, how would you fix it?

8. Consider ABDPC. If AB→DPC and B→P, is this normalized to 3rd NF? If not, explain. In addition, how would you fix it?

9. Consider ABDPC. If AB→DPC, is this normalized to 3rd NF? If not, explain. In addition, how would you fix it?

10. In your own words, what does the term, "every determinate must be a candidate key" mean?