1 / 15

Database Analysis

Database Analysis. Preliminary List of Subjects. Introduction Database development process E-R models The Relational Model Physical Database Design SQL Database Application Design Data Warehousing. ERD – Basic Notation. Relationship. ENTITY TYPE. ENTITY TYPE. Relationship.

patsy
Download Presentation

Database Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related