Database System for SmallLocal Dvdvideo Shop. - Assignment Example

Only on StudentShare

Extract of sample
Database System for SmallLocal Dvdvideo Shop.

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


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.
Author : janick82

Related Essays

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 the tuples of a relational database can be dreary to write, and prolonged to execute. This variance between the models used to represent information in the application programs and the database is...
8 pages (2008 words) Essay
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 runs of the benchmark.The benchmark is platform independent and can be extended to support any database vendor providing a Java data source for connectivity.The benchmark framework requires the...
19 pages (4769 words) Assignment
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....
13 pages (3263 words) Essay
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 reconciliations for the organization....
14 pages (3514 words) Essay
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....
4 pages (1004 words) Assignment
Got a tricky question? Receive an answer from students like you! Try us!