1 / 49

Introduction to Database Design

Database Design Agenda. General Design ConsiderationsEntity-Relationship ModelTutorialNormalizationStar SchemasAdditional InformationQ

theola
Télécharger la présentation

Introduction to Database Design

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. Introduction to Database Design

    2. Database Design Agenda Name and level of experience with topic.Name and level of experience with topic.

    3. General Design Considerations Name and level of experience with topic.Name and level of experience with topic.

    4. Users Entities denote people, places, things, or event of informational interest. Nouns. Entities should contain descriptive information.Entities denote people, places, things, or event of informational interest. Nouns. Entities should contain descriptive information.

    5. Legacy Systems/Data

    6. Application Requirements

    7. Entity - Relationship Model

    8. Entities Entities denote people, places, things, or event of informational interest. Nouns. Entities should contain descriptive information.Entities denote people, places, things, or event of informational interest. Nouns. Entities should contain descriptive information.

    9. Attributes Provide details about the entities, Entity of person, attribute is name, hair colorProvide details about the entities, Entity of person, attribute is name, hair color

    10. Relationships

    11. Relationship Connectivity Each department can have multiple employees.Each department can have multiple employees.

    12. Connectivity Each department can have multiple employees.Each department can have multiple employees.

    13. ER example

    14. Team Entities & Attributes

    15. Team Relationships

    16. Team Relationships

    17. Team ER Diagram

    18. Logical Design to Physical Design Provide details about the entities, Entity of person, attribute is name, hair colorProvide details about the entities, Entity of person, attribute is name, hair color

    19. Entity tables Provide details about the entities, Entity of person, attribute is name, hair colorProvide details about the entities, Entity of person, attribute is name, hair color

    20. Foreign Keys Provide details about the entities, Entity of person, attribute is name, hair colorProvide details about the entities, Entity of person, attribute is name, hair color

    21. Foreign Key

    22. Many-to-Many tables Provide details about the entities, Entity of person, attribute is name, hair colorProvide details about the entities, Entity of person, attribute is name, hair color

    23. Many-to-Many tables

    24. Tutorial Teragrid: ssh user@tg-login.sdsc.teragrid.org Echo $DB2INSTANCE -> null then run: soft add +db2 db2Teragrid: ssh user@tg-login.sdsc.teragrid.org Echo $DB2INSTANCE -> null then run: soft add +db2 db2

    25. Tutorial List database directory Get authorizations List tables for schema <user>List database directory Get authorizations List tables for schema <user>

    26. Tutorial List database directory Get authorizations List tables for schema <user>List database directory Get authorizations List tables for schema <user>

    27. Normalization Accomplish normalization by analyzing the interdependencies among attributes in tables and taking subsets of larger tables to form smaller ones. The subsets are created from examining the interdependencies among the table attributes.Accomplish normalization by analyzing the interdependencies among attributes in tables and taking subsets of larger tables to form smaller ones. The subsets are created from examining the interdependencies among the table attributes.

    28. First Normal Form (1NF)

    29. 1NF

    30. Second Normal Form (2NF)

    31. Functional Dependence

    32. 2NF

    33. Data Integrity

    34. Third Normal Form (3NF)

    35. Transitive Dependence Note, dept_name is functionally dependent on dept_no. Dept_no is functionally dependent on emp_no, so via the middle step of dept_no, dept_name is functionally dependent on emp_no. (emp_no -> dept_no , dept_no -> dept_name, thus emp_no -> dept_name)Note, dept_name is functionally dependent on dept_no. Dept_no is functionally dependent on emp_no, so via the middle step of dept_no, dept_name is functionally dependent on emp_no. (emp_no -> dept_no , dept_no -> dept_name, thus emp_no -> dept_name)

    36. 3NF

    37. Other Normal Forms

    38. Normalizing our team (1NF)

    39. Normalizing our team (2NF & 3NF)

    40. Revisit team ER diagram

    41. Star Schemas

    42. Fact Table

    43. Dimension Table

    44. Star Schema which provides an intuitive schema for querying information.which provides an intuitive schema for querying information.

    45. Analyzing the team

    46. Team Dimension

    47. Team Star Schema

    48. Books and Reference

    49. Continuing Education

    50. Data Central

More Related