Lect_02_Cape-Codd_Sports - CAPE CODD OUT DOOR SPORTS...

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

View Full Document Right Arrow Icon
CAPE CODD OUTDOOR SPORTS COMPANY Company Overview Cape Codd Outdoor Sports is a fictitious company based on an actual outdoor retail equipment vendor. Cape Codd Outdoor Sports: Has 15 retail stores in the US and Canada. Has a on-line Internet store. Has a (postal) mail order department. All retail sales recorded in an Oracle database. DATA FLOW IN THE COMPANY
Background image of page 1

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

View Full DocumentRight Arrow Icon
ESSENTIAL QUESTIONS OR REQUIREMENT The Cape Codd marketing department needs an analysis of in-store sales. The entire database is not needed for this, only an extraction of retail sales data. The data is extracted by the IS department from the operational database into a separate, off-line database for use by the marketing department. METADATA
Background image of page 2
END-USER DATA 1. ORDER_ITEM OrderNumber SKU Quanti ty Price ExtendedPr ice 3000 100200 1 $300.00 $300.00 2000 101100 4 $50.00 $200.00 3000 101100 2 $50.00 $100.00
Background image of page 3

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

View Full DocumentRight Arrow Icon
2000 101200 2 $50.00 $100.00 3000 101200 1 $50.00 $50.00 1000 201000 1 $300.00 $300.00 1000
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/03/2011 for the course ECON 7.104 taught by Professor Wei during the Spring '11 term at Faculty of English Commerce Ain Shams University.

Page1 / 6

Lect_02_Cape-Codd_Sports - CAPE CODD OUT DOOR SPORTS...

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

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