Reference no: EM133496622

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document, including an ERD, and answering questions 2, 3, and 4.

Questions.

1.In the auto shop examples in Section 9.2.2, what are some problems that might arise in Mario's system? Why won't Danica run into the same problems? Provide specific examples in your answer.

2.What is a DBMS? Briefly describe the components of a DBMS.

3.Describe a primary key, candidate key, secondary key, foreign key, and a combination key. Use your imagination to provide an example of each key that is not in the textbook.

4.What are entity-relationship diagrams and how are they used? What symbol is used for a relationship? What is an associative entity? Provide an example.

5.What is cardinality, and what symbols do you use in the crow's foot notation method?

6.What are data warehousing and data mining? How do businesses use these tools?

7.What is an unnormalized design, and how do you convert an unnormalized design to 1NF? In your answer, refer to specific pages and figures in this chapter.

8.How would you define second normal form? How do you convert a 1NF design to 2NF? In your answer, refer to specific pages and figures in this chapter.

9.How would you define third normal form? How do you convert a 2NF design to 3NF? In your answer, refer to specific pages and figures in this chapter.

10.How would a specific date, such as April 27, 2015, be represented as an absolute date?