Welcome to DBS211 - Introduction to Database Systems

NOTE: This website is a work in progress and will be updated periodically to correct mistakes, add additional material and practice exercises.  Please do not hesitate to email the author if you find any mistakes that need to be corrected.  Please include the URL of the page where changes need to occur.

Weekly Outline

Week Major Topics

PREFACE and Preparation for the Course (Installation of required software)
1 Introduction
Databases, Database Systems, Data Anomalies, Development Life Cycle,
SQL Developer (Installation and Getting Started)
2 Relational Model
Relational Databases, Relationships, Referential Integrity, Table Types, Various Keys
3 SQL (Structured Query Language)
Single Table Queries, DML ( SELECT, source FROM, filtering WHERE, Sorting ORDER BY, Aliases, Wildcards, CRUD (INSERT, UPDATE, & DELETE) as well as fundamental concepts of case sensitivity, date formats, and internationalization.
4 More SQL
Multiple Table Queries, DML( ANSI-89 Joins, ANSI-92 Joins, Views )
Data Types, Constraints, SQL - DDL ( CREATE, CREATE OR REPLACE, ALTER )
6 Transactions
Transactions, Concurrency, Basic Database Security ( GRANT and REVOKE )
7 Review and Midterm
Review for midterm and midterm test
Study Week
8 Database Applications
Application Architecture Development, Roll of Database, Design Methodologies, Database Access and Connections
9 Entity Relationship Diagrams
Data Modelling, ERDs ( Entity Relationship Diagrams ), Cardinalities or Optionalities, ERD Formatting and Symbology
10 Normalization 1
DBDL, UNF and 1NF, Repeating Groups, Multi-Value Dependencies, Atomic Fields
11 Normalization 2
2NF and 3NF, Partial Dependencies, Transitive Dependencies
12 Normalization 3
Case Study
13 Review and Project Submission
Final project submission and review of topics for final test.
14 Final Test
The final assessment for the course

Code Examples and Resources

Code Examples

Code examples, where they are appropriate, are provided within each weeks content. Your professor may choose to do other code examples with you as well in addition to those here.