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
Program: Master of Information SystemsAssessment 1: Portfolio 1 (Session 2 Topic: Input, Processing andOutput) Semester 2: Block 8-2024Course Code: MBIS4003 Course Title: Software Development Total Marks:...AssessmentAssessment item 2—Assignment 2Due date 11:45pm on Sunday, 24Nov.2024Weighting 35%Length Not applicableObjectivesThis assessment item relates to the unit learning outcomes numbers 1, 2 and 3 as...Plan, construct and write a long-form essay on a particular area of media research that interests you. Using an established theoretical framework, explain how your research offers new insights into the...DescriptionIn this assessment, you are required to demonstrate that you understand how an Older Adult can develop mental health problems associated with cognitive decline leading to cognitive impairment...School of Engineering, Design and Built EnvironmentENGR7008 Fire Engineering Design and AssessmentAssignment 4: Peer Review of Fire Engineering ReportASSIGNMENT 4PEER REVIEW OF A FIRE ENGINEERING REPORTSee...Structural Analysis Etask 5The aim of this assessment task is to evaluate the appropriate use of the Force Method and Moment Distribution Method for structural analysis• Please download the eTask4 from...Purpose:The purpose of this task is for the student to demonstrate how to create a holistic plan of care that is person-centred, trauma-informed, and recovery-oriented in focus.Description:In this written...Show All Questions