HW 1 Database Survey homework

Revised on July 26, 2004

 

Find a business, which is owned by your friends or family.  Write a no less than five-page size 12, double space business summary (a realistic example is preferred) including the following sections:

1. Company introduction (general introduction)
2. Business model (How does this business work, profit)
3. Information requirement (Do they need Database to keep track of customers, venders and others)
4. E-R diagram (Draw an ER diagram based on you analysis)
5. Preliminary table design (provide a preliminary design)
   1. Table name
   2. Fields (length, data type, description)
   3. Primary key
   4. Foreign keys