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. ...Show more

Summary

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
Database System for SmallLocal Dvdvideo Shop essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Database System for SmallLocal Dvdvideo Shop"
with a personal 20% discount.
Grab the best paper

Related Essays

Computer Shop Limited (CSL)
Conversely, an appropriate Internet connectivity is needed in order to download or upload the applications based on Cloud Computing. An inclusive report over the services provided by Cloud Computing, Cloud distractions, huge data analysis, storage and architecture is explained.
16 pages (4000 words) Assignment
Database Configurations
The basic purpose for any database in an organization is to serve the purpose of storing transactions and being able to produce reports effectively (Rob & Coronel, 2002). Although, most database analysts would agree with this simplistic definition of a database, there is more to uses of a database than what meets the eye in this definition.
1 pages (250 words) Assignment
Database
The second layer is the schema of a given database. The third layer is the database itself representing a state of the application's data often called micro-data. The fourth layer consists of the macro-data that are generated from the micro-data by application of view queries to the micro-data (DIETRICH, 2011).
6 pages (1500 words) Assignment
Database Management System Assignment
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.
19 pages (4750 words) Assignment
Coffe Shop
In essence, the caf shares paralleling attributes that the library may possess. Like the caf, people often use libraries to study or meet with colleagues, whether they are academic or business summits. These parallels lead to question the benefits of conglomerating the two public entities into a community-unifying center.
14 pages (3500 words) Assignment
Database
Each asset is regularly inspected, and the date of the inspection, the person who carried out the inspection and details of any maintenance actions are noted. If the asset is a photocopier then the toner is replaced and the total number of copies made is recorded as well as the toner serial number.
4 pages (1000 words) Assignment
Coffee Shop
The plan has undertaken to offer a detailed explanation of its intended customer related processes that encompasses strategies used by the sales department, description of the target market and the brands that will be associated with our products. The business plan draws it's laid down work related ethics from the recommendations of best practice explained in Ombudsman's guide.
12 pages (3000 words) Assignment
Database
Every table must have a candidate key. Data that is in a table of the database for a lifetime determines whether attributes have the candidate key or not. A primary key can either be a substitute or surrogate. Foreign tables may contain attributes with external keys
1 pages (250 words) Assignment
Database Management
The growth rate of the following town has seen the apartments booked and the contract is agreed upon with the tenant. The apartments are well furnished with the best quality products and latest fittings
6 pages (1500 words) Assignment
Database Management system project (MIS)
f the report will document the analysis of the business case to identify data management and processing issues and challenges facing the organization. The second part documents the design of a solution that includes the database strategy to define the business rules that govern
10 pages (2500 words) Assignment
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT