[Database class] Customer and Ordering

[Paul S. Wang]

Adam,

The four tables are examples to guide your homework/project.  Not to be
used as a reason to do certain things.  That would be letter the DB wag the dog!

Remember we require cutomer login, so we do know which customer it is.
I would assume that if we sold a customer some goods,  and we are recording
an order,  we have no business not knowing which customer.  Or do you not
agree?

Am sending this to the whole class so everyone can think about this.

Paul
P.S. you are taking both WP-II and DB classes and I am not sure your
question relates to which class.  But my comments should apply broadly
so I am cc-ing both classes.  Sorry if this causes any confusion!

> Date: Fri, 24 Feb 2012 23:32:37 -0500
> From: Adam Esterle <aesterl1 at kent.edu>
> To: "Paul S. Wang" <pwang at cs.kent.edu>
> Subject: Customer and Ordering
> 
> How should we decide which customer has purchased the order? I noticed the customer table does not have a username and password for login. Should we just associate the order with a random user?
> 
> -- 
> Adam Esterle

-- 
==============================================================================
 Paul S. Wang (王士弘)                      Email: pwang at cs.kent.edu            
 Dept. of Computer Science, Kent State U.   Tel: (330) 672-9051
 Kent, Ohio, USA 44242-0001                 http://www.cs.kent.edu/~pwang/ 
==============================================================================