Database Design & Development

Question 1

What are the advantages of using a database? (4)

Answer 1

• saves paper
• saves space
• amendments can be made easily
• the records can be sorted and searched easily

Question 3

What are the rules of GDPR?

Answer 3

• Accurate
• Held securely
• Held for declared purposes only
• Not held for longer than necessary

Question 4

What is a:

• field
• record
• file/table

Answer 4

• one item of data in a record eg. Name
• data on a single person or thing
• a set of data on a particular topic

Question 5

What are the four types of validation and how are they written in a database?

Answer 5

Field length = top row

Field range = >0 AND <10

Restricted choice = “_________” OR “________”

Presence check = yes/no

Question 6

What is a relational database?

What is the advantage of using it?

Why is a relationship table used?

Answer 6

Stores data in several linked tables

Less duplication of data

To link tables together

Question 7

How do you write the following queries?

• SELECT
• DELETE
• UPDATE
• INSERT

Answer 7

1. SELECT (record) FROM (table)
   WHERE (record) = (value)
2. DELETE FROM (table)
   WHERE (record) = (value)
3. UPDATE (table) SET (record) = (change)
   WHERE (record) = (original)
4. INSERT INTO (table) (record order)
   VALUES (new values)

Question 8

What testing should be done on a database? (3)

Answer 8

Check that the validations work properly

Queries should be tested and run to make sure the produce the correct results

Get a user to preform specific tasks to make sure the program is error free

Question 9

What is the evaluation for a database?

Answer 9

Fit for purpose - does it do what it is supposed to do and gives the right outputs

Accuracy of output l

Question 10

What are the two types of search and sort?

Answer 10

Simple and complex

Complex uses an AND

Question 11

When you are asked for the data structure what two things do you need to state?

Answer 11

Array of (data type, eg. Integer)