Data Management and Development Notes

Data Management and Development Notes - Database Management...

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

View Full Document Right Arrow Icon
Database’Management’and’ Development’ Supplemental’package’posted’on’ Sakai’
Background image of page 1

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

View Full Document Right Arrow Icon
Data’and’Informa9on’ Management’ Data’is’the’basic’ building’block’of’ informa9on’and’ knowledge’ Data’management’must’ be’efficient’and’ eFec9ve’ Data’must’be’accessible’ Data’ Informa9on’ Knowledge’
Background image of page 2
Tradi9onal’File’Systems’ Each’department’or’ business’unit’would’have’ its’own’fle’systems’ The’same’data’or’±acts’ could’appear’on’many’ di²erent’fle’systems’ within’the’organiza9on’ Data’structure’and’ processing’were’coded’ together’in’these’systems’ Accoun9ng’ Engineering’ Marke9ng’
Background image of page 3

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

View Full Document Right Arrow Icon
Tradi9onal’File’Systems’ Problems’ Data’redundancy’ Leads’to’data’inconsistency,’anomalies’and’other’data’ integrity’problems’ Data’and’structural’dependence’ Requires’extensive’programming’to’add’or’delete’a’ feld,’change’the’data’type’within’a’feld,’etc.’ Inadequate’analy9c’capabili9es’ Excessive’programming’requirements’
Background image of page 4
The’Database’Approach’ A’ database ’is’ A’shared,’integrated’repository’ It’houses’end-user±s’data’and’metadata’(data’ about’the’data)’ A’ Database’Management’System’(DBMS) ’is’a’ collec9on’of’programs’that’manages’database’ structure’and’controls’access’to’the’data’ Examples’are’MS’Access,’MS’SQL’Server,’Oracle,’ IBM’DB2’
Background image of page 5

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

View Full Document Right Arrow Icon
The’Database’Approach’ All’data’is’stored’in’a’ common’database’ Each’department’or’ business’unit’has’its’ own’programs’for’data’ processing’ Programs’and’users’ access’the’data’through’ the’DBMS’ Database’ DBMS’ Accoun9ng’ Engineering’ Marke9ng’
Background image of page 6
Database’Models’ A’database’model’is’used’to’represent’the’ data’structure’and’the’data’rela9onships’ within’the’database’
Background image of page 7

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

View Full Document Right Arrow Icon
Data’rela9onships’ One-to-many’rela9onships’ Example:’A’painter’may’paint’many’pain9ngs,’but’ each’pain9ng’is’only’painted’by’one’painter’ Many-to-many’rela9onships’ Example:’A’student’may’take’many’courses’and’ each’course’can’be’taken’by’many’students’ One-to-one’rela9onships’ Example:’A’salesperson’is’assigned’to’a’company’ car’
Background image of page 8
Evolu9on’of’database’models’ Hierarchical’model’ Rela9onships’between’the’data’must’Ft’an’ upside-down’“tree”’or’“parent-child”’structure.’ Data’can’only’have’one-to-many’rela9onships’ Data’must’always’be’retrieved’from’the’top’down’ Not’flexible’ ±inal’ Assembly’ Component’ A’ Part’1’ Part’2’ Component’ B’ Part’3’
Background image of page 9

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

View Full Document Right Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 63

Data Management and Development Notes - Database Management...

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

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