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)