Question: 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

FirstName

LastName

Phone

Vehicle.cs

Make

Model

Year

Mileage

VIN

ServicePerformed.cs

TimePerformed

Notes

Technician.cs

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You will write a program to run a car rental shop. The program will work as follows: On startup, it will read a file of Cars, staff, and customers (storing each into a single array, so you should...

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

Required information In this mon case you will enate andormation related to your client - Apollo Shoes to determine audit risk Instructions Auditors are tasked with gathering a wide variety of...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Kindly Solve this case study Quickly please in 4 hours ............ Part A: Developing a strategy to lead change (1,500 words 40% of the marks) Task 1 - Strategy Report Produce a 1,500 word report...

Please, this assignment is about Database integration, we have worked on html web page creation where we create html web pages, then we move on to the MVC application with servlet and JSP, then...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

This question involves the use of AGGREGATE linear PYTHOIN regression on the Auto data set. (a) Perform a simple linear regression with mpg as the response and horsepower as the predictor. Describe...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

I am attaching all of the questions. These are basically small questions which are required to be answered as per the exact requirements. These are all related to finance. No irrelevant details are...

When developing cost functions, which of the following statements is FALSE? A. Personal observations of costs and activities provide the best evidence of a plausible relationship between a cost and...

In 2 0 2 5 what will earning $ 1 8 1 0 provide to a worker covered under Social Security?

TURTLE GRAPHICS C PROGRAM: Using a 25 X 25 board with start position (0,0), your turltle will be given integer commands that will control it's movement. 1=pen up, 2=pen down, 3=turn right 90 degrees,...