Logical Design

  1. Explain the fundamental concepts of the relational data model, including relations, attributes, keys, and constraints.
  2. Demonstrate how to transform an E-R model into a relational data model.
  3. Demonstrate how relations can be normalized, including an understanding of first through fifth normal forms, functional dependencies, partial dependencies, transitive dependencies, multivalued dependencies, and join dependencies.
  4. What are the problems encountered in view integration?