May 01, 2024  
2015-2016 Undergraduate Academic Catalog 
    
Catalog Navigation
  Catalog Home
  Academic Calendar
  University Overview
  Enrollment Management Department
  Academic Regulations and Policies
  Student Accounts, Fees and Financial Aid
  Academic Departments, Undergraduate Degree Programs, Minors and Certificates
  Degree Programs, Minors and Certificates
  Reserve Officer Training Corps (ROTC)
  Course Descriptions
  Board of Regents, Academic Administration, Faculty and Advisory Committees
  Campus Map
  Student Resources
  My Portfolio
HELP
2015-2016 Undergraduate Academic Catalog [ARCHIVED CATALOG]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)

MS 483 - Database Management Systems

3 lecture hours 0 lab hours 3 credits
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 database design, schemas and normalization. Relational algebra is used as a basis for the understanding of Structured Query Language (SQL). The use of relational databases as persistence layers for object-oriented languages is described through the presentation of database drivers and object-relational mapping mechanisms. (prereq: MS 2810  or MS 382 )
Course Learning Outcomes
Upon successful completion of this course, the student will be able to:
  • 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 IDEF1X 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, 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 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
  • Cover advanced topics such as data replication, message orientated middleware, object-oriented databases, data mining, etc. and how they pertain to data collection
  • Verify the objectives against the Course Grade Book
Prerequisites by Topic
  • Some familiarity with computing
  • Knowledge of a programming language
Course Topics
  • None
Coordinator
Jeffrey Blessing


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)