Chpt_Supp_1_outline_-_Data_models

Chpt_Supp_1_outline_-_Data_models - Chapter 15:...

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

View Full Document Right Arrow Icon
Chapter 15: Introduction to REA Data models – depict user requirements for data which is stored in a database Data is stored in tables that look like spreadsheets We can use queries to retrieve data from multiple tables at once to answer a question o For example, how many A-4 agleclaps were sold to John? o We must know all of the tables in our database INVLINE Invoice # Agleclap # Quantity Sold Actual Price INV-1 A-1 3 $2,000.00 INV-1 A-4 2 $600.00 INV-10 A-4 10 $3,000.00 INV-10 A-5 1 $2,000.00 INV-11 A-2 4 $6,000.00 INV-12 A-3 12 $2,000.00 INV-2 A-6 2 $5,000.00 INV-3 A-1 1 $2,000.00 INV-3 A-3 6 $1,000.00 INV-3 A-5 2 $4,000.00 INV-4 A-6 2 $5,000.00 INV-5 A-2 2 $3,000.00 INV-5 A-4 2 $300.00 INV-5 A-6 2 $5,000.00 INV-6 A-2 10 $3,500.00 INV-7 A-5 3 $3,000.00 INV-7 A-6 2 $7,000.00 INV-8 A-1 3 $2,000.00 INV-9 A-2 2 $3,000.00 INV-9 A-6 1 $3,500.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
SALE Invoice # Sale Date Sale Amount Customer # Salesperson Employee # INV-1 7/7/1991 $7,200.00C-1 E-12 INV-10 8/23/1991 $32,000.00C-7 E-99 INV-11
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

Chpt_Supp_1_outline_-_Data_models - Chapter 15:...

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

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