We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

See Pricing

What's Your Topic?

Hire a Professional Writer Now

The input space is limited by 250 symbols

What's Your Deadline?

Choose 3 Hours or More.
2/4 steps

How Many Pages?

3/4 steps

Sign Up and See Pricing

"You must agree to out terms of services and privacy policy"
Get Offer

Database Management System: Assignment

Hire a Professional Writer Now

The input space is limited by 250 symbols

Deadline:2 days left
"You must agree to out terms of services and privacy policy"
Write my paper

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 broken or faulty equipment that on hire.

Don't use plagiarized sources. Get Your Custom Essay on
Database Management System: Assignment
Just from $13,9/Page
Get custom paper

Upon receiving a customer complain, n 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 lies 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 corded. 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: C] Assumptions 0 Entity Relationship Diagram 0 Relational Schema C] Proof of Normalization C] Myself commands which you have used to create the database Assignment Background A Database Management 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 softly of the assignment along with the bound hard copy.

Cite this Database Management System: Assignment

Database Management System: Assignment. (2018, Jun 10). Retrieved from https://graduateway.com/database-management-system-assignment/

Show less
  • Use multiple resourses when assembling your essay
  • Get help form professional writers when not sure you can do it yourself
  • Use Plagiarism Checker to double check your essay
  • Do not copy and paste free to download essays
Get plagiarism free essay

Search for essay samples now

Haven't found the Essay You Want?

Get my paper now

For Only $13.90/page