Database Design

Question 1

GDPR Implications

Answer 1

1. Processed Lawfully
2. Used for intended purpose
3. Limited to data needed
4. Accurate
5. Not kept longer than necessary
6. Held securely

Question 2

GDPR Stands for…

Answer 2

General Data Protection Regulation

Question 3

What does a data dicionary describe

Answer 3

The structure of a database

Question 4

Data dictionary shows

Answer 4

Entity Names,
Attribute Names,
PK, FK
Attribute sizes
Validation

Question 5

What is boolean

Answer 5

Yes/No

Question 6

Attribute types

Answer 6

Number
Text
Boolean
Date
Time

Question 7

Validation types

Answer 7

Prescence check
Restricted Choice
Field Length
Range

Question 8

What is a Entity Relationship Diagram

Answer 8

It is an illustration that shows the relationship that exists between entities

Question 9

SQL Stands for

Answer 9

Structured Query Language

Question 10

SQL insert into
code

Answer 10

INSERT INTO (table_name)
VALUES (value1, value2, …)

Question 11

SQL Update
Code

Answer 11

UPDATE table_name
SET column1 = value1, column2 =value2
WHERE (condition)

Question 12

SQL DELETE
Code

Answer 12

DELETE FROM table_name
WHERE condition

Question 13

SQL SELECT
CODE

Answer 13

SELECT
FROM
WHERE
ORDER BY

Question 14

SQL EQUI-JOIN

Answer 14

SELECT
FROM (Both tables)
WHERE condition AND
table1.column1 = table2.column1
ORDER BY

Question 15

What does prescence check mean

Answer 15

Cannot leave space blank

Question 16

What does restricted choice mean

Answer 16

Can only choose from given list

Question 17

What does field length mean

Answer 17

Restricts number of characters typed

Question 18

What does range mean

Answer 18

Makes sure the data is within a certain limit

Question 19

What is a foreign key

Answer 19

A foreign key links 2 tables together

Question 20

What is a PK

Answer 20

Primary keys are used to uniquely identify a set of information

Question 21

What is referential integrity

Answer 21

The relationship between 2 or more tables
It ensures data will not be duplicated

Question 22

What is the end user requirement

Answer 22

The tasks that the end users need to be carried out

Question 23

What is the functional requirements

Answer 23

Features that developers must implement to enable users to accomplish their task