Question: Question related to Computer Science->DataBase only answer the question if u know, otherwise do not answer it from random internet, will dislike if its not
Question related to Computer Science->DataBase
only answer the question if u know, otherwise do not answer it from random internet, will dislike if its not relevant.
Scenario:
A company records information on its fleet of vehicles and the employees who are permitted to drive them. The database is used by three groups of people: the department managers, the finance division, and the service department.
For the department managers, each vehicle has a unique registration number and each driver a unique employee number. Drivers may be authorized to drive a number of vehicles, and any vehicle may be used by a number of drivers. Vehicles are allocated to departments within the company, although they may be used by drivers in other departments. Some classes of vehicles require specialist driver qualifications. There are occasional accidents that may lead to the vehicle being written off and/or the driver being disqualified from driving some or all classes of vehicle.
For the finance division, each vehicle, identified again by registration number, has a current and a replacement value, must be taxed on a certain date, and was bought on a certain date. For accounting purposes, the allocation of vehicles to departments is also required. Finally, details are recorded of any insurance claims associated with accidents, or repair costs if no insurance claim arose.
The service department is responsible for giving regular services to each vehicle. There are different types of service corresponding to different mileage values for each class of vehicle, with a short description documenting each type of service. Where vehicles have been involved in accidents, details of repairs affected are recorded.
Q. Create a Mongo DB database (Collection), Apply constraints using validator feature and perform CURD on the created database, and create 5 scenarios to extract meaningful information out of the created database.
Step by Step Solution
There are 3 Steps involved in it
To create a MongoDB database and apply constraints using the validator feature we need to model the data structure based on the provided scenario and then implement CRUD operations Create Read Update ... View full answer
Get step-by-step solutions from verified subject matter experts
