Computer Science and Engineering Assignment

Answer no. 1(a):

Relationship between entities driver and road test according to ERD

  1. 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.

  2. the test start on the time for issuing the driving license no.

  3. the date and time is necessary for issuing the license no.

  4. the correct location is mandatory for issuing the license no.

Adequate justifications

  1. the candidate should follow all the rules according to guidelines.

  2. the road test is a way to get a license no.

  3. the candidate should be reached on time on road test.

  4. the documentations should be well prepared at the road test time.

Answer no.1(b):

  1. Relationship between Elite service and road test

  2. the elite service is directly connected to road test.

  3. the elite service includes the location-based test

  4. it is smart way of billing to the customers

  5. the cleaning products and delivering on the time with billing

Adequate justifications

  1. The elite services are globally.

  2. The elite forced on time management.

  3. The industry leading the trusted service team and well managed programs.

  4. The billing service on the time.

Answer 2(A):

The connection among staff, mechanic and driver: -

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.

  1. Company to Van (owner)

  2. Van to Vehicle Service (goes for)

  3. Vehicle service to mechanic (undertakes)

  4. Vehicle service to driver (undertakes)

  5. 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):

flow chart shows tracking of vehicle service

The entity is company, staff, road test and the attributes are name, mobile no., I’d, cost, date, time etc.

Answer 4:

  1. 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

  2. Grant Statement: GRANT declaration to assign rights to a particular user or function

    Update:

  3. 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

Get It Done! Today

Upload your assignment
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

Highlights

  • 21 Step Quality Check
  • 2000+ Ph.D Experts
  • Live Expert Sessions
  • Dedicated App
  • Earn while you Learn with us
  • Confidentiality Agreement
  • Money Back Guarantee
  • Customer Feedback

Just Pay for your Assignment

  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00Per Page
  • Consultation with Expert

    $35.00Per Hour
  • Live Session 1-on-1

    $40.00Per 30 min.
  • Quality Check

    $25.00
  • Total

    Free
  • Let's Start

Browse across 1 Million Assignment Samples for Free

Explore MASS
Order Now

My Assignment Services- Whatsapp Tap to ChatGet instant assignment help

refresh