View Single Post
  #4 (permalink)  
Old November 24th, 2011, 08:13 PM
frdata frdata is offline
Authorized User
Points: 80, Level: 1
Points: 80, Level: 1 Points: 80, Level: 1 Points: 80, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 20
Thanks: 7
Thanked 0 Times in 0 Posts
Default

Hello again Rod,

1. How is the [Persons] table helpful in this design? Can we not just place the fields in their respective [Employees], [Vendors] and [Customers] tables?

2. Lets say we want to create a new Customer. Do we start with the [Customers] table first or the [Persons] table, or start simultaneously? Are CustomerID and PersonID auto numbers? Why don't we just use CustomerID and link it to the [Persons] table.

I know, I'm quite mixed up. Could please help me in this. Thanks.