Course Syllabus

 

 

Course Name: Principles of Databases

 

Lecture: 3530 507 01

          Tue 5:30pm – 8:20pm in (Bldg. 32, Room 107)

 

Lab: Guided Self Study

 

Semester: Spring 2008

 

Course URL:   http://www.cs.uwyo.edu/~yu/UDC3530507/DBindex.html


Instructor: Dr. Byunggu Yu

Phone: 202-274-6289 or 202-274-7455

Email: byu@udc.edu (start with “UDC-DBMS: ” in the subject field)

Office: Bldg 42/ Suite 112

Office hours: MW 11:10am-noon, MW 1pm-1:50pm, and M 2pm-2:50pm

 

 

 

Textbook:                      

 

Database System Concepts
by A. Siblerschatz, H. Korth, and S. Sudarshan, McGraw-Hill (RECOMMENDED)

Electronic Lecture Notes will be provided

 

 

Course Description:     

 

The prime objective of this course is to teach practical, but generic, skills which can be applied to a vast majority of contemporary database management systems (DBMSs). The course provides comprehensive coverage of the problems involved in database design, in-depth coverage of data models and database languages, and a survey of implementation techniques applied in modern DBMSs. Students will acquire practical skills of conceptual/logical database design and general familiarity with the problems and issues of database management. The skills developed in this course are appropriate for Database Administrators, Database Application Developers, Database Specialists, and DBMS developers. Topics include ER-models, Relational Algebra & Calculus, Structured Query Language (SQL), Integrity Constraints, Logical Database Design (Functional Dependencies, Database Anomalies, Normalizations), and introduction to DBMS implementation. In addition, some emerging database applications will be discussed.

 

 

Lecture Outline:

 

Introduction and Basic Terminology

 

Entity-Relationship (ER) Model

 

Relational Data Model & Abstract Relational Languages

 

Structured Query Language (SQL)

 
Database Design

 
Transaction & Triggers


Related UML Diagrams (Optional)

 

Introduction to New Database Applications (Discussion)

 

Note, This "Course Outline" section is subject to change. This "Course Outline" includes about 14 weeks of 3 class hours. We may modify it as the semester progresses.

 

 

Recommended Lab Self Study:

 

DBMS (e.g., Oracle or MySQL) Installation (GSG)

 

Getting Started (UM)

 

Managing Network Connections (UM & RTB)

 

Managing Memory and Storage (UM)

 

Managing User Accounts and Sessions (UM)

 

Database Migration (UM & RTB)

 

Database Backup and Recovery (UM & RTB)

 

GSG: Getting Started Guide

Recommended Textbook is only for additional references: recommended but not required.

RTB: Recommended Textbook

UM: User’s Manual

 

For this semester, Oracle10g Express SW including GSG and UM are available from http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html

Individual students are also allowed to choose MySQL (www.mysql.com) or Oracle or any complete DBMS software fully supporting Relational Model and SQL.


Note: This "Course Outline" section is subject to change. The instructor will slow down or speed up each chapter to meet the needs of students.

 

 

Learning Outcomes:

 

Upon successful completion of this course, the students will be able to:

·                     Understand database system architecture, components, and services. 

·                     Understand and compare basic database design approaches

·                     Understand database memory and storage management as a DBA   

·                     Understand user account & session management and security as a DBA   

·                     Understand basic database migration, backup and recovery mechanisms as a DBA

·                     Design, Implement and manage a reliable database system, given an application

 

 

Course Requirements:  

 

Students are expected to attend all class sessions, participate in all class/related activities, complete exams as scheduled, and turn in all assignments on time. Failure to do so may result in the loss of points or the lowering of one's grade. If you miss a class you will be responsible for all the materials and announcements covered during that class. You are expected to do your own work on all exams and assignments.

 

 

Assignments and Exams:

 

Four Assignments: 50%
Midterm Exam:   25%
Final Project:  25%

 

NOTE: Students are required to periodically check the "News" section of the class website to obtain the most current information regarding assignments, exams, project and any other matters.
 

This Syllabus is Subject to Change