INFO705 – Database Architecture Project
Module code
INFO705
Module title
Database Architecture Project
Prescription
To enable the student to further develop their knowledge of Database Architecture by analysing, designing and implementing a database solution. Alternative and new approaches to database systems will be explored and evaluated by using practical-based solutions. This module is the Database Architecture Capstone Project.
Programmes
- BI1601
NZQA Level
Level 7
NZQA Credits
15
Delivery method
- Web-Supported
Learning hours
- Total learning hours
- 150
Resources required
- Learning Outcomes
- 1. Analyse client operations to design and develop a database solution
2. Perform database architectural tasks to support the database solution
3. Provide training and supporting documentation
4. Troubleshoot and resolve user problemms - Content
- - Database architecture role in an organisation
- Analysis of client operations and develop a database solution
- Database structural requirements
- Client operations, applications, activities and current systems
- Architectural plans such as database architecture, data models and data distribution
- Database solutions development
- Physical structures and functional capabilities
- Security, back-up and recovery specifications
- Logical structures (database models) and supporting application functions
- Front-end application interfaces
- Database architectural tasks
- Installing and configuring database systems
- Installing client software
- Creating physical structures with scripts
- Creating users, schemas and privileges to implement security
- Implementing front-end applications or interfaces
- Monitoring and optimising performance
- Troubleshooting database application problems
- Implementing backup and recovery plans
- Training, supporting, documentation and resolving user problems
- Current or emerging developments in databases can include but not limited to data
warehousing, data mining, big data and data lakes, or time series databases - 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
- Dedicated computer laboratory
Database server software and supporting client software
Computer network and internet connection
Wintec Learning Management Systems - Required Textbooks
- An extended reading list will be supplied by the tutor at commencement of the module. This will be updated annually.