Lecture 3

Question 1

Define database modelling.

Answer 1

A database model is a type of data model that determines the logical structure of a database (a blueprint).
The model essentially determines in which manner data can be stored, organized and manipulated.

Question 2

REA database modelling.

Answer 2

REA models consist of classes, associations and multiplicities.

Classes = are separately identifiable collections of things (objects) about which the organization wants to collect.
Associations = depict the relationship between two classes
Multiplicities = describe the minimum and maximum number of times instances of one class can be associated with instances in another class

REA model links different classes to each other for example linking purchases and cash receipts. The relationship shows how the business process flows.

Question 3

Define the building blocks of the REA model.

Answer 3

Classes = are separately identifiable collections of things (objects) about which the organization wants to collect.
Associations = depict the relationship between two classes
Multiplicities = describe the minimum and maximum number of times instances of one class can be associated with instances in another class

Question 4

Apply the REA model to sales and collection business processes.

Answer 4

Look at diagram

Question 5

Implement the REA model in MS access.

Answer 5

To implement an REA model into MS access you first have to create tables for each different section then link them through relationships making sure the primary keys are linked and adding primary keys to tables so tables can be linked.