Homework tasks

1 Homework

Homework 1 - Terminology Quiz.

Click on following Link to take a quiz on Database Terminology, you should aim to get at least 50%. Then take a snippet of the score and uploaded it onto BourneToLearn.

Homework 2 - Research Task.

Using the following link research Databases and answer the following questions.

  • What is a flat file database?
  • What is a relational database?
  • What is a primary key and how is it used?
  • What is a foreign key and how does it relate to the primary key?

Your answers should be full sentences using connectives. Try and write a short paragraph for each by discussing the main points, advantages and disadvantages etc. You need to write a minimum of 200 words in total covering all 4 questions.

Homework 3 - Referential Integrity Research

In your last lesson, you have learned about how we can link two tables together and should know that every foreign key value has a matching value in the corresponding primary key.

Your Task: (200 words minimum)

  1. Research and explain what referential integrity is?
  2. Why do we need to use referential integrity?
  3. Find several examples of databases using referential integrity (Diagrams can be used to support).

Author: A.Stout & S.Fone