Database Management

A database is an organized collection of data, generally stored and accessed electronically from a computer system. The database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. Database Management System provides the capability to govern a database function. The DBMS software additionally encompasses the core facilities provided to administer the database.[1]

Database management is covered in three parts: database applications, database design, and database management systems. Database applications use tables, queries, forms, and reports to manage data. Database design is based on data models, E-R diagrams, and normalization concepts. Database management systems use database functions and SQL to perform database administration tasks.

This course comprises ?? lessons covering database management. Each lesson includes a combination of open readings, YouTube videos, and hands-on learning activities.

PreparationEdit

This is a second-semester, college-level course. Learners should already be familiar with introductory computer concepts and Information Systems concepts, and have advanced or proficient-level computer skills. Familiarity with Database Software is also helpful.

LessonsEdit

  1. Introduction
  2. Database Applications
    • Tables
    • Forms
    • Reports
    • Queries
    • Advanced Queries
    • Reports
  3. Database Design
    • Database Models
    • E-R Diagrams
    • Normalization
    • Database Development Process
  4. Database Management Systems
    • Database Functions
    • SQL
    • NoSQL
    • Database Administration
  5. Projects
    • ODBC

See AlsoEdit

BibliographyEdit

  • McFadyen, Ron. (2016). Relational Databases and Microsoft Access, 3rd Edition. Retrieved from http://www.acs.uwinnipeg.ca/rmcfadyen/CreativeCommons/Relational%20Databases%20and%20Microsoft%20Access%20V3.0.pdf
  • Pratt, Philip J., and Adamski, Joseph J. (2012). Concepts of Database Management, 7th Edition. Cengage. ISBN 9781111825911
  • Watt, Adrienne, and Eng, Nelson. Database Design, 2nd Edition. BCCampus. Retrieved from https://opentextbc.ca/dbdesign01/

ReferencesEdit