D2

Database Evaluation

The intentions I had for my database were to store records in different tables for a film club. I think I have achieved my intentions as my database is capable of doing this.

At the beginning of this unit we had to take the data from two notebook documents, I had to import it into the database tables I had created already. I imported the correct data into my tables. After I created forms this allows the users to put their details and information into the database.

My forms

Member’s form                                                                                                                                                                               this allows people, who want to become members, register their information and submit it into the database. I put a submit button in the form to allow them to submit their information and then the query I created runs to append the data into the database.

Payments form                                                                                                                                                                                                                  the payments form allows the user to enter their payment information into the database, the same as the members form the query is ran when the data is submitted.

Suggested Improvements:

Two improvements that would make my database easier to use for the user, such as a switchboard this would allow users to easily go through the forms, and a payments form that would allow users to enter payments into the database. I added both of these it would allow users to write a review on one of the films that they had watched.