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.
Answer no.1(b):
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.
Answer 2(A):
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.
Answer-3: (A)
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)
Company Name
Company tel
Van-> Van no
Van NB plat
Van NB model
Similarly, the attributes of all entity will be written
Answer 3(B):
The entity is company, staff, road test and the attributes are name, mobile no., I’d, cost, date, time etc.
Answer 4:
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
Update:
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
1,212,718Orders
4.9/5Rating
5,063Experts
Turnitin Report
$10.00Proofreading and Editing
$9.00Per PageConsultation with Expert
$35.00Per HourLive Session 1-on-1
$40.00Per 30 min.Quality Check
$25.00Total
FreeGet
500 Words Free
on your assignment today
Doing your Assignment with our resources is simple, take Expert assistance to ensure HD Grades. Here you Go....