Custom Writing Help For You!

Special Discounts Offers! 20-30% Off!

Posted: October 12th, 2020

What is a Database Get research paper samples and course-specific study resources under   homework for you course hero writing service – Manage ment System

Dinky Hire firm is a small family business that stocks general equipment such as garden tools, car maintenance tools etc. For hiring to its customers. A database system is required to simplify management of the business and to provide some financial information and maintaining stocks. Equipment’s are classified under various categories.
Equipment’s are of different brands within each category. Brands are varies in their prices and obtained from various suppliers. The known categories are: a) Gardening Equipment d) Decorating Equipment g) Heating and Lighting b) Building Equipment e) Car Maintenance h) Miscellaneous c) Access Equipment f) Power Tools Prices of equipment offered by the various suppliers as well as the delivery time for that equipment must be kept in the DB. The firm arranges for business customers only, a 24-hour support to replace any Rosen or faulty equipment that on hire.
Upon receiving a customer complain, an immediate delivery will be arranged to replace the faulty equipment provided that it is in stock. Otherwise, a refund for the full charged amount will be administered. Private customers though, in similar cases, must bring the faulty equipment(s) themselves and replace them with working ones or get a full refund if there isn’t any available in stock. Business customers are given various membership categories for discount purposes. These are silver, gold and diamond memberships.

Silver members get 10%; Gold members get 25% and Diamond members get 40%. Hiring equipment’s for private customers are restricted to those who live within 5 miles radius from their address. This distance from the private customer address is measured on map on the wall and the information stored on the customer record the first time the hire equipment’s. No such restriction exists for business customers. Requirements: The following sections specify the requirements of the system. The computer is to be used when a customer visits the company to hire equipment’s.
At this time the following processing is necessary for each transaction: ; If not already known (I. E. Not previously entered into the DB), the customer’s details are recorded. ; The equipment to be hired, with expected return date, is recorded. ; The equipment stock as recorded in the database is updated automatically. When business customers’ call for support to replace any broken or faulty equipment’s on hire, a log must be made in the DB and whether replacement equipment is arranged and delivered or a full refund is given.
When the equipment is returned, the following processing is required: ; The actual return date is entered. ; An invoice is printed which shows the item borrowed and calculates the total cost including VAT. The cost should be based on a rate for one day plus a rate for each additional day. The daily rate varies between weekdays and weekend days. ; The stock figures are adjusted. ; Business customer discounts will be calculated according to the membership category, while no discount is given to private customers. 2. 3. 4. Design and create a database to the above scenario.
State any assumptions made (if any). Map the diagram in to Relational Schema and Proof your answer is normalized up to BC. Create the Database using Myself. Final report should contain: 0 Assumptions 0 Entity Relationship Diagram 0 Relational Schema 0 Proof of Normalization 0 Myself commands which you have used to create the database Assignment Background A Database Get research paper samples and course-specific study resources under   homework for you course hero writing service – Manage ment System (DB’S) is a set of programs that enables you to store, modify, and extract information from a database, it also provides users with tools to add, delete, access, modify, and analyze data stored in one location.
A group can access the data by using query and reporting tools that are part of the DB’S or by using application programs specifically written to access the data. Assignment Requirements 1 . The final document should be Professional and systematic computerized document. 2. It is essential to have References (if any). 3. Assignment should be word-processed and should be spiral bound. 4. The page after the Cover page should be as the assignment marking scheme (Attachment No 001). 5. Submit the softwood of the assignment along with the bound hard copy. Written Assignment Format:
To receive full credit, assignments should maintain the following format: 0 Font: Caliber, Size: apt. 0 Spacing: standard. 0 File type (for electronic submission by prior arrangement): MS Word (“. Doc” only) 0 Name/headers/footers on each page. Page number on each page. Cover page/ Contains page. Rules and Regulation of the Assignment 1 . Assignments will NOT be accepted after the last date of acceptance under any circumstance.

Order for this Paper or similar Answer/Assignment Writing Service

Place your order by filling a guided instructions form in 3 easy steps.

Why choose our Study Bay Services?

Like every student, Focusing on achieving the best grades is our main goal

Top Essay Writers

We have carefully cultivated a team of exceptional academic writers, each with specialized expertise in particular subject areas and a proven track record of research writing excellence. Our writers undergo rigorous screening and evaluation to ensure they hold relevant advanced degrees and demonstrate mastery of English grammar, citation style, and research methodology. Recent projects completed by our writers include research papers on topics such as sustainable energy policy, cognitive behavioral therapy, and molecular genetics.

Student-Based Prices

We prioritize attracting highly skilled writers through competitive pay and strive to offer the most cost-effective services for students. References from recent years include surveys of customer satisfaction with online writing services conducted by the American Customer Satisfaction Index between 2018 to 2022, demonstrating our commitment to balancing affordable costs with high standards of work through positive reviews and retention of expert writers.

100% Plagiarism-Free

We guarantee 100% original and plagiarism-free final work through a thorough scanning of every draft copy using advanced plagiarism detection software before release, ensuring authentic and high-quality content for our valued customers. To note, we also do not generate assignment content with AI tool, thus you a guaranteed 0% similarity index for your final research paper.

How it works

When you decide to place an order with Study Pro Essay, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and,the support and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.