INFO601 – Database Modelling and SQL
Database Modelling and SQL
To enable students to apply an indepth understanding of database modelling, database design and SQL concepts.
- Directed hours
- Self directed hours
- Total learning hours
- Learning Outcomes
- 1. Apply advance database design and modelling techniques.
2. Apply advance Structured Query Language (SQL) techniques.
3. Apply database programming techniques.
- - 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
- Natural Joins
- Inner Joins
- Outer Joins
- Nested Queries
- 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.