Lecture Notes - Info 275

 

Course Outline

 Lectures Term Project Assignments Access Practice Files Mid-Term

 

 

Date
Topic

 
Introduction

 

Introduction to Databases

 

Database environment

 

Entity-Relationship Modeling

 

Data Dictionary

 

Quiz 1 Model

 

Relational Model  Quiz1 Answers

 

Normalization

 

Normalization Example
 

Intro to SQL

 

DreamHome SQL     SQL Sample

 

DreamHome SQL1

 

Quiz 2 Model    Student IS: Sample

 

Quiz 2 Answers

 

SQL for Join

 

DreamHome Demo
  Conceptual Design  Steps

 

Local Logical Design

 

Global Logical Design

 

Physical Design
 

Quiz 3 Answers   Asst 2 Answers
 

April 03 Exam