Background Info
You are tasked to create a prototype database to keep track of movie related data and prepare all the
necessary queries, a form and a report. Most of the requirements have been completed, but you will
need to make a few informed decisions in preparing the tables, as noted below.
To help you test the database, an Excel file containing sample data is provided.
Task Descriptions
Your tasks in this assignment are as follows:
Task 1: Setting up Database (5 marks)
Note that anything with “???” means that you will need to assign an appropriate replacement.
1. Create a blank database called IMDB followed by your student ID number (e.g. IMDB12345678).
2. Create a table called ‘Director’ with the following fields/properties:
Attachments: