05_Organizing_and_manipulating_dbases

05_Organizing_and_manipulating_dbases - Overview...

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

View Full Document Right Arrow Icon
1 Organizing and Manipulating Databases Lect 5 ` Normalization ` Validating data inputs ` Extracting data from databases Overview 2 ` Flat files ` Normalization ` 1 st normal form ` 2 nd normal form ` 3 rd normal form Normalization 3 Case 14-23 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. 4 Case 14-23 ` Reorganize the data in first normal form. Why is your data in first normal form? ` Reorganize the data from part 1 into second normal
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/20/2010 for the course ECON econ185 taught by Professor M. during the Fall '09 term at UCSB.

Page1 / 2

05_Organizing_and_manipulating_dbases - Overview...

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

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