• Internal Code :
  • Subject Code : 6ELEN007W
  • University : University of Westminster
  • Subject Name : Engineering

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

Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
Not Specific >5000
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

"

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 -

Absolutely nothing.

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

"

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

Get
500 Words Free
on your assignment today

Browse across 1 Million Assignment Samples for Free

Explore MASS
Order Now

Request Callback

Tap to ChatGet instant assignment help

Get 500 Words FREE
Ask your Question
Need Assistance on your
existing assignment order?