|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Can anyone help me make the entieis for my business and help me normalize the data by using the steps of normalisation- meaning first normal form, second normal form and third normal form.
Well my business would like to make a database for saving customers details, product details, and be able to send orders to customers including shipping information. So please help. OR You could look at the diagram given and show my how the information was normalized and how the entites were found by doing it in steps- first normal form, second normal form and third normal form. Please help |
|
#2
|
|||
|
|||
|
normalisation is a process of reducing the repetition of data. so, you need to make sure that if you have bits of information that are fixed you don't want to continually repeat them as they will take up unnecessary space.
Is the picture your database or a demo? having a customer table means you can have one record holding all the information of that person. then if they put in multiple orders you only ever have the refer to that one customer record. this means that you don't repeat the information and if that contact information changes, you only have to change one record rather than all the ones that have that customer in. it is hard to give to advice without knowing your specifics. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Making entities and Normalizing- HELP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|