CSC 283 Web Application Development Test Three PDF

CSC 283 We b A p p l i c a t i o n D e v e l o p m e n t Professor Uzo Osuno Te s t T h r e e November 30th 2024 1. Create a Core Web Application (version 8.0) (based on the C# l...

CSC 283 We b A p p l i c a t i o n D e v e l o p m e n t Professor Uzo Osuno Te s t T h r e e November 30th 2024 1. Create a Core Web Application (version 8.0) (based on the C# language and CORE Web Application) TestThreeLastFirst, where Last is your Last name and First, your first name. Create a Layout page(s) to be used on all pages. Every page featured here is a.cshtml (razor) page not HTML PART A INSIDE WEB APP -- HTML, CSS, BOOTSTRAP, JQUERY (if preferred), JavaScript 2. Create a Razor Page, named drivers.cshtml, to be used to provide a summary of Drivers’ profile Use fig 1 below as a design specification: (DO THIS ON A Razor Page which have.cshtml extension not.html) fig 1 a) Assign the following numeric values to each radio button choice respectively: 18 to Teenager, 22 to Young Adult, 27 to Adult, and 65 to Senior. b) The Data List, Data Analysis, and other links provide navigation to any of your preferred pages in your app. c) Functionality: When the “Display Driver Profile” button is clicked, depending on age category and state selected, the following concatenated statement is displayed in the Drivers’ Profile area, near the bottom of the screen. “Based on details provided, you are a(n) Young Adult driver from California. You are at least 22 years old.” “Young Adult” in the above example is the text of the radio button selected, “California” is the value of the selection list choice made, and “22” is the numeric value assigned to the radio button choice. Anytime different choices are made, the concatenated text reflect these. Put the javascript, css, images files in the appropriate folders Page 1 of 4  a) Using the same Layout Page from (1) or another Layout page, create CRUD pages based on data described next. The master page should incorporate everything before and including the line as shown In fig 2 below. b) In the footer of the Layout page, provide an email address. c) Use these web forms to complete Part B. fig 2 PART B SQLSERVER – (a) Table Creation (b) Data Input. Use the following business rules for question 4 on the next page. The 33rd Precinct officers need a new database management system to track traffic violations. i. Officers are uniquely identified by their shield numbers (policeID) ii. Each violation is described and carries its own fine. iii. Each driver is described by their driverID number, name and their address. iv. An officer will issue a violation to any erring driver any day the violation occurs. Tables have been normalized for you in the following Entity Relationship Diagram (ERD) in fig 3. Page 2 of 4  fig 3. 4. Create tables as specified. a) Be sure to include any primary and foreign keys. b) Analyze the raw data provided in the Incidents List (fig 4). c) Insert this data from the Incidents List into the tables created. (May use SQL or Grid controls to insert data). As you insert this data, be mindful of the fact that primary keys are unique. d) From the Web Application created in question 1, create a connection to these tables e) Create a DBContext to these and Scaffold the tables to enable CRUD capabilities. f) Ensure that you are able to Delete, Edit and Create new data in each of these tables. VISUAL STUDIO….please update your Visual Studio to the latest version. Click Help, then Click check for updates. Incidents List is shown on the next page… You don’t have to create the incidents list page, just use it to obtain the data required for the different tables shown in the ERD diagram above Page 3 of 4  Incidents List Violation Date of Driver Driver Driver Driver Driver Shield Officer Code Violation Fine Violation Driver ID Name Address City State ZIP 1929 Fahey 10 Speeding 175 10/12/17 210 Burns 1 East St Lynbrook NY 11563 1212 Conner 15 Parking 40 5/8/17 188 Soloman 5 Kansas St Garden City NY 11530 2020 Dirk 19 Illegal Turn 50 5/8/17 175 DeFaio 19 Wall St New York NY 10010 1212 Conner 17 Seatbelt 125 12/23/17 101 Izzo 1 Astor Pl Westbury NY 11590 4001 Kane 15 Parking 40 12/23/17 777 Parker 9 Abbey Ln Garden City NY 11530 2020 Dirk 15 Parking 40 12/31/17 188 Soloman 5 Kansas St Garden City NY 11530 1929 Fahey 99 DUI 350 12/21/17 676 Quinn 4 Atlas St Westbury NY 11590 4001 Kane 17 Seatbelt 125 1/1/18 676 Quinn 4 Atlas St Westbury NY 11590 4001 Kane 10 Speeding 175 1/1/18 676 Quinn 4 Atlas St Westbury NY 11590 1212 Conner 10 Speeding 175 1/2/18 210 Burns 1 East St Lynbrook NY 11563 2020 Dirk 99 DUI 350 1/4/18 777 Parker 9 Abbey Ln Garden City NY 11530 1929 Fahey 17 Seatbelt 125 1/5/18 120 Stein 1 West Ave New York NY 10010 2020 Dirk 15 Parking 40 1/5/18 175 DeFaio 19 Wall St New York NY 10010 1212 Conner 10 Speeding 175 1/5/18 301 Spano 5 Water St Lynbrook NY 11563 1929 Fahey 19 Illegal Turn 50 1/6/18 880 Katz 99 Plover St Westbury NY 11590 Fig 4 Page 4 of 4