Database ensign and development

Question 1

What is a functional requirement

Answer 1

The tasks that the database should be able to perform and the data it should be able to hold

Question 2

What is an end-user requirement

Answer 2

What the user needs to be able to do with the database

Question 3

What is the data protection act designed to do

Answer 3

To ensure that personal dat is held securely and not shared with third-parties

Question 4

Due to the data protection act what are the 4 things that businesses storing personal data must ensure

Answer 4

They have consent of the data subject to store personal information, the data is accurate and up to date, the data is used for the limited and specifically stated purposes and that the data kept safe and secure

Question 5

What is an entity

Answer 5

A place where information about a person thing or concept is kept

Question 6

What is an attribute

Answer 6

It describes the facts details and characteristics of an entity

Question 7

What is the primary key

Answer 7

The primary key uniquely identifies each record in a table

Question 8

What is the foreign key

Answer 8

The foreign key links one table to the other usually one fo the foreign keys is a primary key in one table

Question 9

What is a data dictionary

Answer 9

Includes the name and description of the attributes and entities in each table

Question 10

What is a text attribute

Answer 10

A combination of letters and numbers

Question 11

What is a number attribute

Answer 11

Whole numbers and decimal places

Question 12

What is a date attribute

Answer 12

Usually in the format DD/MM/YYYY

Question 13

What is a time attribute

Answer 13

Usually in the format 00:00 but can be in the format 00:00:00

Question 14

What is a Boolean attribute

Answer 14

True or false

Question 15

What does a validation do

Answer 15

Ensure data is allowable and sensible, makes it harder to make mistakes

Question 16

What does a range validation do

Answer 16

Ensures data is between a lower and upper limit

Question 17

What does a restricted choice validation do

Answer 17

Limits the uer to a list of options

Question 18

What does length check validation do

Answer 18

Restricts the number of characters that can be entered

Question 19

What does a presence check validation do

Answer 19

Ensures that the field is not elect blank

Question 20

What does referential integrity do

Answer 20

Ensures that the foreign key has a matching value in the corresponding primary key

Question 21

What does SQL stand for

Answer 21

Standard query language

Question 22

What is SQL used for

Answer 22

To interrogate the data held in the database

Question 23

What is SELECT FROM used for

Answer 23

To select data from the database

Question 24

What is WHERE used for

Answer 24

To ensure the only records that meet a specific condition are returned

Question 25

What is ORDER BY used for

Answer 25

To order the results in ascending or descending order

Question 26

What is INSERT INTO used for

Answer 26

To add a record to a table

Question 27

What is UPDATE used for

Answer 27

To update a record currently held in the database. The WHERE identifies the record

Question 28

What is the DELETE used for

Answer 28

To delete a recorder from the database. No WHERE means all content will be deleted from this table

Question 29

What is the EQUI-JOIN used for

Answer 29

To display results form two different tables requires primary key and foreign key to be linked

Question 30

What is the operator AND used for

Answer 30

Ensures that both conditions must be true

Question 31

What does the operator OR do

Answer 31

Ensures that either condition must be true

Question 32

What does the operator < mean

Answer 32

Less than

Question 33

What does the operator > mean

Answer 33

More than