Description

Assignment 2: Relational Databases, Access, and SQL

Learning Goals:
At the end of this assignment you will be able to: 

• Analyse a basic problem from a structured, relational perspective;
• Create an entity-relationship (ER) diagram to solve a basic database problem; 
• Create a simple relational database using MS Access; 
• Input data into an MS Access database; 
• Create, use, and display SQL queries from a relational database.

References: 

Research work for this lab can be found in your text - module 11, in the on-line Access documentation, from your lab and lecture notes, and, of course, by asking the CSC Consulting/Help Desk, your Lab Instructor, and/or your Instructor (Rich or Eduard) for assistance with any questions you might have. 

Instruction Files