Database Normalization Homework

Hi,

I need help with this example scenario, if possible could some one help me, here it is

Your task is to develop a database design to build a Hardware Component Shop for computer engineers. The shop will enable the shopkeeper to enter and manage hardware components into an online catalogue. It will support the sale and tracking of the sales process and in addition will support the buyer in the finding, selection and buying of components. The complete system will have the following minimum set of elements:

• A catalogue for the storage of components

• A Component description and cataloguing tool for entering, updating and removing components from the system

• A sales tracking and auditing system to enable the seller to keep track of components sold and the customer to keep track of items bought.

Identify actions on data which threaten database integrity and explain the protection which a relational database management system affords.

I have done the tables which are

Customer, Invoice, Order, Transaction, Hardware Component & Catalogue. I need help with the ERD'S & Normalization


Thanks very much for your help

I'd suggest reading the chapter on normalization for the course you are doing

Show us what you've accomplished so far and/or ask specific questions.

We don't volunteer our time in these forums to do your homework.

I always volunteer my time.....but it'll cost £40 per hour