Purchase Solution

strategic planning for database class

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

Strategic planning for database classes are examined.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C# variables and classes

This quiz contains questions about C# classes and variables.