Exam Practice 1 – Skaters

Getting Started
Task

You have been asked to create a database for ‘Paws for Thought’, a dog-walking company based in Bath. The company’s database records information about the dog-walkers, dogs and customers.

The company currently employs 5 dog-walkers. Each dog-walker can walk multiple dogs at a time.

There are 6 customers currently on their books, and each customer has a different number of dogs. The details of each dog is also recorded, including their size, which is measured in:

  • XS – Extra Small
  • S – Small
  • M – Medium
  • L – Large
  • XL – Extra Large

The database needs to record each dog-walker’s details, schedule of walks and identify the dog walker of the week. This is the dog-walker who has done the most walks in a week.

You need to:

  • Design a relational database structure that:
    • Matches the data provided
    • Avoids unnecessary duplication of data
    • Uses recognised naming conventions
    • Ensures data integrity
    •  

Import data from the file TEST1DATA.csv into your database structure.

You can download the database file from here:

SAM4DATA

Activity 1
Database Relationship Screenprint

1. Importing the data

2. CreatingTables

https://www.youtube.com/channel/UCIardxCHGL7TgGY8_j1bZLg/videos