INFO604 – Database Systems
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
- 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
