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.
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
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
HP Personal Computer with keyboard, ...
Cite this document
(“Database System for SmallLocal Dvdvideo Shop Assignment”, n.d.)
Retrieved from https://studentshare.net/technology/303768-database-system-for-smalllocal-dvdvideo-shop
(Database System for SmallLocal Dvdvideo Shop Assignment)
“Database System for SmallLocal Dvdvideo Shop Assignment”, n.d. https://studentshare.net/technology/303768-database-system-for-smalllocal-dvdvideo-shop.
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.
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.
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).
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.
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.
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.
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.
This database can be useful for futuristic evaluation of business and for launching promotions by figuring out the sales volume and regular customers.
This report describes the features and specifications of the database design formulated for a scenario
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
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
GOT A TRICKY QUESTION? RECEIVE AN ANSWER FROM STUDENTS LIKE YOU!
Let us find you another Assignment on topic Database System for SmallLocal Dvdvideo Shop for FREE!