Skip to content

INFO706 – Database Front-End Applications

Print
Module code
INFO706
Module title
Database Front-End Applications
Prescription
To enable students to understand and apply front-end applications and their interfaces with supporting databases.
Programmes
  • BI1601
  • BI1804
NZQA Level
Level 7
NZQA Credits
15
Delivery method
  • Web-Supported
Learning hours
Total learning hours
150
Resources required
Learning Outcomes
1. Discuss, analyse and rationalise the use of front-end applications
2. Explore and understand different methods for data reporting, , retrieval and display
3. Design front-end applications
4. Implement front-end applications
Content
- Front-end applications
- The importance of data reporting
- Database architectures
- Effectiveness of separating database structures from local front-ends

- Methods for reporting, retrieval and display
- Common applications such as web-based, program-based, cloud-based, mobile-based or application-base
- Common functionality such as SQL, PL/SQL, TSQL or Programming elements
- Security, interlaced data, data integrity with interfaces
- Data filtering and data integrity
- Dashboards and concepts
- Visual presentation of data such as graphing, pillars or numeric

- Application front-end design
- User requirements for the design of a business solution
- Data entry, data display (visualization) and reporting
- Dashboard front-ends

- Application front-end implementation
- Implement front-ends using either of the following applications for web-based, program-based, cloud-based, mobile-based or application based
- Use of standard libraries, API’s, 3rd Party Tools and features for database components and connectivity
- Use of standard libraries, API’s, 3rd Party Tools and features for graphing
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
Computer lab with access to a server database
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.

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