The Eastside Sales Company produces a monthly report containing a list of sales staff and their customers.
Question:
The Eastside Sales Company produces a monthly report containing a list of sales staff and their customers. The first three characters of the postal code are stored to identify which city the customer is located. Each sales person is assigned three customers, but more in the future as the company grows. An example of a monthly sales staff customer listing report is in the student files as P05-03.docx. Complete the following:
1. Create an un-normalized tabular format (flat spreadsheet-like table) from the report format
2. Convert table to 1NF and create relational schema (tabular and text format):
a. Each attribute (cell) contains a single value
b. Identify the primary key
3. Convert to 2NF:
a. Identify the partial key dependencies
b. Convert tables to 2NF and create relational schema (tabular and text format)
4. Convert to 3NF:
a. Eliminate transitive dependencies where non-key attributes are dependent on non- key attributes.
b. Convert tables to 3NF and create relational schema (tabular and text format)
5. Create an ER diagram from the final normalized database
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton