Module 7 Assignment - In the auto shop examples

Computer Science 7-2 Homework Activity: Module Seven Assignment

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?

Submit your assignment here. Make sure you’ve included all the required elements by reviewing the guidelines and rubric. 

Using the questions found at the end of Chapter 9 in your textbook, submit a Word document including an ERD with the answers to the following questions:

• What is a DBMS? Briefly describe the components of a DBMS.
• 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.
• 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. Note: For the purpose of this assignment, you may use an ERD not related to this specific case study.