Needed in 2-3 hours i will rate your answer from 5 accounts.

To complete this exercise, read the narrative through and: - look for nouns in description of data - they will likely translate into tables - next, identify the data needed to describe each table, define each attribute with a column name and type of data - Identify naturally occurring primary keys to meet Entity Integrity requirements - OR insert a surrogate key that artificially identifies a row of data - to serve as the primary key - Identify how tables are related - place a foreign key in the associated table The owner of a small transport company wants to build a database to track data about its trucks, the types of its trucks it owns and its terminals. - For each truck, the owner wants to know the latest odometer reading (expressed in miles) and the truck's VIN number, and license plate info ( state of issue and the license \#) - For each truck type, the owner wants a description of the type. - For each terminal, the owner wants to record the location of the terminal (city and state), the area code \& phone number and name of the manager of the terminal. - Each truck is classified as one and only one type. There may be 0 or many trucks of each type. - Each truck is based in one and only one terminal. Each terminal may have 0 or many trucks based out of it. Download the HW3 Relational Model template from Blackboard. Rename the file to yourLastName_HW3.docx. Use MS Word - and develop the relational model that captures the elements (tables, attributes, and relationships) for this planned database. Also identify primary and foreign keys that implement the relationships. You may copy this "many" symbol to use in your model: HW\#3 - Relational Model Copy the Entity box as needed to complete your model (which is simply a Word table inserted into a textbox. Draw lines to illustrate the relationships in your database and add the 1:1, 1:M notations to designate the relationship type. Identify the PK as the first attribute (as prompted below). Save this file as yourLastName_HW3.docx and submit to Blackboard