Database Analysis - PowerPoint PPT Presentation

database analysis n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Database Analysis PowerPoint Presentation
Download Presentation
Database Analysis

play fullscreen
1 / 15
Database Analysis
143 Views
Download Presentation
patsy
Download Presentation

Database Analysis

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Database Analysis

  2. Preliminary List of Subjects • Introduction • Database developmentprocess • E-R models • The Relational Model • Physical Database Design • SQL • Database Application Design • Data Warehousing

  3. ERD – Basic Notation Relationship ENTITYTYPE ENTITYTYPE Relationship Relationship ENTITYTYPE ENTITYTYPE Relationship Used In ITEM PRODUCT Uses

  4. ERD - Cardinalities 0..1 (default) ”One” 1 Mandatory One 0..1 Optional One 0..n (default) ”Many” 1..n MandatoryMany 0..n OptionalMany

  5. ERD – Entity Types STRONG WEAK ASSOCIATIVE

  6. ERD – Relationship Types ENTITYTYPE Unary Binary ENTITYTYPE ENTITYTYPE ENTITYTYPE ENTITYTYPE Ternary ENTITYTYPE

  7. ERD – n-aryRelationships ENTITYTYPE ENTITYTYPE ENTITYTYPE ENTITYTYPE ENTITYTYPE ASSOCIATIVE ENTITYTYPE

  8. ERD - Attributes ENTITY NAME EntityAttributes Identifier PartialIdentifier Attribute Optional [Derived] {Multivalued} (Composite, …)

  9. ERD – RelationshipAttributes Attribute ENTITYTYPE ENTITYTYPE ENTITYTYPE ENTITYTYPE ASSOCIATIVE Attribute

  10. Data Modelling • Data namesshould • Relate to business • Bemeaningful • Beunique • Bereadable • Berepeatable • Follow standard syntax, eg. ”Patient FirstName” (<Entity> <Qualifier> <Attribute>)

  11. Entities • Entity ”sources” • Person • Employee, student, patient • Place • Store, Warehouse, State • Object • Machine, Building, Automobile • Event • Sale, Registration, Renewal • Concept • Account, Course, Work Center

  12. Entities • Entity Type vs. EntityInstance • Strong vs. WeakEntity Types

  13. EntityNaming • SingularNoun (plural and aliases i definition) • Specific • Concise • ”Event name” – not activityorprocess

  14. Attribute Types • Identifier • PartialIdentifier • Required (*) • Optional (o) • Derived ([…]) • Multivalued ({…}) • Composite ((…,…))

  15. Relationships • Attribute vs. Relationships • Multiple relationshipsbetweenentity types