Introduction to Database Design & Meraki Delivery Case Study - IT Assignment Help

Assignment Task

Task

Meraki Delivery Company has been in the trucking business for the last 30 years. They started storing data in a file-based system and then transitioned into using spreadsheets. As years progressed, their business has grown exponentially leading to an increase in the number of customers and volume of data. You have been recently employed a database model to replace the current spreadsheets. 
You have been provided with the following business rules about Meraki Delivery Company 
Customers: Every customer needs to be uniquely identified in the system. Other details which the system needs to store about a customer include their name, address, and phone number. Some customers may sign up to the loyalty program to become a 'VIP customer' in which case the date they signed up and the VIP discount percentage they will receive should be recorded. 
Trucks: Every truck is uniquely identified within Meraki using a primary identifier. Other details of a truck include the "vehicle identification number" (VIN) of the truck, the registration number, the colour, the year it was purchased and the purchase price. Every truck is of a particular make and model. Every "make" of truck is identified with a unique identifier. Meraki keeps a record of the manufacturers where they can purchase certain makes of trucks. For the manufacturer, the name of company, a contact person name in the manufacturer's company, email, and phone number are recorded. A manufacturer can potentially provide many different truck models. A model number is unique for every truck make and this means a model number will be reused for every make of the truck The name and year of the model are also stored. There are two types of trucks: light trucks and heavy-duty trucks. The load capacity needs to be recorded for heavy-duty trucks. 
 

This IT Assignment has been solved by our IT Experts at onlineassignmentbank. 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.