05_Database_Organization

05_Database_Organization - Econ 185 Lecture 05 Econ 185...

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

View Full Document Right Arrow Icon
Econ 185 Lecture 05 1 Econ 185 Glenn Owen UC Santa Barbara ` Normalization ` Validating data inputs ` Extracting data from databases ` Data warehouses 2 ` Flat files ` Normalization 1 st normal form 2 nd normal form 3 rd normal form 3
Background image of page 1

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

View Full DocumentRight Arrow Icon
Econ 185 Lecture 05 2 Swan’s Supplies is a wholesaler of sporting goods equipment for retailers in a local metropolitan area. The company buys sporting goods equipment direct from manufacturers and then resells them to individual retail stores in the regional area. The raw data below illustrate some of the information required for the company’s purchase order system. As you can see, this information is characteristic of accounting purchase order systems but is not well organized. In fact, because of the repeating groups in the right- most columns it cannot even be stored in a computer system most columns, it cannot even be stored in a computer system. 4
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 / 4

05_Database_Organization - Econ 185 Lecture 05 Econ 185...

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