Computerized Database Systems

By the end of this unit, I will be able to:

• Gather requirements and build entity-relationship diagrams

• Apply normalization and design logical/physical database structures

• Choose appropriate data types and indexing strategies

• Create tables, forms, queries, reports, and macros

• Define fields, keys, and relationships (1:1, 1:M, M:N)

• Apply integrity constraints and indexes

• Perform CRUD operations and write SQL commands

• Create views and generate formatted reports

• Develop test plans and perform structural, functional, and non-functional testing

• Use white-box and black-box testing techniques, including load and stress testing

• Optimize queries and manage indexing/partitioning