INFO503 – Database Principles
Module code
INFO503
Module title
Database Principles
Prescription
To enable students to apply database management systems concepts, data modelling techniques and structured query language in the design, implementation and operation of databases for organisations.
Programmes
- BI1601
- BI1607
- BI1804
- IT7000
NZQA Level
Level 5
NZQA Credits
15
Delivery method
- Web-Supported
Learning hours
- Total learning hours
- 150
Resources required
- Learning Outcomes
- 1. Explain database management systems concepts
2. Apply data modelling techniques to the design of database
3. Apply the use of Structured Query Language (SQL) - Content
- - Database management systems (DBMS) and database concepts
- Purpose of using a database management systems approach to organisational structures and missions
- Types of database management systems
- Data integrity, optimisation, security, backups
- Database schemas, instances and database states
- Conceptual, external and internal schema levels
- Apply data modelling techniques to the design of database
- Entities and attributes
- Examine relationships between logical data structures
- Primary keys and foreign keys
- Mandatory and optional
- Cardinality
- Relational databases and relational database schemas including
- Integrity and referential integrity
- Normalisation including resolving many-to-many and one-to-one relationships
- Transactions Set of logical structures that support the data model
- Data modelling concepts and techniques
- Create data models
- Apply the use of query languages with structured query language (SQL)
- Data definition
- Create database objects (tables and views)
- Drop database objects
- Data manipulation
- Insert data
- Update data
- Delete data
- Data integrity constraints
- Primary key
- NULL
- Foreign key
- Default
- Simple check constraints
- Querying and Reporting
- Select records from tables
- Apply select criteria
- Apply logical operators
- Simple joins
- Simple aggregate queries
- Format output - 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
- 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.
