Nobody downloaded yet

Database System for SmallLocal Dvdvideo Shop - Assignment Example

Comments (0) Cite this document
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.
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.8% of users find it useful
Database System for SmallLocal Dvdvideo Shop
Read TextPreview

Extract of sample
"Database System for SmallLocal Dvdvideo Shop"

Download file to see previous pages 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. By doing this, Marvin will be aware of who has what title, for how long, and how much they have paid for it. The required fields will include the following:
Customer Reference Number
Stock Number
Date Out
Date In
Rental Type
Payment Received
Rental Status


The system will calculate the number of rentals the customer has on their record, as well as any outstanding fines for late returns. This will involve a simple calculation that will performed by running a query on the required customer. The fields for fines will be in a table which will is easy to update.


After all data has been entered, it will be stored in the database, and pre-programmed reports will be able to present this data as information which Marvin can use to manage his stock and the store. The data can also be printed for customers if they want to check their rental history.


Make the system simple for the user to operate

The system should be self-explanatory and should not require constant reference to a manual. This means that the system can be used by anyone regardless of their IT skills.

Producing the right outputs

To check that all the reference values are correct so that calculations and reports are valid.

Reduce amount of work for the user

Incorporate the use of list/combo boxes so that the user can select an item without typing it out. The use of list/combo boxes also reduces the margins for error, for instance, two versions of the same product, e.g. Lost - Season II and Lost - Seson II.

Remove as many errors as possible

Automate as many of the processes, so that use is limited to data input, and printing reports.

Hardware and Software Used

Hardware; -
HP Personal Computer with keyboard, ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Database System for SmallLocal Dvdvideo Shop Assignment”, n.d.)
Database System for SmallLocal Dvdvideo Shop Assignment. Retrieved from
(Database System for SmallLocal Dvdvideo Shop Assignment)
Database System for SmallLocal Dvdvideo Shop Assignment.
“Database System for SmallLocal Dvdvideo Shop Assignment”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document
Relational Database System Design
The current system has been facing some challenges with the structure and the design of its database and the relationship of the data items. The immediately noticeable challenge with the database is the use of important database elements, such as primary keys, foreign keys, and the relationships. The tables apparently require normalization. If the database is not normalized, there is a high risk of the data being inconsistent and lacking integrity. The proposed information management system for the ECT project should have the ability to integrate flawlessly into the ECT Relational Database. The ECT Information Management System infrastructure receives the required data through structural query request, using special criteria for d...
4 Pages(1000 words)Admission/Application Essay
Object Database Management System
...Object Database Object Database Management System A database is a set of records stored in a computer in an organized way, so that a computerprogram is able to consult it to answer questions. For better recovery and sorting, each record is generally organized as a set of data elements (facts). The objects retrieved in reply to queries become information that can be used to make decisions. The computer program used to control and query a database is known as a database management system (DBMS). An object database is a database within information can be represented in the form of objects....
8 Pages(2000 words)Essay
Database Management System Assignment
..., users can simply create a TestCase that utilizes their application or implement a TestCase, SqlProvider (recommended for comparing database systems) and TestScriptGenerator (recommended for randomly simulating user activities). The BLOB benchmark serves as one database benchmark and an example of how to reuse the benchmark framework to understand the changes to the data and the application logic which affects the database performance. Small development shops will be able to use the benchmark framework to significantly reduce the cost of benchmarking their application's database utilization, spend more time enhancing the performance and...
19 Pages(4750 words)Assignment
Database Management System
...BIS2021 DATABASE MANAGEMENT SYSTEM Task Let's start with the definitions of the functional dependencies on the following table. Functional dependency (FD): The following assumptions are derived from the above diagram: 1. The pointer with arrow head shows the dependent variable and the pointer with no arrow head shows the determinant variable. 2. There are 3 functional dependencies as shown above in the diagram. After breaking all the functional dependencies we get the following structure: Table: 1 Table: 2 Table: 3 The table 1 also has got the attribute called budget and salary- category so as to perform joining of all three and getting a associated query...
2 Pages(500 words)Essay
Database Management System
...22-02-2007 Database Management System Data and information are two basic components of any information system. Data is defined as a set of basic facts and entities which itself has no meaning or value. Data is considered the raw material of an information system. An information system transforms data into meaningful management information. Business processes, which are essence of the business, are always associated with a huge amount of data. The objective of an information system is to provide the required information to the organization, o that the business processes can be managed effectively. It is essential or the organization to...
6 Pages(1500 words)Essay
Database Management System
...Database Management Systems The table schema for the flight booking company are given below in the table format. The constrains for a specific fieldis also given. In most of the fields the not null integrity constraint is enforced. The relevant primary key and foreign key are also enforced properly. The data type for a particular field is choose with respect to the context of the field and most of the fields the data length are specified in par with the real time data. For example the number of flights is limited to 6 digit and number of seats is limited to 4 digit. The varchar2 data type is used in many cases which is advantageous in terms of memory management and also to make changes in the size of a...
6 Pages(1500 words)Essay
Enterprise Database Management System
...Running head: ENTERPRISE DATABASE MANAGEMENT SYSTEM Enterprise Database Management System Introduction The world is moving at a fastpace. There is an expedite increase in the development of technology and innovations are happening in all fields almost every day. The world is moving at such a pace that even our day to day operations are automated. Organizations on their part have also evolved constantly. It has come to a state where any kind of recursive function in any field can be automated. Subsequently, organizations have also started encompassing such technologies into their departments. The introduction of computers and Information Systems has...
8 Pages(2000 words)Term Paper
Fernando's skate shop Database
...Lanea Hall American InterContinental ITCO231 Individual 4 May In this paper the complete design and implementation of database for Fernando’s Skate Shop is discussed. The RDBMS used is Microsoft Access 2007. The database design comprises of 6 tables and with input forms. The database is capable of storing complete information of the daily business at the shop. This database can be useful for futuristic evaluation of business and for launching promotions by figuring out the sales volume and regular customers. Introduction: This report describes the features and specifications of the database design formulated for a...
2 Pages(500 words)Essay
Developing a Database System
...Developing a Database System for PC Store Introduction Inventory management system is closely associated with the sales order system. Specific information about sales of PC Store requires to be managed through designing a database. Database design will serve the company to keep the information of sales, customers, vendors, manufacturers, and suppliers. Implementation of computer-based inventory and sales management system has been increasing for last many years. Data sources for database design Scanner data provides information about purchases done on the outlets. This data source does not cover the...
2 Pages(500 words)Essay
Database Management system project (MIS)
...Number: Lecturer: Database Management system project (MIS) This report documents the development of a database system using Access. A database management system is essential for the safe storage, processing, retrieval and analysis of organizational data. The paper documents the development of an airline company database. The first part of 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...
10 Pages(2500 words)Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Let us find you another Assignment on topic Database System for SmallLocal Dvdvideo Shop for FREE!
logo footer
Contact us:
Contact Us Now
FREE Mobile Apps:
  • StudentShare App Store
  • StudentShare Google play
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • Miscellaneous
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us