| Course number |
MS-483 |
| Course title |
Database Management Systems |
| Course description |
An introduction to the elements of database management systems
(DBMS) is presented in this course. Several database models are
covered (Hierarchical, Network, and Relational), with the Relational
database model emphasized as the most important of the three.
Entity relationship diagrams are used to illustrate the concepts of
data modeling and database design. Schemas and normalization are
also covered in their relationship to design. Relational algebra is
used as a basis for the understanding of the industry standard
Structured Query Language (SQL). Transactions and concurrent
database processing are also covered. (prereq: MS-382) |
| Prerequisites |
MS-382 |
| Corequisites |
none |
| Required materials |
- Database Processing: Fundamentals, Design, and Implementation,
Tenth Edition by David Kroenke
|
| Course objectives |
- Understand what a database is, why they are used, and how they
are built
- Learn how to build and use an entity relationship
model in ERD standard form
- Understand the fundamental
aspects of data modeling and database design
- Understand First through Fifth
normal forms, Boyce-Codd normal form, and Domain Key Normal form
relations
- Learn how to use the Structured Query Language (SQL) to define
and manipulate database information
- Understand how database
transactions control concurrent access to data elements
- Understand how, when, and where to use stored procedures,
triggers, rules, and views
- Learn how database performance
tuning can
aid the access and manipulation of data
- Understand the
administrative roles associated with a database and how one is
managed
- Understand how database systems can be a part of a larger
application and provide a demonstration
Verify the objectives against the Course Grade Book
|
| Course topics |
- Contained in Course Objectives
|
| Prereqs by topic |
- Some familiarity with computing
(Windows system usage)
- Knowledge of a programming language
(Java or a similar language)
|
| Course structure |
2-2-3 (class hours/week, laboratory hours/week, credits) |
| Course topics by day |
Lecture
topics page |
| ABET content |
| Engineering topics |
Design |
General education |
Math/science |
Other |
| 0 |
0% |
0 |
2 |
2 | |
| Laboratory topics |
|
| Student Work |
Low, Medium, and High scoring samples will be saved by all
instructors of this course for the following terms:
- Spring, 2003
- Fall, 2003
- Winter 2003-04
|
| Coordinator |
Dr. Jeffrey J. Blessing, Associate Professor |
| Last review |
9/1/2006 by Dr. Jeffrey J. Blessing, Associate Professor |
| Last update |
9/1/2006 by Dr. Jeffrey J. Blessing, Associate
Professor |
