Russell Crowe Normalisation Exercise (Hardware Store)Cunnings Hardware House is a retail chain selling building tools and supplies
Question:
Russell Crowe Normalisation Exercise (Hardware Store)Cunnings Hardware House is a retail chain selling building tools and supplies for tradespeople and handy people. It operates in many locations in Sydney. The following is extracted from the company’s spreadsheet to show the relationships among different data fields. You are employed to develop a relational database system by normalising the spreadsheet and create an Entity-Relationship Diagram (ERD) to match the resulting tables of the data normalisation process. You are required:
a) Normalise the below spreadsheet to tables in the third normal form (3NF). Specify the primary key and foreign key (if any) for each resulting table.
b) Develop an Entity-Relationship Diagram from the resulting tables in (a).
Management and Cost Accounting
ISBN: 978-1292063461
6th edition
Authors: Alnoor Bhimani, Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan