DBMS ACTIVTY 3

1234567891011121314151617181920
Across
  1. 4. A stage of normalization that eliminates transitive dependency.
  2. 8. Relationship between tables in a relational model is defined by a __________ key.
  3. 9. The schema that provides a community user’s view of the database.
  4. 11. Architecture type where application and database run on the same system.
  5. 12. Architecture type that uses client, application server, and database server.
  6. 16. Middle tier in 3-tier architecture, usually containing business logic
  7. 18. The tier that directly communicates with the database server.
  8. 19. Level of architecture that separates physical, logical, and external views.
Down
  1. 1. The last stage where the system is monitored and updated.
  2. 2. The layer responsible for query optimization.
  3. 3. The stage where data models like ER diagrams are created.
  4. 5. A type of data model that organizes data into rows and columns.
  5. 6. A type of data model closest to the way humans perceive data.
  6. 7. Entity type that depends on another entity for its existence.
  7. 10. A unique identifier for each row in a relation.
  8. 13. Highest normal form where multivalued dependencies are removed.
  9. 14. Rule in normalization that removes repeating groups.
  10. 15. The innermost schema describing how data is stored on disk.
  11. 17. The outermost schema that defines how data is viewed by end users.
  12. 20. A logical structure that shows entities and relationships.