INFO601 – Database Modelling and SQL
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
- IT7000
NZQA Level
Level 6
NZQA Credits
15
Delivery method
- Web-Supported
Learning hours
- 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.
