Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create a new ASP.NET 6 MVC project 2. Create the following Models representing an auto repair shop Customer.cs Id FirstName LastName Phone Vehicle.cs Id

1. Create a new ASP.NET 6 MVC project

2. Create the following Models representing an auto repair shop

Customer.cs

Id

FirstName

LastName

Phone

Vehicle.cs

Id

Make

Model

Year

Mileage

VIN

ServicePerformed.cs

Id

TimePerformed

Notes

Technician.cs

Id

FirstName

LastName

EmployeeNumber

4. Using C# code establish the following relationships between the models (You will need to add properties to the models outside of what is listed above to accomplish this)

A Customer can have many Vehicles.

A Vehicle can only have one Customer.

A Vehicle can have many Services Performed.

A Service is performed by one technician.

A technician can have many Services Performed.

5. Generate the database from these models

6. Create a CustomerController and implement CRUD functionality with corresponding Views for the Customer table.

7. Include a screenshot of your localDB Database Diagram

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions