Create a Database Structure (Cambridge (CIE) IGCSE ICT): Exam Questions

The manager of a medical centre keeps the doctor’s stock records in a database. The stock for any item is not allowed to fall below 15 items and the manager keeps a maximum of 100 items in stock.

The table shows examples of the stock.

As data is entered it needs to be verified and validated.

Name the most appropriate field from the table that could be used as a primary key in the database.

A library system has two tables; one for borrowers and one for books. Extracts from these tables are shown.

Borrowers table

Books table

For the books table, name the most appropriate field that could be used as a primary key

The librarian has created a relationship between the books table and the borrowers table.

For the books table, name the most appropriate foreign key field that would be used to create the relationship.

Two types of database are relational and flat file.

Give, using an example, one reason why flat file databases are used in certain applications rather than relational databases.

A student is creating a spreadsheet of airports for a project.

The formula in G2 is:

=VLOOKUP(F2,A2:B9,2,0)

The completed file could have been created using a database.

Describe two reasons why databases are used in certain applications rather than spreadsheets.

A systems analyst has created a new computer system to keep records in a medical centre. She has created a relational database to store the medical records of patients.

The database uses primary and foreign keys.

Describe what is meant by a relational database.

Explain the difference between a primary key and a foreign key.

A dentist works at the medical centre. The dentist stores the medical records of his patients

Describe four other uses of the database software that the dentist can use to help him in his work.

Petr has set up a database for a science project on planets in the solar system. Part of the database is shown.

When Petr was designing his database, he had to set the data types for each field.

Complete the design table below by filling in the data types for each named field. Use the most appropriate data type.

Each data type must be different. For any numeric field, specify the type of number.

Write down the names of the planets that are not gas giants but have at least one moon and were first observed after 1800.

Two types of database are relational and flat file.

Compare and contrast relational databases and flat file databases.

Your answer must include similarities and differences.

Petr has set up a database for a science project on planets in the solar system. Part of the database is shown.

Operators such as AND, OR, NOT, LIKE, >, >=, <, <=, =, <> can be used to search Petr’s planet database. The search criteria for all the gas giant planets with more than 20 moons would look like this:

Type_of_planet = "Gas Giant" AND Number_of_moons > 20

Write down the search criteria that will produce a list of planets that are not gas giants but have at least one moon and were first observed after 1800.