Recent Question/Assignment
Task
Observe the following table then proceed to complete the points listed below the table:
CUST_ CODE CUST_ LNAME CUST_ AREACODE CUST_ PHONE INV_ DATE INV_ AMOUNT PROD_ CODE PROD_DESCRIPT
10010 Ramas 615 844-2573 16-Mar-09 $5,000.00 11QER/31 Power painter, 15 psi., 3-nozzle
10011 Dunne 713 894-1238 16-Mar-09 $4,260.00 13-Q2/P2 7.25-in. pwr. saw blade
10012 Smith 615 894-2285 16-Mar-09 $3,800.00 14-Q1/L3 9.00-in. pwr. saw blade
10013 Olowski 615 894-2180 17-Mar-09 $2,300.00 1546-QQ2 Hrd. cloth, 1/4-in., 2x50
10014 Orlando 615 222-1672 17-Mar-09 $1,587.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
10015 O'Brian 713 442-3381 17-Mar-09 $4,500.00 2232/QTY B&D jigsaw, 12-in. blade
10016 Brown 615 297-1228 17-Mar-09 $3,600.00 2232/QWE B&D jigsaw, 8-in. blade
10017 Williams 615 290-2556 17-Mar-09 $6,720.00 2238/QPD B&D cordless drill, 1/2-in.
10018 Farriss 713 382-7185
10019 Smith 615 297-3809 20-Mar-09 $2,300.00 1546-QQ2 Hrd. cloth, 1/4-in., 2x50
10014 Orlando 615 222-1672 18-Mar-09 $2300.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
10011 Dunne 713 894-1238 16-Mar-09 $3,600.00 2232/QWE B&D jigsaw, 8-in. blade
10010 Ramas 615 844-2573 16-Mar-09 $1,587.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
Using the above Table complete the following listed below:
1. What is wrong with the table above and what anomalies arise when implementing this table?
2. What is the primary key (currently) of the table?
3. Create a dependency diagram and go through the normalisation process to convert to 3NF to eliminate these anomalies.
Include all necessary primary keys/foreign keys for the 3NF stage.
NOTE
Manually drawing the dependency diagram or the relational schema is NOT acceptable.
Submission Method: Turnitin
Rationale
1. This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy.
2. Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.
Observe the following table then proceed to complete the points listed below the table:
CUST_ CODE CUST_ LNAME CUST_ AREACODE CUST_ PHONE INV_ DATE INV_ AMOUNT PROD_ CODE PROD_DESCRIPT
10010 Ramas 615 844-2573 16-Mar-09 $5,000.00 11QER/31 Power painter, 15 psi., 3-nozzle
10011 Dunne 713 894-1238 16-Mar-09 $4,260.00 13-Q2/P2 7.25-in. pwr. saw blade
10012 Smith 615 894-2285 16-Mar-09 $3,800.00 14-Q1/L3 9.00-in. pwr. saw blade
10013 Olowski 615 894-2180 17-Mar-09 $2,300.00 1546-QQ2 Hrd. cloth, 1/4-in., 2x50
10014 Orlando 615 222-1672 17-Mar-09 $1,587.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
10015 O'Brian 713 442-3381 17-Mar-09 $4,500.00 2232/QTY B&D jigsaw, 12-in. blade
10016 Brown 615 297-1228 17-Mar-09 $3,600.00 2232/QWE B&D jigsaw, 8-in. blade
10017 Williams 615 290-2556 17-Mar-09 $6,720.00 2238/QPD B&D cordless drill, 1/2-in.
10018 Farriss 713 382-7185
10019 Smith 615 297-3809 20-Mar-09 $2,300.00 1546-QQ2 Hrd. cloth, 1/4-in., 2x50
10014 Orlando 615 222-1672 18-Mar-09 $2300.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
10011 Dunne 713 894-1238 16-Mar-09 $3,600.00 2232/QWE B&D jigsaw, 8-in. blade
10010 Ramas 615 844-2573 16-Mar-09 $1,587.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
Using the above Table complete the following listed below:
1. What is wrong with the table above and what anomalies arise when implementing this table?
2. What is the primary key (currently) of the table?
3. Create a dependency diagram and go through the normalisation process to convert to 3NF to eliminate these anomalies.
Include all necessary primary keys/foreign keys for the 3NF stage.
NOTE
Manually drawing the dependency diagram or the relational schema is NOT acceptable.
Submission Method: Turnitin
Rationale
1. This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy.
2. Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.
Looking for answers ?
Recent Questions
Module code: BMA4005-20Module title: Professional PracticeAssignment: A1. Digital PosterWord count: 500Contribution to module mark: 40% of overall gradeAssessment type: IndividualWeight 40%Submission deadline:...Assessment Criteria for Written Report (20%)• Submission of a minimum 1500 to maximum 1800-words written report due from week 9. You will submit your written report one week after you have undertaken the...Assessment 2: (20%) Case Study Presentation Due Date weeks 10This assessment builds on your theoretical knowledge and tests your ability to apply this knowledge to practice.you are required to formulate...Assessment 2Assessment 2Report: 30%Word count: 1400 – 1600 wordsDue date: Sunday of Week 8DescriptionYou are playing the role of a community service worker supporting a young adult son who is 18 years...1500-1800 wordsInstructions From TutorPlease download the eTask3 spreadsheet from Canvas and save the eTask spread as an Excel file. The main content of the force method is taught in Lectures 6,7&8.eTask3.1 is a...ASSIGNMENT INSTRUCTIONSAssessment Practical assessmentAssessment code: 011Academic Year: 2023/2024Trimester: 2Module Title: Critical Perspectives on Cross-Border BusinessModule Code: MOD009194Level: 6Module...Show All Questions