Please take the database design below

Please take the database design below and post the database normalization diagrams (data dependency diagrams) that would go along with your model.  Keep in mind, that when you are creating an ER model, you are almost always already in 3NF.  This is just a sign that you created your initial model well. 

Therefore, Don’t try and un-normalize your tables to try and show 1NF and 2NF just for the sake of showing each step.  This exercise is designed to take what you developed in week 3 and allow you to create data dependency diagrams by working through the normal form steps and rules.   As you go through this process, you may find additional normal form discrepancies that you may have missed in the design process.  Please define all dependencies in your data dependency diagrams.

=======================================

1)     Business Rules

Business rules gives an important classificationto relationship, attributes and constraints in an entity an example of comphonessolutions business rule is

Technician ------------------------Repairs----------------------Computer

Computer--------------------------creates----------------------Job card         

Salesman -------------------------sells---------------------------Computer

Computer ----------------------received------------------------workshop

2)     ER Model

3)     Sample Data (2-3 rows for each entity)

Computer

Sales

Repairs

Workshop

Note: that in database design business rules would always be defined first and the ER model would be based on these rules.  So, try to write the rules first but it might be an iterative process!

Please take the database design and post the database normalization diagrams (data dependency diagrams) that would go along with your model.  Keep in mind, that when you are creating an ER model, you are almost always already in 3NF.  This is just a sign that you created your initial model well. 

Therefore, Don’t try and un-normalize your tables to try and show 1NF and 2NF just for the sake of showing each step.  This exercise is designed to take what you developed in week 3 and allow you to create data dependency diagrams by working through the normal form steps and rules.   As you go through this process, you may find additional normal form discrepancies that you may have missed in the design process.  Please define all dependencies in your data dependency diagrams.