DDD - Design

Question 1

What does GDPR stand for

Answer 1

General Data Protection Regulation

Question 2

What is GDPR

Answer 2

legislation which sets out rules for the protection of personal data

Question 3

Under GDPR individuals have the right to

Answer 3

be informed about how their personal data will be used

see any data held about them

have any inaccurate data held about them

have information about them delted once there is no longer a reason for holding it

Question 4

Under GDPR businesses must

Answer 4

Store all data securely

report any data breach within 72 hours

ensure that any data held about an individual is accurate

provide access to data held about an individual when requested by the individual

Question 5

what is an entity

Answer 5

an object which a database will store information

Question 6

what can entity be

Answer 6

a person, object or something abstract

Question 7

examples of entity

Answer 7

-pupil
-teacher
-car
-holiday booking

Question 8

what is an attribute

Answer 8

an item of information that relates to particular entity

Question 9

Examples of attributes

Answer 9

-forename
-dob
-model
-arrival

Question 10

What is a primary key

Answer 10

a field which uniquely identifies a record in a database

Question 11

what happens to database design primary keys are

Answer 11

underlined

Question 12

what is a foreign key

Answer 12

a primary key from one table which is used in a second table to link the tables together

Question 13

in database design, foreign keys are shown with

Answer 13

an asterisk

Question 14

attribute types

Answer 14

Text
Number
Date
Boolean

Question 15

What is the size of an attribute

Answer 15

a measure of how much space the field will take up when stored in main memory

Question 16

the size of a text attribute is

Answer 16

the number of characters which will be stored

Question 17

What happens if the attribute size is too small

Answer 17

it may result in data being lost

Question 18

what happens if the attribute size is too big

Answer 18

otherwise storage space is wasted unnecessarily

Question 19

what is a presence check

Answer 19

ensures that data is entered in a field

Question 20

What is restricted choice check

Answer 20

limits data entry to a set of acceptable values

Question 21

what is field length validation

Answer 21

limits the number of characters that can be stored in a field

Question 22

what is range check

Answer 22

ensures that data falls between two values

Question 23

ERD

Answer 23

entity relationship diagram

Question 24

What is an ERD

Answer 24

a graphic representation of entities in a database and their relationship to each other

Question 25

What should an Entity Relationship Diagram include

Answer 25

Entites
Attributes
Primary Keys
Foreign Keys
Cardinality
Description of relationship

Question 26

Types of cardinality

Answer 26

1:1
1:M
M:M

Question 27

example of a 1:1 relationship

Answer 27

1 husband has 1 spouse

Question 28

example of a 1:M reationship

Answer 28

! mother can have many children

Question 29

example of M:M relationship

Answer 29

many aunts can have many nieces and nephews

Question 30

what is a data dictionary

Answer 30

contains information about the tables and fields in a database

Question 31

Information in a data dictionary is known as

Answer 31

metadata

Question 32

What should metadata include

Answer 32

Entity name
Information about each attribute belonging to the entity

Question 33

what is a query

Answer 33

a request for data from a database table and tables

Question 33

What information should be stored about each attribute belonging to the entity

Answer 33

key
type
size
required
validation

Question 34

what should a query design include

Answer 34

fields to be displayed
tables that are used
query data
sort order of the query data