Create an entity-relationship (ER) diagram to solve a basic database problem;
computer science
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
assignment2105s20.pdf
264.6 KB
