Implement a database system for a bike rental shop

Assignment Help Database Management System
Reference no: EM132388609

ASSESSMENT TASK

Part I

You are required to design and implement a database system for a bike rental shop. Each customer has a unique membership number. For each customer, you keep his/her name, address, the total number of bikes the customer is currently hiring, and the date the customer first registered with the shop.

You also keep information about the bikes that the shop owns. Each bike is assigned a unique number. For each bike, you store its brand, production date, the date the bike was purchased, the cost of purchase and the cost of rental per hour.

You also need to store information about customers' rentals, i.e. the bike, hire date and time, the hire duration and the date and time of the return.

In addition, you record the damages after rentals and repairs which have been done to a bike. After every rental, the biked is checked for damages, and if found, these are recorded in the database (damaged part, description of damage, etc.). Every damage is then subsequently repaired, either in-house or by third-party services. For every repair, you store its date, costs and service provider. All the third party repair services are also saved, with their names, emails and phone numbers.

Tasks

A. Develop an Entity-Relationship model of the information requirements for the above system. Translate your model into an equivalent set of relations.

Specify all relation headings, indicating primary and foreign keys.

B. Choose either Neo4J or MongoDB and generate sample data for the above case. Show samples of generated data.

Write the following queries, briefly explain how they work and provide screenshots of the results (make sure that there is enough data that all the queries return results).
1. Show all users who have not rented a single bike.
2. Count the number of users who have rented bikes in October 2018.
3. Show all bikes which were rented by the specific user with <some membership number>.
4. Show the user with the highest amount of rentals.
5. Show all users who have damaged bikes.
6. Show the damaged bikes which have not been repaired yet.
7. Show the brand of bike which is damaged most often.

Part 2
You are required to critically analyse a research paper from the data management field and write a short summary of the analysis. A list of suggestions is provided (the papers are downloadable from Brightspace), however you are welcome to choose a paper not included in this list. After confirming your final selection with the lecturer you should:

A. Evaluate this research, also considering other research in the field. During the evaluation you should address the following questions:
• Where does this research lie in the larger field of database research?
• What does the proposed paper do?
• What alternatives exist to the techniques being proposed?
• What are advantages/disadvantages of the presented research in comparison to other research in this field?
• What could be possible further work in this direction?

Note the word limit of 900 (excluding the references)

Verified Expert

The document includes the Data base design of the Bike rent shop using Mango Data base.In mango collection and documents are the terms used to describe database and entity.The transaction with the database are performed using Cloud technology.The report also includes the evaluation of the research work Distributed GraphLab :A Framework for Machine Learning and Data Mining in the Cloud” published in proceeding of the VLDB Endowment Volume 5 Issue 8,April 2012.The research work addresses the issues of MLDM.

Reference no: EM132388609

Questions Cloud

What is the beta of portfolio p : Suppose the return on portfolio P has the following probability distribution:
What is the yield to maturity : 1. What is the yield to maturity? Do not round intermediate calculations.
Product that has the lowest price per ounce : GoodButter costs $3.55 for a one pound container. MayBeBetterButter costs $1.40 for a 5 ounce tub. Showing all work, which product is better buy?
What is the total monthly cost of the townhouse : Given all monthly expenses, what is the total monthly cost of the townhouse? Show all the work for full credit.
Implement a database system for a bike rental shop : Design and implement a database system for a bike rental shop. Each customer has a unique membership number - Develop an Entity-Relationship model
Calculate the purchase price for 1 unit of this corporate : Draw the detailed contingent cash flow diagram associated with this corporate bond, from the perspective of Jenny.
What value of r would make the plans seem equally : Which plan do you choose? What value of r would make the plans seem equally attractive to you?
Immunize the interest rate risk of meeting this liability : If you have future liability to pay and you decide to equal your portfolio duration and the maturity of the liability payment, so you can use the portfolio to i
What the bretton woods agreement : What the Bretton Woods Agreement did to the ability of foreign exchange rates to fluctuate freely?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd