Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Rate cat. Cust. No Name Emp. No Emp. name Hourly rate Project No Project name 80512 ABC Inventory Maintenance Changes John Smith $170 501 12
Rate cat. Cust. No Name Emp. No Emp. name Hourly rate Project No Project name 80512 ABC Inventory Maintenance Changes John Smith $170 501 12 Anne O'Toole $150 80512 ABC Charles Ratton 80512 ABC 16 $100 80111 Heinz $170 POS Enhancements John Smith 503 Monique Bejea 80111 Heinz 17 $150 89000 TD Bank $170 GUI Enhancements John Smith 504 TD Bank 13 Marty Editton $90 89000 1. Analyze the data in the table 2. Normalize the table and create any new tables needed 3. Create an ERD of the tables showing the relations (1:0, 1:M, 0:M, etc.), use 0 or crows feet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started