Module 4

Schema Restructuring

Transform a conceptual schema without losing information.

Advanced 330 min 0 of 11 lessons published

Lessons

  1. 1
    Why Restructure a Conceptual Schema Advanced Coming soon
  2. 2
    Analysing Redundancies Advanced Coming soon
  3. 3
    Eliminating Generalisations Advanced Coming soon
  4. 4
    Collapsing Child Entities into the Parent Advanced Coming soon
  5. 5
    Pushing the Parent into the Child Entities Advanced Coming soon
  6. 6
    Replacing Generalisations with Relationships Advanced Coming soon
  7. 7
    Handling Multivalued Attributes Advanced Coming soon
  8. 8
    Handling Composite Attributes Advanced Coming soon
  9. 9
    Choosing the Primary Identifiers Advanced Coming soon
  10. 10
    The Cost of Each Transformation Advanced Coming soon
  11. 11
    Restructuring a Complete E-R Schema Advanced Coming soon