I have been employed as an ICT consultant for DVD rentals, a business that rents DVDs via the Internet. I will assist DVD rentals by creating a database solution for storing DVD rental and customer details electronically.

Categories Table:

This table will be used to store all the available categories for the DVDs.

Design of Form Templates:

Customer Details Form Template:

• Using all the fields from the Customer Details table.
• Columnar layout.
• Command buttons.

• Customized style.

This is the template for the Customer Details form; I created this template using Microsoft Word 2007. Within each box I have specified the format of the wording; text size, font etc. Everything needed to ensure that the form is created accurately.

Customer Records Form:

DVD Stock Form Template:

This is the template for the DVD Stock form; I created this template using Microsoft Word 2007. This form is similar to the others so that a house style is maintained, all the formatting, except for layout and titles, are the same.

DVD Stock Form:

• Using all the fields from the DVD Stock table.
• Columnar layout.
• Command buttons.
• Customized style.

DVD Rental Template:

This is the template for the DVD Rental form; I created this template using Microsoft Word 2007.

DVD Rental Form:

Primary Keys:

In relational database design, a unique key or primary key is a candidate key to uniquely identify each row in a table. A unique key or primary key comprises a single column or set of columns. No two distinct rows in a table can have the same value (or combination of values) in those columns. Depending on its design, a table may have arbitrarily many unique keys but at most one primary key.

Relationships:

Because the database is a relational database the tables will be linked together. The Customer ID in the Customer details table will be linked to customer ID in the DVD rentals table. The reason is because you cannot enter a customer ID in the DVD rentals table, which doesn’t exist in the Customer details table. Because of this, the tables need to be related. The screenshot below defines the primary keys of the tables and how they are related with each other:

• The fields in bold are the primary keys of the table.
• The lines show the relationships between the fields.

AO2 - Construct the database according to the design:

Database:

Customer Details Database

Custom forms used to enter appropriate data in each table:

Relationships:

Database matches the design work undertaken:

Customer Details Database:

Categories Database:

AO3 - Interrogate the database:

Sort on one table:

One query using simple criteria:

Multiple queries on linked tables:

Sort the second query on at least two fields:

Two categories of DVD query:

DVD Rental Query

DVDs Rented Query

AO4 - Create Report:

Create at least one report for each query/sort created in task 3.

AO5 - Create a user interface:

For this task I am going to create an easy-to-use user interface that will give access to the main areas of the database.

Functionality of User Interface:

Test:

AO6 - Testing of the database:

Tables:

User Interface:

Recreating the hyperlinks for those buttons:

Queries:

Forms:

Reports: