This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: tructured Systems Analysis: tructured Systems Analysis: Structured Systems Analysis: Structured Systems Analysis: Design of Data Stores Design of Data Stores EGA/ERLJ IE 154 Objectives for Today r Know the principles of data store design r Know the different ways to improve data stores r Define and determine data store primary eys keys r Use normalization to improve data stores r Define functional dependencies r Know the steps of normalization r Solve an example Rationale r One of output of the new logical design is the different data stores that need to be improved. r During Systems Design the Data Stores are converted to Databases. r During conversion, analysis of the data stores must be done such that data redundancy can be minimized or even totally removed. Data Store Design Principle r It is usually cheaper and easier to change the logic of a process than to change the structure of a data store. r Hence, the structure of a data store should be as simple and as general as possible Objectives for Today r Know the principles of data store design r Know the different ways to improve data stores r Define and determine data store primary eys keys r Use normalization to improve data stores r Define functional dependencies r Know the steps of normalization r Solve an example Defining the Contents of the New System r 1. look up the data flows going into or out of the data store in the data dictionary to find their component data structures and contents. Compare the contents of the flows going in and out. Make sure all the data content requirements (based on the outflows) of the store can be met by the inflows r 2. Produce a draft of the contents of the data store, based on the analysis of the inflows and outflows. r 3. Simplify the contents by inspection r 4. Simplify the data store by normalization Data Structure: Inflows NEWEMP EMPN EMPM HIRED ADDRT JOBTITLEM STARTSALA EMPN EMPN EMPM TERM ADDRCHNGE EMPN EMPM OLDADDRT NEWADDRT SALCHNGE EMPM OLDSALA NEWSALA EFFCTD Data Structure: Outflows EMPADDR EMPN MP EMPN ADDRT EMPM CURNTSALA TERM EMPHIST EMPN EMPM HIRED JOBHIST (j) JOBTITLEM EFFECTD SALCHNGE (s) SALA EFFCTD Analysis: Additional Inflows ITLE HANGE EMPN EMPM LD ITLE TITLECHANGE OLDTITLEM NEWTITLEM EFFECTD Data Store Contents EMPN EMPM ADDRT CURNTSALA HIRED EMP JOBHIST (j) JOBTITLEM EFFECTD SALCHNGE (s) SALA EFFCTD Sample Contents of EMP EMPN EMPM ADDRT CURNTSALA HIRED 12321 Dela Cruz, Juan 111, Quezon Ave. QC 21,900 01/01/09 12345 Grande, Miguelito 222, EDSA. Mandaluyong 80,000 01/01/07 JOBHIST SALHIST JOBTITLEM EFFECTD SALA EFFCTD Clerk Programmer 01/01/09 06/06/09 20,400 21,900 01/01/09 06/06/09 Assistant Professor Associate Professor Professor 01/01/07 06/01/07 07/01/08 31,000 50,000 80,000 01/01/07 06/01/07 07/01/08 Revised Data Store EMPN EMP EMPM ADDRT JOBSALHIST (j) JOBTITLEM EFFECTD SALA Revised Sample Data Store EMPN EMPM ADDRT JOBSALHIST EFFECTD JOB...
View
Full Document
 Spring '11
 a
 Database normalization, Data Store, data stores

Click to edit the document details