Creating Systems to Manage Information

Creating Systems to Manage Information

Lessons covering every topic
Quizzes for every lesson
Awards, experience points & levels
Analytics for student tracking
Course Dashboard
Subscribe

Content Areas

Learning Aim A

The purpose and structure of relational database management systems.

Learning Aim B

Standard methods & techniques to design relational database solutions.

Learning Aim C

Creating a relation database structure.

Learning Aim D

Evaluating a database development project.

Modules

Expand All
Relational Database Management Systems
Expand
The types of relational database management systems (RDBMS), their characteristics & models.
2 Lessons | 2 Quizzes Sample Module
Relational Database Terminology
Relational Database Terminology
Database Relationships
Database Relationships
Manipulating Data Structures
Expand
The use of RDBMS software tools and structured query language (SQL) for defining, modifying and removing data structures and data.
1 Lesson | 1 Quiz
Manipulating Relational Databases
Manipulating Relational Databases
Normalisation
Expand
The role of normalisation to develop efficient data structures.
2 Lessons | 2 Quizzes
The Role of Normalisation
The Role of Normalisation
The Normalisation Process
The Normalisation Process
Relational Database Design
Expand
The selection of RDBMS and SQL software, tools, techniques and processes.
2 Lessons | 2 Quizzes
Relational Database Design 1
Relational Database Design 1
Relational Database Design 2
Relational Database Design 2
Design Documentation
Expand
The features and characteristics of relational database design techniques and their application to solve problems.
6 Lessons | 6 Quizzes
Requirements & Considerations
Requirements & Considerations
Data Structure Designs 1
Data Structure Designs 1
Data Structure Designs 2
Data Structure Designs 2
User Interface Design
User Interface Design
Extracting & Presenting Data
Extracting & Presenting Data
Design & Use of Test Plans
Design & Use of Test Plans
Producing Database Tables
Expand
Select and configure appropriate RDBMS and SQL tools to produce database tables to meet client’s requirements.
4 Lessons | 4 Quizzes
Creating Tables 1
Creating Tables 1
Creating Tables 2
Creating Tables 2
Applying Data Validation Rules 1
Applying Data Validation Rules 1
Applying Data Validation Rules 2
Applying Data Validation Rules 2
Producing Database Outputs
Expand
Select and configure appropriate RDBMS and SQL tools to produce database outputs to meet client’s requirements.
2 Lessons | 2 Quizzes
Select, Parameter & Calculated Queries
Select, Parameter & Calculated Queries
Crosstab Queries & Reports
Crosstab Queries & Reports
Producing Database User Interfaces
Expand
Select and configure appropriate RDBMS and SQL tools to produce a database interface to meet client’s requirements.
2 Lessons | 2 Quizzes
User Interfaces 1
User Interfaces 1
User Interfaces 2
User Interfaces 2
Testing & Evaluation
Expand
Testing, refining & evaluating the database solution to ensure that the database solution meets requirements.
3 Lessons | 3 Quizzes
Testing & Refining the Database
Testing & Refining the Database
Evaluating the Design & Testing
Evaluating the Design & Testing
Evaluating the Database
Evaluating the Database