Database System for SmallLocal Dvdvideo Shop.

Masters
Assignment
Technology
Pages 20 (5020 words)
Download 0
Marvin Bird owns and runs a DVD and video rental shop called Box Set Rentals, in Sheffield, United Kingdom. His business specializes in television series, spin-offs and US series that are not aired on UK television. The aims of Box Set Rentals are to offer a unique group of DVDs and videos at a competitive price with competitive terms.

Introduction

Multiple sets can be ordered and rentals can be renewed online.
When customers make their first rental, they will be assigned a customer reference number which will identify them, and the details to be linked to this number will be the address and contact details. Failure to return the rental will result in customers being levied a full week's rental at 9.99 every 14 days until the rental is returned.
Marvin would like the system to keep a store of customer details which can be accessed at the push of a button, he wants to be able to retrieve rental and returns information, as well as have a user-friendly interface to log in transactions.
He also wants the system to perform financial calculations, which can be printed and reported on. Most of all, Marvin would like the system to be compatible with his current hardware and software requirements, and the system should also be able to interact with existing spreadsheets. In a nutshell, Marvin is not looking to change his computer or buy new software to meet this requirement.
When a customer seeks to rent out a title, Marvin will access the rentals form of the database which will allow him to enter the customer's membership number, and record the details and cost of the titles required. ...
Download paper
Not exactly what you need?

Related papers

Object Database Management System
There are two most important factors that lead users to implement object database technology. Firstly, relational databases turn out to be cumbersome to use with composite data. Secondly, data is usually operated by application software written using object-oriented programming languages such as C+, Java, Delphi and C#, and the code required translating between this demonstration of the data and…
Database Management System Assignment
This thesis provides a benchmark to assess the performance of storing binary large objects in a relational database management system.A benchmark framework that reduces development and integration costs of benchmarking the database performance of a specific application is included.A randomly generated test script is utilized to provide variation among test cases and consistency between different…
Database Technology
Object oriented databases have now become very popular as they provide a greater degree of flexibility in data storage and also provide a resource efficient storage mechanism. The data storage in the object oriented databases is in the form of objects instead of storing as rows and columns.…
Object Relational Database
In ORDB, reusability is achieved by using the techniques of inheritance of types and polymorphism. Every record has unique identity within the object table. Here every record is termed to be active, persistent objects encapsulating both data and methods. The only way to access any data, is through the object methods.…
Database Design
Furthermore, the information model comprises of the customer and the details of the meter including the intricate technical details as well as the maintenance schedules apart from the measurements that quantify for billing. This is necessary for the effective management of the information system and conduct regular checks on the meters in order to prevent errors in the readings leading to unwanted…
Database System for SmallLocal Dvdvideo Shop.
Multiple sets can be ordered and rentals can be renewed online.…
Database
Inspectors have a unique inspector number, and the details of their name and position are held on record. Products are identified by their name and records of the product type and a description of the product are kept.…