18 Databases (3)

Resources | Revision Questions | Information Communication Technology ICT

Login to see all questions

Click on a question to view the answer

1.

Question 1

A school is collecting data on the number of students participating in different extracurricular activities. The data collected is shown below. Produce a report displaying this data clearly, including appropriate labels and a title. The report should be suitable for presentation to the school principal.

Data:

  • Drama Club: 45 students
  • Sports Club: 62 students
  • Debating Society: 38 students
  • Music Club: 55 students
2.

You are designing a database to store information about products. Each product has a 'Price' and a 'Discount Percentage'. You want to create a calculated field called 'Discounted Price' that automatically calculates the discounted price for each product. Write the formula for the calculated field 'Discounted Price'. Assume the discount percentage is entered as a decimal (e.g., 0.1 for 10%).

3.

A small business is currently using a flat file to store customer data (name, address, phone number). The business owner is considering switching to a relational database. Explain the benefits of using a relational database in this situation, and outline the steps involved in designing a relational database to store the same customer data. Use a table to illustrate the database design.