Database Design & Development

Question 1

What is included in the Analysis phase?

Answer 1

The end-user requirements and the funcitonal requirements.

Question 2

Functional requirements are…

Answer 2

What the system/database should be able to do.

Question 3

End-user requirements are…

Answer 3

What the USER wants the database to do.

Question 4

What are the 5 data types?

Answer 4

Text, Number, Date, Time, Boolean

Question 5

What are 3 Implications of the General Data Protection Regulation?

Answer 5

Used for the declared purpose only.
Accurate.
Held Securely.

Question 6

When is an Equi-Join needed?

Answer 6

When creating an SQL query that will display results from two or more tables.

Question 7

What is Referential Integrity?

Answer 7

Referential integrity is used to ensure that a foreign key used in one table exists as a primary key in its own table.

Question 8

How to check if your Database is fit for purpose?

Answer 8

Does it show the requested info?