Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bicycle Rental System A bicycle renting company wants to create an information system that allows it to store the data regarding all their reservations and

image text in transcribed
Bicycle Rental System A bicycle renting company wants to create an information system that allows it to store the data regarding all their reservations and rentals. The system should follow these requirements: . It should be possible to store the national id number (NIN), name and address for every client. The NIN must be different for every client and all clients should have at least a NIN and a name, The database should also contain information about the bicycle models that can be rented-Each model has an unique name, a type (that can only be road, mountain, bmx or hybrid) and the number of gears. Each bicycle has a unique identifying number and a model. The company has several different stores where bicycles can be picked up and returned. Each one of these stores is identified by an unique name and has an address (both mandatory). . When a reservation is made, the following data must be known: which client did the reservation, when will he pick up the bike (day), which bike model he wants and where will he pick up the bike (store). . When a bike is picked up, the actual bike that was picked up must be stored in the database. When a bike is returned, the return date should be stored in the database. Design this scenario using domain model

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Query Formulation And Administration Using Oracle And PostgreSQL

Authors: Michael Mannino

8th Edition

1948426951, 978-1948426954

More Books

Students also viewed these Databases questions

Question

LO4 Specify how to design a training program for adult learners.

Answered: 1 week ago