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: firstname.lastname@example.org (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
Database System Concepts
by A. Siblerschatz, H. Korth, and S. Sudarshan, McGraw-Hill (RECOMMENDED)
Electronic Lecture Notes will be provided
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.
Introduction and Basic Terminology
Entity-Relationship (ER) Model
Relational Data Model & Abstract Relational Languages
Structured Query Language (SQL)
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.
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
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
This Syllabus is Subject to Change