(AS) 9. Databases

Syllabus Content

Check out the Notes section

9.1 Create a database

  • Assign a data type and an appropriate field size to a field (including: text, alphanumeric, numeric (integer, decimal), date/time, Boolean)
  • Describe the three relationships: one-to-one, one-to-many and many-to-many
  • create and use relationships (including: one-to-one and one-to-many)
  • create and interpret an entity relationship diagram
  • evaluate the difference between a flat file and a relational database and why one might be preferred in certain situations
  • create a relational database
  • analyse the function of key fields (including: primary key, compound key, foreign key)
  • set keys (including: primary key, compound key, foreign key)
  • define and use referential integrity and explain its importance
  • validate and verify data entry
    • use validation rules (see 1.5)
    • test validation applied to a database
    • verify data entry (see 1.5)
  • Perform searches
    • simple query on single criterion
    • complex queries using multiple criteria
    • queries using static parameters
    • queries using dynamic parameters
    • nested queries
    • summarise data (including: cross-tab query/pivot table)
    • Using text, numeric, date, time, wildcard, Boolean operators (AND, OR, NOT), ., ,, =, .=, ,=
  • Use arithmetic operations, numeric and logical functions to perform calculations within a database (including calculated controls and calculated fields.
  • sort data
    • ascending, descending, grouped
  • design, create and evaluate an appropriate data entry form (including: appropriate font styles and sizes, spacing between fields, character spacing of individual fields, use of white space, radio buttons, drop down menus, highlighting key fields)
  • design, create and evaluate database reports including grouped reports
  • design, create and evaluate a switchboard/menu within a database
  • import data (including: .csv, .txt, .rtf)
  • export data (including: table, query, report, export as .csv, .txt, .rtf)

9.2 Normalisation to third normal form (3NF)

  • describe the characteristics of data in unnormalised form (0NF), first normal form (1NF), second normal form (2NF) and third normal form (3NF)
  • discuss the advantages and disadvantages of normalisation
  • normalise a database to 3NF

9.3 Data dictionary

  • describe the components of a data dictionary
  • select appropriate data types for a given set of data and a given situation
  • identify different data types (including: text, alphanumeric, numeric, (integer, real, percentage, currency), date/time, Boolean/logical (yes/no, true/false))

9.4 Query selection

  • evaluate the use of static and dynamic parameters in a query (see 9.1)
  • analyse when static and dynamic parameters should be used in queries (see 9.1)
  • analyse when simple, complex, nested and summary queries (including cross-tab queries/pivot tables) should be used (see 9.1)

9.5 File and data management

  • evaluate different file types and their use
  • explain what is meant by proprietary and open-source file formats, and why open-source file formats are needed
  • explain why generic file formats are needed
  • explain the use of indexed sequential access
  • explain the use of direct file access
  • explain the use of a hierarchical database management system
  • describe the features of a management information system (MIS)
  • explain how a MIS can be used by organisation.

Notes For Chapter 9