• Health Home

• Programs
• Courses
  • Certificate Program in Environmental and Occupational Health
  • Current Concepts in Dentistry
  • Health and Helping Professionals
  • General Health Courses
• Registration / Admission
  • Environmental and Occupational Health
  • Current Concepts in Dentistry
  • Canadian Falls Prevention
  • Wound Management for Health Professionals
• FAQ
  • Helping Professionals and General Health courses
  • Environmental & Occupational Health
• Contact

•  

COURSE INFORMATION

Database Concepts

CBIS Core Course, by Distance

Program Options: CBIS TRU

This course is designed to help you become a knowledgeable end user of database management systems and to help you understand the needs and roles of users, database designers, managers and administrators. Database Concepts, a key component of the CBIS program, provides you with an understanding of how databases fit into the information system of an organization.

You will cover topics such as the major components and functions of a database, how information is modelled, stored and manipulated in databases, and the implications of databases on operations, control and planning for the organization. You will also gain hands-on experience creating and maintaining a relational database using Microsoft Access or LibreOffice, available from www.LibreOffice.org.

Prerequisite: Computing Concepts or equivalent experience.

Course requires Microsoft Office Professional 2002/2003 or 2007/2010 (including Access) or LibreOffice. LibreOffice is an open source application that can be downloaded from the Internet at no cost. For further information about LibreOffice, please visit www.LibreOffice.org.

Objective

Upon completion of this course, students will be able to:

• Understand the relational database management model
• Understand the importance of database design
• Understand design terminology
• Implement the analysis and design process
• Model tables, fields and relationships data
• Address management aspects of database planning and implementation
• Implement a database in Microsoft Access or LibreOffice
• Understand the use of SQL for simple queries

Format

By Distance

CBIS courses are 13 weeks in duration. Students login to the course and communicate with the instructor and fellow students via the course management system Moodle. For further information about Moodle, visit the Moodle Startup Kit at http://distance.uvic.ca/onlinehelp/tutorials/moodle/.

Requisites

• Required Equipment/Software

  • Personal Computer (PC)
  • Windows 2000 or higher
  • Microsoft Office Professional 2002/2003 or 2007/2010 (Word, Excel PowerPoint and Access), or alternatively www.LibreOffice.org
  • Internet Explorer 6 or higher
  • Internet access
  • Email account

  Textbook

  Database Design for Mere Mortals (2nd ed.), by Hernandez, plus Web-based readings.
  Please purchase text from UVic Bookstore (www.uvicbookstore.ca).

---

Go Back

•  

Messages