Instructor intent - Upon completion of the course, the student will have an understanding of both the principles and practices of DBMS, DBMS design and administration, and the relevance of data and data management to current and emerging business trends. It is not the intent of this course to create specific technical skills for any database in terms of mastery of technical detail. Focus will be on database theory and application to the business environment, as opposed to practical knowledge in any particular vendor or product. Demonstrations and/or lab situations will be used to reinforce specific educational objectives. The student is encouraged to use the instructor's website for exam feedback, lesson plans, and other support materials outside the classroom.

Incoming Competency: The student should have communicative and written skills (written and oral) commensurate with graduate level academic requirements. Students must have completed COMP 5000 or must have this course waived. The student should have completed COMP 5920, COMP 5940, and COMP 5960.

Text:

"Database Management Systems - Designing and Building Business Applications" - Gerald V. Post, Irwin McGraw-Hill ISBN 0-02-366881-4

Supplemental Readings:

To be provided by instructor from current periodicals. Material appropriate for examination will be identified.

Evaluation Criteria:

Final course grade shall be determined by achievement of a percentage of the potential total points for the class:

90% - A

89% - A-

88% - B+

80% - B

79% - B-

70% - C

Six weekly 15 minute exams will be given at the beginning of Weeks 2, 3, 4, 6, 7, 8. Each weekly exam shall be multiple-choice and/or short answer and will count toward 3% of the final grade – total 18%

Homework assignments will be given (as a short essay or design problem) to be completed prior to weeks 2, 3, 4, 6, 7, 8. Extra credit opportunities will be identified. Each homework assignment will contribute 3% for a total of 18%. No credit given for late submission of homework.

A midterm exam of one hour will be given during week 5. It will count toward 20% of the class grade.

A final exam of two hours will be given during week 9. It will count toward 40% of the final grade.

Classroom participation will be subjectively graded for 4% of the final grade.

For students that can demonstrate substantial professional experience in database design, administration and application, an alternate thesis / project may be assigned for the entire course grade in lieu of classroom work. Interested students should identify themselves to the instructor at the end of Session 1.

Downloads (in zip format) are available for all Powerpoint presentation slides used in class, and for the databases used in class.

Class Content and Assignments

Week 1 – Introduction

Preperatory Reading: none

1. Class Introduction / Instructional Dynamics
2. Introduction to Database Processing
3. Application Development Without A Database
4. Class Room Exercise
5. Advantages of the Database Management Approach
6. Components of a Database Management System
7. Leading Commercial Databases
8. Brief History of Database Management Systems.

Week 2 - Database Design

Preparatory Reading - Text Chapters 1 - 2

1. Week 1 Review / Parking Lot Review / Quiz
2. The Feasibility Study
3. Designing Systems
4. Class Diagrams
5. Lab Exercise - Sally's Pet Store
6. Data Types (Domains)
7. Events / Large Projects

Week 3 - Data Normalization

Preparatory Reading - Text Chapter 3

1. Week 2 Review / Parking Lot Review / Quiz
2. Overview and Introduction to Data Normalization
3. Tables, Classes, and Keys
4. Class Room Exercise - Video Store
5. First Normal Form (1NF)
6. Second Normal Form (2NF)
7. Third Normal Form (3NF)
8. Beyond Third Normal Form
9. Data Rules and Integrity
10. The Effects of Business Rules
11. Converting a Class Diagram to Normalized Tables
12. View Integration
13. Data Dictionary

Week 4 - Data Queries

Preparatory Reading - Text Chapter 4

1. Week 3 Review / Parking Lot Review / Quiz
2. The Four Questions to Create a Query
3. Classroom Exercise - Sally's Pet Store
4. Query Basics
5. Computations
6. Sub-totals and GROUP BY
7. Multiple Tables

Week 5 - Midterm / Advanced Queries and Sub-Queries / Forms and Reports

Preparatory Reading - Text Chapters 5-6

1. Week 4 Review / Parking Lot Review
2. Mid-Term Exam
3. Introduction / Overview to Advanced Queries
4. Classroom Exercise - Sally's Pet Store
5. Subqueries
6. Subtraction (NOT IN)
7. Outer Joins
8. Correlated Sub-queries? Are You Nuts?
9. SELECT
10. SQL Data Description Language (DDL) and Data Description Language (DML)
11. Overview / Introduction of Forms
12. Effective Design of Reports and Forms
13. Form Layout
14. Creating Forms
15. Direct Manipulation of Graphical Objects
16. Reports

Week 6 - Calculations and Data Manipulation / Application Development

Preparatory Reading - Text Chapters 7-8

1. Week 5 Review / Mid-Term Review / Parking Lot Review / Quiz
2. Overview and Introduction of Calculations and Data Manipulation
3. Languages / Environments
4. Data on Forms
5. Using Programs to Retrieve and Save Data in the Database
6. Handling Errors
7. Classroom Exercise - Sally's Pet Store
8. Overview and Introduction of Application Development
9. The Power of Applications
10. Application Structure
11. User Interface Features
12. Transactions
13. Improving Forms to Help Users
14. Distributing Applications with Microsoft Access

Week 7 - Physical Design / Database Administration

Preparatory Reading - Text Chapters 9 - 10

1. Week 6 Review / Parking Lot Review / Quiz
2. Overview and Introduction of Physical Design
3. Table Operations
4. Data Storage Methods
5. Storing Data Columns
6. Data Clustering and Partitioning
7. Existing Database Management Systems
8. Classroom Exercise - Sally's Pet Shop
9. Overview and Introduction of Database Administration
10. Data Administration
11. Database Administration
12. Database Tasks by Development Stages
13. Database Application Types
14. Backup and Recovery
15. Security and Privacy
16. Encryption

Week 8 - Distributed Databases and the Internet / OODB

Preparatory Reading - Chapters 11 - 12

1. Week 7 Review / Parking Lot Review / Quiz
2. Overview / Introduction of Distributed Databases & the Internet
3. Class Exercise - Sally's Pet Store
4. Distributed Databases
5. Client/Server Databases
6. The Web as a Client/Server System
7. Overview and Introduction of Object-Oriented Databases
8. Data Types and Objects
9. Object-Oriented Databases and SQL3
10. Integrated Applications

Week 9 - Capstone / Emerging Business & Societal Trends / Final Exam

Preparatory Reading - Handouts from Week 8

Note - material from the lecture part of this session will not be included on the final exam.

1. Final Parking Lot Review
2. Enterprise Resource Planning
3. Targeted Marketing
4. Competitive Pressures in Time-to-Market
5. Web-Based Commerce Effects on Advertising
6. Security and Privacy in the Public Domain (What's a Cookie Got to Do With Me)
7. Universal Data Access
8. Avatars and Agents
9. Why on Earth do I Want to Be Involved With Databases?
10. War Stories from the Bleeding Edge (if time permits)
11. Final Exam

seekers of enlightenment used this page

This page hosted by