evaluating a video shop

The database I created did fulfill all the requirements set by the analysis. The three aspects were created

1) The first one was to create a database of videos so we know what video’s we have and so we can carry out searches such has any overdue video’s we may have so we can inform the members who have them. The database I created did this well. I was able to carry out searches including searching for overdue which enabled me to know the overdue customers are so we can send letters to them. I could also search for other criteria’s such as any particular actor or genre to help with any customer enquires for example. This would help the business and help achieve anything they may need quicker.

2) The second aspect was to create a database of members so we know which customer as which videos. I created this correctly. The database enabled me to know which customer had which videos so I would now what videos are available or not. This database will also help to run the ...