LD7084 - Database And Analytics Principles - IT Assignment Help

Assignment Task

Assessment Brief

• For each customer, the database should store the CustomerID, Last Name, First Name, Email, and the Phone Number.

• For each driver, their name, salary, email address and their manager are recorded as well details of their Driving License such as Driving License Number, Issue Date, country of issue and Expiry Date.

• Each driver is assigned a motorbike when they start with the company and they normally keep it during the duration of their contract. Details of the motorbike are registered such as RegistrationNo, Colour, date of purchase, engine size etc.

• Each Manager manages at least one driver and each driver is associated with one restaurant only but one restaurant employs many drivers.

• For each of the Restaurant, the RestaurantID, Restaurant Name, Address are recorded.

• For each Item, the ItemID, the Item Name and Item Price should be recorded. The items are divided into four categories such as Starter, Main Course, Deserts and Drinks. Prices for each item may vary in different branches. For example, the Pizza Hut Edmonton Branch sells Garlic Bread at £4.50 but the Liverpool Street Branch charges £5.00 for the same item.

• For each order, it is required to store the OrderID, Orderdate, items and the quantity that have been ordered. A customer must order at least one item per order.

• A customer can have one or more orders from the same or different restaurants.

• A driver can deliver more than one order but one driver delivers a particular order only.

This (LD7084) IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.