Answer no. 1(a):
According to ERD the road test and driver are connected to each other in a format where the road driving license is depends upon the road test.
the test start on the time for issuing the driving license no.
the date and time is necessary for issuing the license no.
the correct location is mandatory for issuing the license no.
the candidate should follow all the rules according to guidelines.
the road test is a way to get a license no.
the candidate should be reached on time on road test.
the documentations should be well prepared at the road test time.
Relationship between Elite service and road test
the elite service is directly connected to road test.
the elite service includes the location-based test
it is smart way of billing to the customers
the cleaning products and delivering on the time with billing
The elite services are globally.
The elite forced on time management.
The industry leading the trusted service team and well managed programs.
The billing service on the time.
For issuing the license no the driver needs to fill their name and mobile no. for applying the license no. So, here the mechanisms use to create a system is van serving management system the documentation should be correct as mentioned into the ERD. The van serving management requires the correct format during applying the driving license number.
Here the Entity is driver and the attributes are name, mobile no. address etc.
Ans 2(B): the vehicle service, standard service and elite service are connected in symmetric form to each other. The vehicle service includes the date, time, and final cost which is mandatory during applying license no. the standard service and elite service is optional service.
Here the entity is vehicle service and the attributes are elite service.
Finding Entity: to draw Entity relationship diagram first of all the entities will be find out. In this diagram there are few entities like Company, Van, Staff, mechanic, driver.
Finding Relations: After the finding of entities the relation will be find out of between the entities. In this diagram there are following relationship between entities.
Company to Van (owner)
Van to Vehicle Service (goes for)
Vehicle service to mechanic (undertakes)
Vehicle service to driver (undertakes)
Driver to Road test (conduct)
After that attributes will be added as following:
Company-> Company no(pK)
Van-> Van no
Van NB plat
Van NB model
Similarly, the attributes of all entity will be written
The entity is company, staff, road test and the attributes are name, mobile no., I’d, cost, date, time etc.
Select van numbers, models, mileages from VA where model = ‘Mercedes’ and km =>100000 miles
Select Vans number, van mileage van model from Van where company= Ford and owner = IKEA
Grant Statement: GRANT declaration to assign rights to a particular user or function
The UPDATE statement is a Structured Query Language (SQL) statement that is used in a table to modify or update values.
Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Engineering Assignment Help
5 Stars to their Experts for my Assignment Assistance.
There experts have good understanding and knowledge of university guidelines. So, its better if you take their Assistance rather than doing the assignments on your own.
What you will benefit from their service -
I saved my Time (which I utilized for my exam studies) & Money, and my grades were HD (better than my last assignments done by me)
What you will lose using this service -
Unfortunately, i had only 36 hours to complete my assignment when I realized that it's better to focus on exams and pass this to some experts, and then I came across this website.
Kudos Guys!Jacob "
Proofreading and Editing$9.00Per Page
Consultation with Expert$35.00Per Hour
Live Session 1-on-1$40.00Per 30 min.
Doing your Assignment with our resources is simple, take Expert assistance to ensure HD Grades. Here you Go....