ER Modeling 1
Course OutlineER Modeling
MS Access 2007
Ch2: Relational databases and multi-table queries
Ch3: Customize, analyze, and summarize query data
Ch4: Create, edit, and perform calculations in reports
Ch5 (in Access 2003): One-to-Many Relationships: Subforms
and Multiple Table Queries
Ch6: Data protection: integrity, validation, and reliability
Ch7: Advanced queries: using queries to change data
Ch10: Macros and Visual basic for applications
Appendix B:
Designing a Relational Database
About Normalization
Normalization for Relational Databases
Questions concerning Normalization
About Join operations
Assignments
Assignment #1
Hint for Assignment #1: Team-game database design
Disccusion on Test 2
Experiments
Experiment 4
Experiment 5
Experiment 6
Experiment 7
ER-Diagram for teams and games
Sample Question for Final Exam.