PCSY156

DATES:

1. Overview
   • Examine and demonstrate database design concepts.
   • Review and expand upon the concepts specific to the environment of the participants attending the course.
2. Introduction to Database Design
   • Examine and analyze a database design document.
   • Analysis of a simple database design; this will be expanded upon and modified later in the course.
3. Entities
   • Create classes and then classify each of the entities that have been designed.
   • Manufacturing production case study: Creating a database.
   • Design entities which emphasize the physical attributes of each entity.
   • Code or generate the DDL and implement the database.
4. Relationships
   • Create relationships and then classify each of the relationships.
   • Define each relationship.
   • Referential integrity relationships will be documented and implemented.
5. Attributes
   • Create unique and check constraints.
   • Evaluate the type of data integrity and constraints.
   • Document and create unique indexes.
   • Perform data editing by checking constraints and utilizing triggers.
6. Entity Keys
   • Create keys which demonstrate improved performance and other costs.
   • Design, classify, and create keys for each entity.
   • Evaluate the effect of the design on I/O cost, index levels, leaf and non leaf amounts, and space issues.
7. Refining the Data Model
   • Refine the completed data model.
   • Review and refine the design.
8. Normalization
   • Review the design for denormalization.
   • Calculate the approximate physical cost to retrieve the data.
   • Empirically determine whether denormalization is required.
   • Review the data model to determine if the appropriate level of denormalization has been used and whether there was an alternative for avoiding denormalization.
9. Data Integrity
   • Review the design for data integrity.
   • Implement hierarchical structures to ensure that integrity, completeness, and the ability to traverse the hierarchy have been incorporated into the design.
10. Physical Design Considerations
    • Utilize the physical design techniques on an existing database.
    • Case study: Identify and propose solutions for the partitioning of data, indexes, join techniques, and volatile columns.
11. Application Design and Indexes
    • Determine optimization design techniques based upon the databases heuristics.
    • Determine the access path and cost for physical design.

↓