May 13, 2024  
2017-2018 Course Catalog 
    
Catalog Navigation
  Catalog Home
  Introduction to Century College
  Mission, Vision, Values

  College Calendar

  Course Descriptions and Outlines
  Programs (Century Academic Pathway)
  Programs (Department)
  Programs (A-Z)

  Academic Policies and Program Requirements
  Admissions and Registration
  Application for Admission
  Student Services and Resources
  Student Handbook
  Transfer

  Continuing Education and Customized Training
  College Administration and Faculty
  Maps and Directions
  Archived Catalogs
  My Portfolio
HELP
2017-2018 Course Catalog [ARCHIVED CATALOG]

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

CSCI 2050 - Database Management Systems

Credits: 4
Hours/Week: Lecture 4Lab None
Course Description: The course covers the concepts and techniques for designing, creating, and managing databases.  The relational model is emphasized, along with its associated design techniques, such as E-R Model, normalization, and decomposition.  Structured Query Language (SQL) is covered in depth and used to implement, query, and modify databases.  Topics include query optimization, transaction management, backup, security, and privacy, as well as additional architectures such as distributed, object-oriented, and client/server.  Additional architectures such as distributed, object-oriented database, and client/server are explained. Students create front-end database applications that use modern interface design, using an industry-current database such as MySQL.  An industry current database such as MySQL will be used in the course.
MnTC Goals
None

Prerequisite(s): Assessment score placement into MATH 1061   or above, or completion of MATH 0070   with a grade of C or higher, and CSCI 1082  or concurrently enrolled.
Corequisite(s): None
Recommendation: None

Major Content
  1. The Relational Database Model
  2. SQL Language
  3. Relational Database Design
  4. The E-R Model
  5. Physical Storage and File Structure
  6. Query Processing
  7. Data Warehousing and Mining
  8. Database-System Architectures
  9. Object-Based Databases
  10. Query Optimization
  11. Recovery and Backup
  12. Transaction Management & concurrency control

Learning Outcomes
At the end of this course students will be able to:

  1. create conceptual, logical, and physical entity relationship diagrams based on requirements.
  2. apply the appropriate design process and techniques (such as normalization) to create an optimal database.
  3. Use SQL to create, modify, and query relational databases.
  4. apply optimizations to queries.
  5. demonstrate principles for effective transaction management, concurrency control, and recovery.
  6. apply optimizations to queries.
  7. describe query processing process.
  8. compare different database architectures including relational, distributed and object-oriented.


Courses and Registration


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