Skip to content

INFO604 – Database Systems

Module code
Module title
Database Systems
To enable students to understand and discuss database systems, concepts, modelling, design and administration, and to apply theoretical and practical administrative tasks in a database administrator's role.
  • BI1601
  • BI1804
NZQA Level
Level 6
NZQA Credits
Delivery method
  • Web-Supported
Learning hours
Total learning hours
Resources required
Learning Outcomes
1. Analyse database management techniques and database concepts

2. Apply the fundamentals of basic database administration tasks

3. Create and administer an operational database application
- Database management systems and database concepts
- Hierarchical, Network, Relational, Object-based, Star-Schema, Cube
- Roles in database systems, such as DA, DBA, DB Architect, or DB Analysts
- Concurrency control, data integrity, data security, locking and backup
- Current or emerging database systems such as Dedicated, Client/Server, Distributed,
Data Warehouse, or Data Lakes

- Fundamental database administration tasks
- Installation and configuration
- Creating, developing and managing storage structures
- Administering a database
- User accounts, security, roles, and profiles
- Backup and recovery

- Administering an operational database application
- Creating designs to support data entry and data display
- Creating logical and physical storage structures
- Implementing the database with an application
- Producing user documentation to support the operation of an application
Teaching and Learning Strategy
Teaching methods will involve theoretical and practical classes which may include but not limited to lectures, class discussions, tutorials, case studies, simulations, computer laboratory work, group activities, face-to-face and online activities.
Assessment Criteria
In order to receive a passing grade, students must achieve a minimum 40% average over all supervised tests and achieve 50% overall for the module.

Learning and Teaching Resource
Wintec Learning Management Systems, Computer Laboratory
Required Textbooks
An extended reading list will be supplied by the tutor at commencement of the module. This will be updated annually

Wintec is part of Te Pūkenga - New Zealand Institute of Skills and Technology Learn More

Learn with purpose

Explore Te Pūkenga

Te Kāwanatanga o Aotearoa - New Zealand Government

Te Kāwanatanga o Aotearoa - New Zealand Government

Copyright © 2022 Wintec