Podcast
Questions and Answers
What is a unique identifier for officers in the traffic violations database?
What is a unique identifier for officers in the traffic violations database?
- name
- shield number (correct)
- violationID
- driverID
Which of the following attributes is not necessary for each violation in the database?
Which of the following attributes is not necessary for each violation in the database?
- fine amount
- violation description
- date of violation (correct)
- officerID
In creating the tables for the database, which aspect is crucial to ensure data integrity?
In creating the tables for the database, which aspect is crucial to ensure data integrity?
- Using only primary keys
- Mitigating the need for foreign keys
- Setting all keys as foreign keys
- Using unique primary keys (correct)
What method can be used to insert the raw data from the Incidents List into the created tables?
What method can be used to insert the raw data from the Incidents List into the created tables?
What action is not included in the requirements for managing the database via the Web Application?
What action is not included in the requirements for managing the database via the Web Application?
What is the correct file extension for Razor pages in a Core Web Application?
What is the correct file extension for Razor pages in a Core Web Application?
In the driver's summary profile, what numeric value is assigned to the Senior category?
In the driver's summary profile, what numeric value is assigned to the Senior category?
What happens when the 'Display Driver Profile' button is clicked?
What happens when the 'Display Driver Profile' button is clicked?
Which layout feature is specifically mentioned for the footer of the Layout page?
Which layout feature is specifically mentioned for the footer of the Layout page?
Which technology is specifically required to implement CRUD operations in the web application?
Which technology is specifically required to implement CRUD operations in the web application?
What is the purpose of the Data List and Data Analysis links in the application?
What is the purpose of the Data List and Data Analysis links in the application?
What should be included in the master page according to the specifications?
What should be included in the master page according to the specifications?
Which programming languages or technologies should be utilized in Part A of the web application development?
Which programming languages or technologies should be utilized in Part A of the web application development?
What was the fine associated with the violation code for DUI?
What was the fine associated with the violation code for DUI?
Which driver received a ticket for an illegal turn on 5/8/17?
Which driver received a ticket for an illegal turn on 5/8/17?
How many times was the driver with ID 676 cited for a seatbelt violation?
How many times was the driver with ID 676 cited for a seatbelt violation?
Which violation code corresponds to the fine of $40?
Which violation code corresponds to the fine of $40?
What was the date of the first speeding violation listed for driver ID 210?
What was the date of the first speeding violation listed for driver ID 210?
What is the total fine accrued by driver ID 676 based on the incidents listed?
What is the total fine accrued by driver ID 676 based on the incidents listed?
Which officer cited driver ID 188 for parking violations?
Which officer cited driver ID 188 for parking violations?
What was the violation code for the ticket given to driver ID 880?
What was the violation code for the ticket given to driver ID 880?
On which date did driver ID 777 receive their DUI ticket?
On which date did driver ID 777 receive their DUI ticket?
Which driver was cited for speeding on 1/5/18?
Which driver was cited for speeding on 1/5/18?
Flashcards
Core Web Application (version 8.0)
Core Web Application (version 8.0)
A web application built using C# and the .NET Core framework (version 8.0).
Drivers’ profile summary page (drivers.cshtml)
Drivers’ profile summary page (drivers.cshtml)
A Razor page that displays information about a driver, based on selected choices.
Radio button age categories
Radio button age categories
Radio buttons used for selecting the driver's age category (Teenager, Young Adult, Adult, Senior).
Selection list (State)
Selection list (State)
Signup and view all the flashcards
Concatenated display text
Concatenated display text
Signup and view all the flashcards
Layout page (cshtml)
Layout page (cshtml)
Signup and view all the flashcards
CRUD pages
CRUD pages
Signup and view all the flashcards
Razor Pages (cshtml)
Razor Pages (cshtml)
Signup and view all the flashcards
Officer
Officer
Signup and view all the flashcards
Violation Code
Violation Code
Signup and view all the flashcards
Fine
Fine
Signup and view all the flashcards
Driver ID
Driver ID
Signup and view all the flashcards
Driver Name
Driver Name
Signup and view all the flashcards
Driver Address
Driver Address
Signup and view all the flashcards
Driver City
Driver City
Signup and view all the flashcards
Driver State
Driver State
Signup and view all the flashcards
Driver ZIP
Driver ZIP
Signup and view all the flashcards
Date of Violation
Date of Violation
Signup and view all the flashcards
Database Management System (DBMS)
Database Management System (DBMS)
Signup and view all the flashcards
Entity Relationship Diagram (ERD)
Entity Relationship Diagram (ERD)
Signup and view all the flashcards
Primary Key
Primary Key
Signup and view all the flashcards
Foreign Key
Foreign Key
Signup and view all the flashcards
CRUD Operations
CRUD Operations
Signup and view all the flashcards
Study Notes
Web Application Development Test Three Notes
- Core Web Application: A web application built using C# and Core Web Application framework, version 8.0, with a layout page for consistent design across all pages. Pages are .cshtml, not HTML.
Part A: Inside Web App
-
Drivers.cshtml: A Razor Page designed to summarize driver information, utilizing HTML, CSS, Bootstrap, and potentially JavaScript/jQuery. The file extension is .cshtml.
-
Driver Profile Display: Based on user input (age category and state), the profile displays a concatenated statement. For example, "Based on details provided, you are a Young Adult driver from California. You are at least 22 years old." The age category and state will change based on user input.
-
Data Entry: Assign numerical values to radio buttons (18 for Teenager, 22 for Young Adult, 27 for Adult, 65 for Senior).
-
Navigation: Links to "Data List," "Data Analysis," and other pages enhance navigation within the application.
-
File Handling: Ensure that necessary JavaScript, CSS, and image files are properly placed.
Part B: SQL Server
-
Table Creation: The 33rd Precinct needs a database system to manage traffic violations. Tables are designed for efficiency and data integrity as shown in a diagram (Figure 3).
-
Incident Tracking: Create normalized tables to track officers, violations, drivers, and violation incidents. Primary keys ensure data uniqueness.
-
Enforcement Data: Tables must track unique officer IDs (policeID), violation details (violationID, violation, fine), driver information (driverID, name, address), and incident details (incidentiD, incidentDate, violationID, officerID, driverID).
-
Data Import: Populate the created tables with data from the "Incidents List" (Figure 4). Be mindful of primary key constraints.
-
CRUD Capabilities: In the application, use a DBContext to manage interactions with the relevant database tables. Ensure the ability to create, read, update, and delete (CRUD) data.
-
Application Integration: A web application should connect to and handle these tables' data.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
