Database Reference
In-Depth Information
Table 7.1
A New Entity List for Mountain View Music
Entity Name
Description
Bank Accounts
Holds all the required data to draft an electronic check from a customer's bank
account.
Bins
A representation of a physical location in the warehouse where products are
stored.
Credit Cards
All data about a customer's credit card so that it can be charged for orders.
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.
Gift Cards
Stores all the data pertaining to a customer's gift card.
List Items*
(See text.)
Lists*
(See text.)
Order Details
Contains information pertaining to the product, number of the product, and
other product details specific to the order.
Orders
All data pertaining to a customer's 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 Bank Accounts.
Product Attributes*
This entity contains attributes specific to products that are not stored in the
Products entity.
Product Instance*
This is an entity that facilitates a M:M relationship with the Products and Bins
entities.
Product Kits*
Represents collections of products sold as a single product.
Product Vendors*
Facilitates a M:M relationship with the Products and Vendors entities.
Products
This entity contains all the basic information about the various products the
company sells.
Purchase Details
Contains the information about the specific products and quantities that were
purchased from vendors.
Purchases
Information related to purchases that have been made from vendors.
Shipments
Details 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.
*New entity
Search WWH ::




Custom Search