Database - How To Movies
 
1. Setting up and creating tables and fields 2. Formatting Fields. 3. Creating Primary Key and Relationships 4. Searching and Creating Reports 5. Editing Reports
 
Home DatabaseUsing Information Internet NAB/Coursework Revision Legal Responsibilities

Database Home

The candidate must demonstrate knowledge and understanding, practical skills and problem solving based on the following content statements:

Database Fundamentals:

  • Description of the benefits of an electronic database system in comparison with manual data storage, including searching and sorting, data retrieval, data storage and updating, data analysis and reporting.
  • Entities and Data Relationships
  • Description and exemplification of simple data entities, in terms of the following attributes: name, multi-valued or single valued, data type (text, integer, real, object, date, time).


Data Modelling Concepts

  • Design and creation of data tables, including consideration of: table names, fields (name and type), keys (primary and foreign), validation (presence, restricted choice).
  • Description and exemplification of the following field types: text, number, object, link, date, time, Boolean.
  • Identification of the limitations of flat file databases, and the advantages of linked tables (relational databases).


Normalisation

  • Explanation of normalisation.
  • Identification of entities with a single one-to-many relationship between them in a single source document.
  • Identification and removal of multi-valued fields in records.

Implementation

  • Implementation of database system based on data table.
  • Description and implementation of simple queries including: sorting (two fields, ascending/descending), searching (two fields).
  • Description and implementation of data input forms and simple reports.
  • Implementation of consistent, user-friendly user interface and screen design.


 

 



 

Intermediate II Home
Database | Using Information | Internet | NAB/Coursework| Revision
Log into Glow | School Website | Contact Us