Database Design and Management

COMP-1200

                                                    

Microsoft Access 2007 (Introductory)

by Adamski

 

These books are available at the CCRI Bookstore or on-line at Course Technology directly

                           Click here for course Syllabus                   WebCT Sign-In Instructions

                           Classroom Presentations                                 

Chapter 1 - Database Systems

Chapter 2 – Data Models

Chapter 3 – The Relational Database Model                              Referential Integrity Video

Chapter 4 – The Entity Relationship (E-R) Model

Chapter 5 – Database Tables and Normalization

Chapter 7 – Introduction to SQL

Chapter 10 – Transaction Management and Concurrency Control

Assignment Files

Assignment #1 (Normalization)	Customer (Text File)	Center (Excel File)
Assignment #2 (SQL)	Invoices (Excel File)	Weights (BMP File)
Database for Assignment #2	Landscape (BMP File)	Health
	Oren	Training
Take-Home Final Project	Panorama
Take-Home Final Worksheet	Sarah

Class Notes and Handouts                                 Access Tutorials 

Course Syllabus	Tutorial 1
Database Glossary of Terms  (PDF Format)	Tutorial 2
Sample Customer ERD	Tutorial 3
Sample Store ERD	Tutorial 4
Sample Management ERD	Tutorial 5
Sample Member ERD
	Chocolate SQL
SQL Sample
Sample SQL Functions	Exam 2 Review