INFO604 – Database Systems

Print
Module code
INFO604
Module title
Database Systems
Prescription
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.
Programmes
  • BI1601
  • BI1804
NZQA Level
Level 6
NZQA Credits
15
Delivery method
  • Web-Supported
Learning hours
Directed hours
64
Self directed hours
86
Total learning hours
150
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
Content
- 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