Category: Old Higher

Higher – Database Learning Points

We have now finished Databases. Here is what you should know.

From Scholar

  • How to describe the structure of a database in terms of tables, records and fields.

  • The advantages of using relational databases.

  • The purpose of primary, surrogate, foreign and compound keys.

  • The differences between one-to-one, one-to-many and many-to-many relationships.

  • The purpose and uses of tables, forms and reports.

  • What is meant by a relationship in a database.

  • How to perform complex operations, such as performing a query, creating a form, creating a report.

  • A calculated field is one which is created using a query which calculates a result from one or more existing fields.