INFO706 – Database Front-End Applications

Print
Module code
INFO706
Module title
Database Front-End Applications
Prescription
To enable students to understand and apply various 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
Directed hours
48
Self directed hours
102
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 and 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
- Current or new technology in front-end applications
- Application front-end design
- User requirements for the design of a business solution
- Data entry, data display (visualization) and reporting
- Application front-end implementation
- Implement a variety of front-ends using applications for web-based, program-based, cloud-based, mobile-based or application-base
- Proficiency in application
- Standard libraries and features for database components
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.