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.
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
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 ...
Strategic planning for database classes are examined.