Database Reference
In-Depth Information
Table 6.1
A C o m p l e t e E n t i t y L i s t f o r M o u n t a i n V i e w M u s i c
Entity Name
Description
Bins
A representation of a physical location in the warehouse where products are
stored.
Customers
Stores all information pertaining to a customer. In this case a customer is
anyone who has purchased or will purchase a product from Mountain View
Music.
Employees
Contains all information for any employee who works for Mountain View Music.
Orders
All data pertaining to a customer's order.
Order Details
Contains information pertaining to the product, number of the product, and
other product detail specific to the order.
Payments
Contains all the information about a customer's payment method. This is being
implemented as a subtype cluster containing three additional entities: credit
cards, gift cards, and electronic checks.
Credit Cards
All data about a customer's credit card so that it can be charged for orders.
Gift Cards
Stores all the data pertaining to a customer's gift card.
Electronic Checks
Holds all the required data in order to draft an electronic check from a
customer's bank account.
Products
This entity contains all the information about the various products the company
sells.
Purchases
Information related to purchases that have been made from vendors.
Purchase Details
Contains the information about the specific products and quantities that were
purchased from vendors.
Shipments
Detail about the shipments of products to fulfill customer orders.
Shipping Carriers
A list of each of the shipping carriers that Mountain Views uses: FedEx, UPS,
USPS, etc.
Shipping Methods
The methods for shipping available from the carriers: ground, overnight, two-
day, etc.
Shopping Cart
An entity used to store a customer's shopping cart on the Web site; this allows
them to leave the site and return later.
Vendors
Companies that Mountain View orders products from for sale on the Web site.
Let's look at the process we would follow to fill in the entities for the
Customer entity. From our earlier data, we already know that the customer
entity will contain address data. To seek further clarification, we talk with
Bill, the CEO, and Robyn Miller, the customer service manager. There is
no one method you must follow in these conversations; you usually begin
by simply asking what kind of information needs to be tracked. As the dis-
cussion progresses, your job is to write down what is said—on a whiteboard
or easel if possible—and ask clarifying questions about anything you are
Search WWH ::
Custom Search