Higher CSci DataBase Revision

Which of these refer to END USER requirements?

• The end users are the people who are going to be using the database

• The end users' requirements are the tasks they expect to be able to do using the database

• The end users work out processes and activities that the system has to perform

• The end users need information that the system has to contain to be able to carry out its function

Which of these refer to FUNCTIONAL requirements?

• The fucntional requirements refer to the people who are going to be using the database

• The functional requirements are the tasks the people expect to be able to do using the database

• The functional requirements work out processes and activities that the system has to perform

• The functional requirements need information that the system has to contain to be able to carry out its function

Searching and Sorting a database are examples of which requirement?

• End User

• Functional :-)

Setting up tables with PK, FK, other fields, queries (search and sort), aggregate functions, calcualtion, are examples of which requirement?

• End User :-)

• Functional

An ENTITY refers to a ... ?

• Table of a person or thing

• An instance about a specific person or thing

• An attribute about a relationship

• A relationship about cardinality

An ENTITY OOCURENCE refers to a ... ?

• Table of a person or thing

• An instance about a specific person or thing

• An attribute about a relationship

• A relationship about cardinality

An ATTRIBUTE refers to a ... ?

• Table of a table

• An instance about a specific person or thing

• Describes the charcteristics of an entity, i.e. fields

• Describes the charcteristics of an entity, i.e. records

A Primary KEY is ...

• an attribute which identifies one instance in a table

• an attribute which identifies one instance in a record

• part of a compound key which identifies one instance in a table

• Part of a compound key which identifies one instance in a record

A Foreign KEY is ...

• a PK from another table to link the two tables

• identified by an *

• Part of a compound key which identifies one instance in a table

• Part of a compound key which identifies one instance in a record

A COMPOUND KEY is ...

• a combination of primary keys from another table/s to identity one instance (row)

• each attirbute in the compound key is identified by an underline

• a combination pk and FK to identity one instance (row)

• Aye currumba. Wots going on?