INFO601 – Database Modelling and SQL

Print
Module code
INFO601
Module title
Database Modelling and SQL
Prescription
To enable students to apply an indepth understanding of database modelling, database design and SQL concepts.
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. Apply advance database design and modelling techniques.
2. Apply advance Structured Query Language (SQL) techniques.
3. Apply database programming techniques.
Content
- Database modelling and database design concepts:
- Database design techniques
- Producing data models
- Applying data modelling to a given scenario
- Boolean Algebra
- Data dictionaries
-Structured Query Language (SQL)
- Data definition languages (DDL), data manipulation language (DML)
- Implement integrity constraints including
- Check constraints
- Triggers
- Queries
- Natural Joins
- Inner Joins
- Outer Joins
- Nested Queries
- Functions
- Apply advanced techniques in SQL with programming techniques
- Explaining procedures, functions and packages for manageability and efficiency
- PL/SQL or TSQL
- Programmable logic statements in SQL statements
- Implement procedures,functions or packages
Teaching and Learning Strategy
Teaching methods will involve theoretical and practical classes which may include but not limited to lectures, tutorials, computer laboratory work, group activities, face-to-face, online, and assignments.
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.