Share
Explore BrainMass

strategic planning for database class

What would be anxample scenario for a database (i.e. customer, orders, suppliers). What entities would be involved? What would the primary keys of each of the entities be and why?

Please explain this and provide examples.

Solution Preview

What would be an example scenario for a database (i.e. customer, orders, suppliers). What entities would be involved? What would the primary keys of each of the entities be and why?

Here is a basic structure of table's one need to keep track of an ordering system.
: Customer, Products, Suppliers, Orders and OrderDetail
Table: Customers
Title
customerId (PK)
firstName
lastName
middleName
address
city
state
zip
EmailAddress
HomePhone
CellPhone
WorkPhone
IsActive
EmailCommunication
CustomerSince
Status
In the above table the primary key is CustomerID is of a running number, unique. By setting customerID as primary key has advantage as customer might want to change name and address and other information during course of time.
But this customerID is unique identifier and don't need to be changed at all. One might argue setting up phonenumer, email address or SSN as primary keys but these subjected change and with customerId as primary key one update customer
Email address/phone other information can be changed at anytime without updating in any other tables.
EmailAddress can be used to ...

Solution Summary

Strategic planning for database classes are examined.

$2.19