Course Title:
|
Course Materials:
| Connolly, T., & Begg. C. (2005). Database systems: A practical approach to design, implementation, and management (4th ed.). Harlow, England: Pearson Education Limited. | |
Course Description:
| CMIS 320 Relational Databases (3) Prerequisite: CMIS 102 or 102A. A study of the functions and underlying concepts of relationally organized database systems. Discussion covers data models and their application to database systems. The entity/relationship (E/R) model and Codd's relational theory--including relational algebra, normalization and integrity constraints, and the Structured Query Language (SQL)--are emphasized. Physical design and data administration issues are addressed. Projects include hands-on work with E/R and relational models (using industry standard database software). Students may receive credit for only one of the following courses: CMIS 320 or IFSM 410. | |
Course Goals/Objectives:
After successfully completing this course, students should be able to:
*Describe the relational model in detail
*Describe how relational databases differ from other types of databases
*Compare desktop, workgroup, and enterprise database environments
*Compare various database architectures
*Describe the purpose of the relational algebra and relational calculus and how they differ
*Describe the normalization process through the third normal form
*Construct an entity/relationship diagram
*Create a relational database using SQL
*Access data from relational database tables
*Discuss current and historical trends in the database industry | |
Course Introduction:
CMIS 320 is your starting point to using and understanding databases, which are the central tools of the information age. You should find the course useful, whether your interest is programming, development, and/or administration.
This course will also help develop your data-related intuition. This will help you quickly recognize the important data and information-flows in any business or system you study. You will also get to practice many of the techniques used to describe and structure data, so that you can plan and build the foundations of useful infomation systems.
This is an intensive class. You will need to absorb material quickly, with a high level of understanding. Plan to spend substantial time reading the text and other handouts, reviewing, completing homework assignments or projects, and studying for exams. | |
Grading Information and Criteria:
Grading Information:
Homework: 20%
Database project: 30%
Midterm exam: 25%
Final exam: 25%
Grading Scale:
Letter grades will be assigned as follows:
90-100% = A
80 - 89% = B
70-79% = C
60-69% = D
Less than 60% = F | |
Other Information:
|
Project Descriptions:
Project 1: Solving a simple but practical problem by writing SQL to create, populate, and generate reports from a relational database.
Project 2: Requirements discovery and ERD development.
Project 3: A simple but complete database design and development including SQL. | |
Academic Policies:
Cases of plagiarism are handled consistent with current UMUC guidelines.
See the UMUC policies at the following URL:
http://www.umuc.edu/policy/ | |
Course Schedule:
All readings are from the assigned text
Session 1.
Introduction to Databases: File-based systems, the database approach, roles, history and advantages and disadvantages of DBMS
Database Environment: ANSI-SPARC architecture, database languages, data models and conceptual modeling, functions and components of a DBMS, multi-user architectures, system catalogs. Chapters 1 & 2
Session 2.
The Relational Model: History, terminology, relational integrity, views. Practical application. Chapter 3
Session 3.
Relational Algebra and Relational Calculus: Operations of relational algebra, tuple relational calculus, domain relational calculus SQL: Data Manipulation: Intro to SQL, data manipulation SQL commands. Chapters 4 & 5
Session 4.
SQL: Data manipulation: Data manipulation commands continued. Lab work.
SQL: Data Definition: Data types, integrity constraints. Chapter 5 & 6
Session 5.
SQL: Data Definition: Data definition commands, views, transactions, access control, Lab work. Chapter 6
Session 6.
Database Planning, Design, and Administration: Lifecycle concepts, analysis and design concepts (system definition, requirements, database and application design), implementation concepts, maintenance, database administration.
Fact Finding: Requirements discovery, fact-finding techniques. Chapter 9 & 10
Project 1 due
Session 7.
Review and Midterm Exam
Session 8.
ERDs: Entity and relationship types, attributes, strong and weak entities, attributes on relationships, structural constraints. Chapter 11
Session 9.
ERDs continued: Structural constraints, fan traps, chasm traps, enhanced ERDs (specialization and generalization, aggregation, composition). Chapters 11 & 12
Session 10.
Normalization: Purpose of normalization, redundancy and update anomalies, functional dependencies, 1NF and 2NF. Chapter 13
Project 2 due.
Session 11.
Normalization: 3NF, general definitions of 2NF and 3NF, BCNF, overview of 4NF and 5NF. Practical examples. Chapter 13
Session 12.
Methodology - Conceptual DB Design: Intro to DB design methodology, steps in building a local conceptual data model, practical examples. Chapter 14
Session 13.
Methodology - Logical DB Design: Steps in building and validating local (per-view) and global logical data models, practical examples. Chapter 15
Session 14.
Database Security: Selected database security topics from Chapter 18 and current supplementary materials. Chapter 18
Supplementary material
Session 15.
Project workshop: Application of the concepts covered in the course to project 3.
Session 16.
Final exam, Project 3 due. | |
Search
MyUMUC
WebTycho