Assignment Grading Rubric
cybacatx
it234_unit4_assignment_rubric_1.pdf
Assignment Grading Rubric
Course: IT234 Unit: 4 Points: 60
Copyright Kaplan University
Assignment 4 Outcomes addressed in this activity:
Describe how the referential integrity restrict, cascade, and set-to-null delete rules operate in a relational database
Describe how one-to-one, one-to-many, and many-to-many binary relationships are implemented in a relational database
Identify three common challenges in managing data, and describe one way organizations can address each challenge using data governance
Course Outcomes: IT234-3: Appraise how data and information is managed by Relational Database Management Systems in order to meet the business objectives of an organization. Assignment Directions: For this Assignment, you will answer a series of questions designed to test your understanding of common relational database concepts. In a word document, copy each question and then directly underneath it provide your answer. Format the word document for maximum readability and clarity. Use a consistent font throughout. Arial 11, is preferred. Provide complete and accurate answers to the following five (multipart) questions.
Assignment Grading Rubric
Course: IT234 Unit: 4 Points: 60
Copyright Kaplan University
Figure 4.1 Source: Gillenson, M. (2011). Fundamentals of database management systems, second edition. Hoboken, NJ: John Wiley & Sons.
1. In the General Hardware Corp. relational database as shown in Figure 4.1 (pp. 71–72) above:
a. How many foreign keys are there in each of the six relations? b. List the foreign keys in each of the six relations. c. Identify the relations that support many-to-many relationships, the primary keys of those
relations, and any intersection data.
2. Consider the General Hardware Corp. relational database as shown in Figure 4.1 above: (Written in the informal relational command language described on page 125 in Fundamentals of Database Management Systems).
Assignment Grading Rubric
Course: IT234 Unit: 4 Points: 60
Copyright Kaplan University
a. List the product name and unit price of all of the products. b. List the employee names and titles of all the employees of customer 2198. c. Retrieve the record for office number 1284. d. Retrieve the records for customers headquartered in Los Angeles. e. Find the size of office number 1209. f. Find the name of the salesperson assigned to office number 1209. g. List the product name and quantity sold of each product sold by salesperson 361.
3. Consider the General Hardware Corp. relational database and the data stored in it, as shown in
Figure 4.1 above. Find the answer to each of the following queries
a. Select rows from the CUSTOMER EMPLOYEE relation in which Customer Number = 2198. b. Select rows from the CUSTOMER EMPLOYEE relation in which Customer Number = 2198.
Project Employee Number and Employee Name over that result. c. Select rows from the PRODUCT relation in which Product Number = 21765. d. Select rows from the PRODUCT relation in which Product Number = 21765. Project Unit Price
over that result. e. Join the SALESPERSON and CUSTOMER relations using the Salesperson Number attribute of
each as the join fields. Select rows from that result in which Salesperson Name = Baker. Project Customer Name over that result.
f. Join the PRODUCT relation and the SALES relation using the Product Number attribute of each as the join fields. Select rows in which Product Name = Pliers. Project Salesperson Number and Quantity over that result.
Consider the General Hardware Corp. database as shown in Figure 4.1 above. Describe the problem of referential integrity in terms of the CUSTOMER and CUSTOMER EMPLOYEE relations if the record for customer 2198 in the CUSTOMER relation is deleted. (Assume that no delete rules exist.)
4. In the General Hardware Corp. database as shown in Figure 4.1 above.
What would happen if:
a. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is "restrict" and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
b. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
c. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-to-null and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
d. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is "restrict" and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?
e. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?
f. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-to-null and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?
Assignment Grading Rubric
Course: IT234 Unit: 4 Points: 60
Copyright Kaplan University
5. Identify and explain the major difficulties involved in managing data.
6. Define data governance and explain why it is necessary.
7. Compare and contrast master data and transactional data, and provide an example of each one.
Directions for Submitting Your Assignment: Compose your Assignment in a Microsoft Word document and save it as IT 234 YourName_Unit_4.doc and submit it to the Dropbox for Unit 4. Written Assignment Requirements: Written work should be free of spelling, grammar, and APA errors. Points deducted from the grade for each writing, spelling, or grammar error are at your instructor’s discretion. Please be sure to download the file “Writing Center Resources” from Doc Sharing to assist you with meeting APA expectations. Review the grading rubric below before beginning this activity. Assignment 4 grading rubric = 60 points
Assignment Requirements Points Possible
Points Earned
1. The number of foreign keys is correctly Identified.
0–6
2. Each of the foreign keys in each of the six relations is listed.
0–4
3. The relations that support many-to-many relationships, the primary keys of those relations, and any intersection data are correctly identified.
0–6
4. Correct answer to each of sub question in Question 2 is provided.
0–7
5. Correct answer to each of sub question in Question 3 are provided.
0–6
6. A complete description of the problem of referential integrity in terms of the CUSTOMER and CUSTOMER EMPLOYEE relations is provided.
0–6
7. A complete description of the outcomes 0–5
Assignment Grading Rubric
Course: IT234 Unit: 4 Points: 60
Copyright Kaplan University
described in each of sub questions in Question 5 is provided.
8. 4 difficulties involved in managing data are identified and a complete explanation of each is supplied.
0–8
9. A complete explanation of data governance is supplied.
0–6
10. Master and transactional data, are contrasted and examples of each are provided.
0–6
Total (Sum of all points)
0–60
Less deduction taken for spelling, grammar and APA errors. Plagiarism is totally unacceptable.
Adjusted Total Points
