Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Databases questions

Question

305 mg of C6H12O6 in 55.2 mL of solution whats the molarity

Answered: 1 week ago