Data Base week4_3

17/02/2010


 
Rule : must

Conventional : easy to understand (user-friendly)

entity : singular

 
Scenario : Auckland Computer Company Ltd


 
Packing slip and invoice aren't become entity.

Invoice data are view, because same data don't create 2 tables.

However,

Reseller Order Invoice

1 : 0 or more : 1 or more

 

Next week

1. Discuss scenario 30 min
   
2. 
   
   SQL implement
   
   run query
   
   

Homework

search real DB design

MS accounting Database

 

Understand

1. VISIO
   
2. 
   
   Normalization
   
   Functional
   
   Transitive