Day 4 Database Models - items can be returned at a later...

Info iconThis preview shows pages 1–22. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Models (part 2)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Customer / Credit Info Product Info: ID, Name, Price Shopping Cart: Shopping Trip: Cashier, Date, Time
Background image of page 2
Retail Sales Database Major data categories Products Customers Credit cards Shopping trips Major relationships Customers can shop one or more times Customers can have zero or more credit cards Shopping trips can be for one or more products
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Retail Sales Database Shopping trips cannot involve multiple customers or credit cards Some shopping trips may not involve a known customer (i.e., cash sales) Not all products have to be sold (e.g., new items, overpriced items) Wholesale suppliers and employees are outside of the scope of today's model. .. but could easily be added to it at a later date
Background image of page 4
Retail Sales Database 1:N 1:N M:N Customers Credit Cards Shopping Trips Products 1:N
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Retail Sales Database 1:N 1:N 1:N 1:N Customers Credit Cards Purchase Master Purchase Detail Products 1:N
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Implicit M:N Relationship Explicit M:N Bridge
Background image of page 8
Extension How would you expand the model to allow customers to return previously purchased items?
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Some or all of these
Background image of page 10
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 14
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 16
Background image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 18
Background image of page 19

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 20
Background image of page 21

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 22
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: items can be returned at a later date Extension How would you expand the model to keep track of the cashiers (employees), paychecks, etc? Pointers to the employees Related Application How would the basic database model differ for an online or mail order store? Key Differences No "unknown" cash customers Alternative mailing addresses Shipping options Unknown Customer Shipping Address Shipping Method Related Application How would the basic database model differ for a chain of retail stores? Key Differences Store locations Inventory at each store (QOHs, Prices) Shopping trips for specific stores Related Application How would the basic database model differ for a new (or used) car dealership? Key Differences Every car is unique (Eliminate QOH; Always 1) No shopping "cart" purchases (Always 1) Negotiated selling price No credit card sales Financing options Every car is unique Customers do not buy cars in bulk Financing options replace credit cards...
View Full Document

Page1 / 22

Day 4 Database Models - items can be returned at a later...

This preview shows document pages 1 - 22. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online