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.
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 15 lessons covering database management. Each lesson includes a combination of open readings, YouTube videos, and hands-on learning activities.
Preparation[edit | edit source]
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.
Lessons[edit | edit source]
- Database Applications
- Advanced Queries
- Database Design
- Database Models
- E-R Diagrams
- Database Development Process
- Database Management Systems
- Database Functions
- Database Administration
See Also[edit | edit source]
Bibliography[edit | edit source]
- 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/