Database Design & Development

Question 1

Describe the implications for individuals and businesses of the UK General Data Protection Regulation (UK GDPR).

Answer 1

The implications of the GDPR are that data must be:

Processed lawfully, fairly, and in a transparent manner in relation to individuals,
Must be used for the declared purpose only,
Limited to the data needed for the declared purpose,
Accurate,
Not kept for longer than necessary,
Held securely.

Question 2

What are ‘end-users’, and what are ‘end-user’ requirements?

Answer 2

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

Their requirements are the tasks they expect to be able to do using the database.

Question 3

What is an entity-relationship diagram?

Answer 3

An entity-relationship diagram is a graphical representation of the entities in a system. It is used to illustrate the relationship that exists between two or more entities.

Question 4

How can an entities relationship be drawn in an entity-relationship diagram? (one-to-many)

Answer 4

“Crow’s Feet”, two lines drawn out in a triangular shape from the relationship line.