Skip to content

INFO503 – Database Principles

Module code
Module title
Database Principles
To enable students to apply database management systems concepts, data modelling techniques and structured query language in the design, implementation and operation of databases for organisations.
  • BI1601
  • BI1607
  • BI1804
  • IT7000
NZQA Level
Level 5
NZQA Credits
Delivery method
  • Web-Supported
Learning hours
Total learning hours
Resources required
Learning Outcomes
1. Explain database management systems concepts
2. Apply data modelling techniques to the design of database
3. Apply the use of Structured Query Language (SQL)
- Database management systems (DBMS) and database concepts
- Purpose of using a database management systems approach to organisational structures and missions
- Types of database management systems
- Data integrity, optimisation, security, backups
- Database schemas, instances and database states
- Conceptual, external and internal schema levels

- Apply data modelling techniques to the design of database
- Entities and attributes
- Examine relationships between logical data structures
- Primary keys and foreign keys
- Mandatory and optional
- Cardinality

- Relational databases and relational database schemas including
- Integrity and referential integrity
- Normalisation including resolving many-to-many and one-to-one relationships

- Transactions Set of logical structures that support the data model
- Data modelling concepts and techniques
- Create data models

- Apply the use of query languages with structured query language (SQL)

- Data definition
- Create database objects (tables and views)
- Drop database objects

- Data manipulation
- Insert data
- Update data
- Delete data

- Data integrity constraints
- Primary key
- Foreign key
- Default
- Simple check constraints

- Querying and Reporting
- Select records from tables
- Apply select criteria
- Apply logical operators
- Simple joins
- Simple aggregate queries
- Format output
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