For this assignment, create a Crow$$s Foot ERD for the business narrative below. Before you start your ERD, make sure you watch the three videos included in Readings and Resources above because these videos will walk you through each step that you need to follow.

Business Narrative:

Read the following business narrative about a small vehicle repair garage and then create your Crow$$s Foot ERD.

This garage specializes in individual vehicle repair and needs to track the work they perform for their customers to improve their business. The garage has many customers. While most customers own multiple vehicles, each vehicle is owned by only one customer. For example, customer Jason owns both a truck and a car. The truck and car are only owned by Jason and by no one else. Additionally, a vehicle can have multiple repairs. Each repair is specific to a single vehicle. For example, if Jason brings his truck in for a repair in June and again in July these two repairs are specifically for his truck and not for his second vehicle, which is the car. A mechanic at the garage can work on multiple repairs but a repair is only worked on by one mechanic. For example, Mike is a mechanic at the garage, he can make multiple repairs, but each repair is only worked on by Mike and not by another mechanic at the garage.

The garage also needs to know the following:

The address and name of each customer

Vehicle make, model, and year

The date and total cost of each repair

The name, address, and salary of each mechanic

Your completed ERD needs to include the following:

All tables, outlined in the business narrative, with the correct primary and foreign keys.

For each table include any appropriate attributes$($columns$).$

All the relationships between the tables identified using the correct Crow$$s foot notation.