INFT 2064 Web Technologies Assignment 1
SA Expiation Data
All work is to be done individually and must be your own work. You must not use AI tools, discuss or share your @razor code or LINQ/Lambda C#, JavaScript code with anyone else. You must only submit code you have personally written (with the exception of utilising bootstrap html template examples). If you use resources, you must include direct links to those resources as HTML/@razor comments in the relevant files. In Week 10 you must be able to answer questions about your code and make changes to demonstrate your understanding.
Your task is to complete several web pages to search and view data relating to our SA Expiations database. But let's not leave things to the last minute
This assignment looks into a subset of the SA Expiations Database where you'll be digging through SA’s road rule breaches, turning raw data into something meaningful and interactive. But before you start hooning through code like a car on the open road, let's discuss approach. This assignment isn't a drag race; it's more like a scenic road trip. You'll need to take your time, enjoy the ride, and make regular pit stops to reflect and refine your work. You are expected to work on the project for at least 2 weeks to allow you time to investigate.
Alright, let's talk GIT – or as we like to call it, your “Expiation Logbook.” Just like you wouldn't drive without a license, you shouldn't code without tracking your every move. GIT isn’t just here to keep you in line – it’s your BFF on this journey. You must include a full development history of the project and be able to speak to and modify the code you developed or you will not receive marks for the assignment. Your commits should follow the steps outlines in the weekly practicals as you already know ViewModels and Detail Models along with changes to Views can’t be achieved in a single step. Fortunately, you have already used GIT before to make this easier.
You must have the following level of commits to obtain marks for the assignment:
The Speed Rush: No one likes getting caught speeding! Your commits should demonstrate that you’ve been working on this project over several days. If all your progress shows up in the last hour, it’s a red flag – and you know what that means. Steady progress is the way to avoid any late-night sirens.
Fatigue Avoidance: Trips are always better and more fun when broken up into small steps – we suggest approx. 10 lines of code or less. Complex aggregation queries should be shown as they were developed and not just magically “appear” like a speeder in the rearview mirror. That’s a ticket waiting to happen.
The Red Light Moment: Stopping at a red light is crucial – just like committing every time your LINQ or Lambda query works. Ignore it, and you might just find yourself in a crash when it breaks later.
ViewModel or Detail Model: the moment you create one, commit it. Modify it, commit it. Every time you complete a piece of functionality, it’s like signalling before a turn – let everyone know where you’re headed with a commit and the comment is telling us where you’re going. Skip this, and you’ll be causing confusion (and maybe a few crashes).
The Pothole Repair: Bugs and errors are the potholes in your coding journey. When you patch one up, commit it like you’ve just saved a low profile mag tyre from a nasty surprise. Celebrate the smooth ride ahead with a well-earned commit.
Tasks
A web application has already been created using the .NET Core MVC design pattern containing the Entity Framework and associated database models. Some Controllers and Views have already been created for testing purposes (Home, Offences). The project and Database Creation Script can be downloaded from the course website. Your task is to complete several pages with the necessary layout using the provided models, your own custom ViewModels, Detail Models in addition to, controller, HTML, bootstrap v5.x and @Razor code.
Task 1 [30%]: Ignite Your Search Engine!
For this task you will need to have a Controller Action + View to serve as your Search Starting Point. Start your engines and rev up your data skills! Choose one or more of these options and hit the road with an fast search:
Expiation Categories + Offences
Speeding Categories + Offences
Withdrawn Reasons + Offences
Photo Rejection Reasons + Camera Types and Codes
Local Service Areas + Country/State of Drivers and/or Registration
For this task you will need to implement:
1.A Turbocharged Search:
oLets start with an auto-complete text search or a drop-down list (or similar – see bootstrap doc)
oAdd an additional text search, powered by auto-complete suggestions.
2.A Custom ViewModel:
oTune up your ViewModel like a high-performance engine! Add those all-important decorations/annotations to make sure everything runs smoothly in your view. No ViewBag permitted!
3.A Detail Model:
oAdd a Detail Model that not only shows results but also packs in some serious aggregate stats based on the available data
Task 2 [30%]: Offences on the Radar!
For this task you will need to implement another Controller Action + View to view a more detailed breakdown of data relating to your previous search criteria. This view needs to use the Offences table with Expiations and your search selection from Task 1 to pull in the data and create a more detailed view.
For this task you will need to:
1.Merge Like a Pro:
oExecute precision JOINs between Offences, Expiations, and your chosen table, merging data seamlessly and efficiently
oCreate a search filter to restrict the data displayed and keep the page running smoothly.
2.Custom ViewModel:
oImplement a ViewModel with decorations/annotations to display your data in a pleasing way.
3.Detail Model:
oSummarise your data with dashboard of key insights from a detail model - totals, averages, frequency and more.
Task 3 [30%]: Caught in the Act - Expiation Insights Unveiled!
For this task you will need to implement another Controller Action + View to drill down into the Expiations and pull out the most fascinating stats. For this section you need to:
1.Complex Queries:
oEngage in some serious data interrogation with a complex queries. Craft a queries that goes beyond the basics—whether you’re tracking speeds, fines, or BAC levels, think about things like Min, Max, Avg Speed, BAC, fine amounts, or even the frequency of offences.
2.ViewModel:
oPass your data using a custom ViewModel that allows the user to interact with the data. Show off what you’ve uncovered in style.
3.Detail Model:
oNo aggregate info should be calculated in the View – it’s all to be done in the controller. Demonstrate your knowledge of LINQ and Lambda queries to populate your detail model and expose those law breakers!
Comitting Changes
Committing your progress is as easy as 1,2,3!
If your GIT window is not active, simply go to the GIT menu and select the “Commit or Stash” option.
Then:
1.Name your commit based on what you did
2.Commit the change!
3.
Submitting
Please ZIP your entire contents of your solution folder and upload to LearnOnline. This folder must include your .sln file, your project directory, git directory and git support files as pictured. This is important:
Rubric Marking Guide (per task):
Do not use .Include() in an query except when loading a single related record.
High Distinction (HD):
One or more animated graphs for Each Task: A sleek looking D3 graph (version as specified in practicals) that clearly shows the aggregate information on the graph via axes and either tooltips on the graph or in a sleek compact table format beneath.
Masterful Queries: Your LINQ/Lambda queries are fast, efficient and powerful. Well crafted, demonstrating experimentation with conditional statements around aggregates. LINQ/Lambda queries demonstrate thought and include aggregate and sub-queries to provide additional and useful information.
Top-Tier Presentation: Your views are polished, your models are tight. Use Bootstrap V5.3 perfectly and your work looks consistent and professional.
Meets the criteria of a Distinction
Distinction (D):
Aggregate Mastery: You’ve aggregated data like a pro, custom Detail Models that showcase your skills. Details Models that contain Decorators – including formatting where appropriate. These should be reflected in the Views.
Sleek Queries: LINQ/Lambda Queries are optimised, well crafted, demonstrate efficient joins and aggregate data collection.
page structure shows in-depth knowledge and thought of functionality. HTML is optimised to reduce errors and improve user experience using Tag Helpers.
Meets the criteria of a Credit
Credit (C):
ViewModel Victory: You’ve successfully created and used ViewModels to express your data in the views.
DetailModel: You’ve detailed the car but it has a few dents – solid performer, just a little rough around the edges.
Solid LINQ/Lambda: Your queries are solid, getting the job done and incorporate search parameters and basic aggregate attempts.
Good bootstrap implementation and some investigation of bootstrap documentation. Basic usage of bootstrap utilities. Lambda/LINQ queries acceptable, somewhat optimised. Code quality basic including expected HTML Forms attributes with tag-helpers etc.
Pass (P):
Basic But Functional: Your page loads and searches work, even if they’re just cruising in the slow lane. Basic bootstrap implementation, basic LINQ/Lambda query implementation with ViewModels, very simplistic. Basic HTML and HTML Forms understanding using tag helpers.
Basic Querying: Your queries might be simple, but they’re on the right track.
Fail (F):
Hit the Brakes: The task isn’t complete or functional. Queries may have gone off-road, or the page might not load at all. Maybe the battery was flat. No detailed GIT history as outlined above or unable to explain code and make modifications during in-person assessment.
HTML Validation [10%]
Check that your final generated HTML is valid and does not contain any errors. You will need to run your page, then right click on it in the web browser and select “View Source” to check the html. Images should have custom alt text etc.
Late Submissions
No ifs, ands, or but-the-deadlines. Late submissions will not be accepted for this assignment.
Downloading the Database.
1.Create a new Database in MS-SQL called ExpiationsDB (or similar).
2.Locate the “Expiation DB Scripts” under the Assignment 1 tab.
3.Run the 1_LookupTables.sql queries to generate the lookup tables
4.> Check the number of records against the numbers published on the course page
5.Run the 2_ExpiationTable.sql query to make the Expiations table
6.Run each of the monthly data queries under the “3_Expiation Data 2024” to load the expiations table with data. NOTE: some of these files are large and will take time to execute. If your computer times out, you will need to highlight 3000-5000 rows of insert statements as necessary and execute them individually to get it working.
7.Run the Index Queries (note that you can choose indexes relevant to the tables you are using)
8.Over the next week, other years of expiations will be added to the list for interest only. As a minimum you need to load 2024 data, but you are welcome to try other data from 2023 etc to test Monthly breakdowns are functioning correctly etc and for your own interest :)
相关推荐
将Python爬取的数据导入钉钉多维表
摘要:本文介绍将Python爬取的数据导入钉钉多维表的完整解决方案。首先通过requests库爬取数据并解析为结构化格式,然后使用钉钉开放平台API对接多维表。关键步骤包括获取app_key、app_secret等凭证,通过OAuth2获取access_token,以及批量写入记录。文章详细说明了参数获取位置、字段类型匹配、权限配置等注意事项,并提供了错误处理建议和性能优化方法。适用于需要将网络数据同步到钉钉多维表的开发场景。
INFT 2064讲解 、辅导 C++, Java设计编程
TasksThen:3.SubmittingPass (P):Fail (F):
Python自动化批量识别化学分子结构——从图片到SMILES/SDF的实战指南
本文提供了使用Python自动化批量识别化学分子结构图片的实战指南。详细对比了基于Molvec API的在线快速方案与本地部署OSRA工具的两种路径,包含完整的代码示例、环境配置及优化技巧,帮助化学研究者高效地将图片批量转换为SMILES或SDF格式,显著提升数据处理效率。
告别规则黑盒:基于JVS-Rules的风控规则治理实践——可视化决策编排+血缘追踪+版本快照
可读’——通过决策流图谱与业务语义节点,让非技术人员理解逻辑;‘可溯’——依赖规则版本快照与执行日志,实现任意交易的全链路回放;‘可担责’——基于血缘追踪与权限基线,清晰界定业务定义、技术实现、合规验证三方责任。这三者共同构成风控规则治理的三角支柱,将隐性经验转化为可版本化、可审计、可协同的组织级数字资产。
ModbusRTU串口读写报文解析
解析MODBUS报文的格式,讨论异常状态、读多个寄存器与写多个寄存器
单片机通信总述——理论部分(CAN、串口、SPI、I2C等)
并行通信:传输原理:数据各个位同时传输;优点:速度快; 缺点:占用引脚资源多。是指使用 8、16、32 及 64 根或更多的数据线(有多少信号为就需要多少信号位)进行传输的通讯方式,可以同一时刻传输多个数据位的数据。串行通信: 传输原理:数据按位顺序传输;优点:占用引脚资源少; 缺点:速度相对较慢。是指设备之间通过一根数据信号线,地线以及控制信号线,按数据位形式一位一位地传输数据的通讯方式,同一时刻只能传输一位(bit)数据。 单工: 数据传输只支持数据在一个方向上传输。信息只能单方向传输的工作方式,一
把 KV Cache 压到 FP4:BitDecoding-FP4 的算法-系统协同设计复盘
长上下文推理卡在KV Cache的显存与带宽上,而现有FP4方案要么精度崩、要么速度废。这篇文章复盘BitDecoding-FP4如何用三个算法补丁加一个系统重构,在B300上把服务吞吐提升2.4–3.0倍,精度几乎不掉。
sklearn2pmml xgboost缺失值(missing)处理的坑
sklearn2pmml xgboost缺失值(missing)如何处理 今天同事在部署xgboost pmml模型时遇到了大坑,线上spark预测和本地python预测结果怎么都不对应,记录一下处理过程。 看了下同事的代码,貌似也没有问题 from sklearn2pmml import PMMLPipeline from sklearn2pmml import sklearn2pmml fro...
Git 工程化与内部原理完全指南:Hooks / LFS / 对象模型
本文深入解析 Git 工程化核心:通过理解内容寻址的对象模型与引用机制,掌握 Hooks(pre-commit、pre-push 等)实现自动化校验,借助 Husky 实现团队统一配置;使用 Git LFS 高效管理大文件,避免仓库膨胀;深入 .git 目录结构,理清 blob/tree/commit 三类对象与指针关系。强调“先自动化、再靠人”的工程原则,结合命令速查与实战 Checklist,助开发者从“会用”跃升至“懂它、能改造它”的境界。
DMTF相关协议(一):Redfish和SMBIOS
Redfish 是一种管理标准,使用超媒体 RESTful 接口中的数据模型表示。该模型以标准的、机器可读的模式表示,消息的有效负载以 JSON 表示。该协议本身利用了 OData v4。由于它是一个超媒体 API,因此能够通过一致的接口表示各种实现。它具有管理数据中心资源、处理事件、长时间任务和发现的机制。
WindTerm 安装使用教程
WindTerm是一款Github上开源的 SSH 终端工具,它是完全可以比肩MobaXterm工具的。
Windows 11 WSL2 网络代理连接问题排查与完整解决方案
针对 Windows 11 下 WSL2 无法连接宿主机代理及 Connection refused 报错,先通过 .wslconfig 开启 镜像网络模式(mirrored) 与 自动代理(autoProxy) 打通网络环境。随后按需二选一配置桌面代理客户端:日常开发推荐开启 Allow LAN(允许局域网连接) 配合系统代理,轻量且免管理员权限;针对无视环境变量的终端工具,则以管理员身份开启 TUN 虚拟网卡模式 底层接管流量,即可实现 WSL 顺畅联网。
寻路最终版哦
相信大家用unity3d寻路的时候,一定会碰到多人
多存储协同架构:JPA + MyBatis + Elasticsearch + Redis 的职责分工与通用实现
本文阐述了在高并发订单系统中,通过JPA、MyBatis、Elasticsearch与Redis的多存储协同架构实现职责分离:JPA负责事务性写操作与简单查询;MyBatis处理复杂联查与报表统计;Elasticsearch承载海量数据下的多维检索与聚合;Redis用于缓存、防回滚暂存及分布式锁。各存储分工明确,通过异步同步机制联动,兼顾一致性、性能与扩展性,构建高效稳定的系统架构。
文档:亲测可用解决vnc灰屏,黑屏,鼠标大黑叉情况
主要解决vnc-viewer灰屏,黑屏,鼠标大黑叉等现象,详细见文档。
Data-Structures-and-Algorithm-Analysis-in-Java.pdf
作者: Weiss, Mark A. 出版社: Addison Wesley Data Structures and Algorithm Analysis in Java is an “advanced algorithms” book that fits between traditional CS2 and Algorithms Analysis courses. In the old ACM Curriculum Guidelines, this course was known as CS7. This text is for readers who want to learn good programming and algorithm analysis skills simultaneously so that they can develop such programs with the maximum amo...
Elasticsearch 9.x 从入门到精通(5/7):集群、分布式与运维
《Elasticsearch 9.x 从入门到精通》共 7 篇,本篇为第 5 篇,覆盖第 21~26 章。:Elasticsearch 9.x 源码 main 分支()与官方全量文档。:每个知识点标注官方文档出处,涉及实现原理均给出源码锚点路径:行号,禁止编造 API。
Statistics and Machine Learning Toolbox
Statistics and Machine Learning Toolbox(带书签),MATLAB统计学习工具
Elasticsearch 9.x 从入门到精通(1/7):初识 Elasticsearch
官方定义(开篇):身份能力对应源码模块分布式搜索/分析引擎近实时全文检索、聚合分析index/可扩展数据存储海量文档存储、快照、生命周期cluster/向量数据库kNN 语义检索、混合检索(kNN)+x-packElastic 官方将能力组合为四类"解决方案"():Elasticsearch(搜索)、Elasticsearch Vector Database(向量/Serverless)、Observability(可观测)、Security(安全)。核心搜索能力在所有形态中共用。
数学建模模型总结
这是本人在两年内准备参加数学建模竞赛搜集到的模型资料,已经经过了本人的筛选和整理,希望能够对准备参加数学建模竞赛的学弟学妹们提供一些帮助!
使用 SpiceDB 为 Elasticsearch 检索增强生成实现细粒度授权
本文介绍如何在Elasticsearch检索增强生成(RAG)流程中实现细粒度访问控制。通过SpiceDB基于关系的访问控制(ReBAC),将权限逻辑从应用代码和kNN查询中剥离,转为在关系图中管理用户与文档间的权限。利用SpiceDB在检索后过滤内容块,确保大语言模型仅接收授权数据,防止敏感信息泄露。该方案支持灵活的逐文档共享、跨部门访问及例外授权,无需重构角色或重新索引。结合LangGraph构建确定性授权节点,强制执行安全边界,抵御提示注入攻击。推荐生产部署时采用超额检索、元数据预筛选与权威数据源同步
点过“不再询问”就要检查:Claude Code权限文件也可能存着密钥
Apiiro报告揭示带密钥的命令可能进入Claude Code权限文件。结合独立Git实验,解释local配置、忽略规则与历史泄露的区别,以及发现问题后的处理顺序。
Elasticsearch 9.x 从入门到精通(4/7):聚合分析与文本分析
analysis.*定义组件和 analyzer,mapping 把 analyzer 绑到字段。},},},},},"title": {先测试组件,再绑定字段。用_analyze验证 token,不要只靠真实查询猜。text 与 keyword 并存。排序、聚合用keyword子字段,全文检索用 text。stemming 与精确展示分离。索引 stemming token,展示仍用_source原文。stop words 谨慎。
【一次 Elasticsearch 高基数聚合慢查询的定位与优化】
当Elasticsearch聚合查询首次执行慢、后续迅速恢复正常时,问题往往不在数据量本身,而在于全局词典构建开销。通过Profile分析发现,虽聚合耗时仅几十毫秒,但首次请求整体耗时达1秒以上,表明瓶颈在初始化阶段。结合keyword字段使用Doc Values的特性,可推断为首次访问时需加载全局词典(global ordinals),导致延迟。开启eager_global_ordinals可将词典预加载至内存,显著降低首次查询延迟,尤其适用于高基数聚合场景。此案例揭示了“首次慢、后续快”问题的典型根因及
如何用 STAROps Elasticsearch 智能助手看穿“搜索变慢”
某电商平台的商品搜索服务使用一台 6 个数据节点的 Elasticsearch 实例。周五北京时间 20:00 起,业务陆续反馈搜索变慢。业务监控中的搜索接口 P99 从平时约 200 ms 升到 2s 以上,部分请求超时。值班工程师打开控制台:集群状态为 Green,没有未分配分片,集群平均 CPU 约 40%,乍看不像资源已经吃紧。
Git撤销修改三重境界:从工作区到版本库全解析
区域英文说明工作区你直接编辑文件的地方,肉眼可见的代码。暂存区执行git add后,代码进入的区域。版本库Repository执行git commit后,代码被永久存储的区域。什么是撤销修改?当你在工作区写了一段时间代码,发现新代码质量极低,甚至无法继续开发时,将代码恢复到上一个提交版本(那个干净、整洁的版本),基于旧版本重新开发,这个回退操作就称为撤销修改。它能保证效率,也能避免烂代码污染项目。问题现状你的位置选择命令注意事项只在文件中改了,没add场景一--不可省略,别手动删。已。
[git]一次 Git push review 导致 Mac 卡死:10GB 仓库、自动 repack 与大文件 delta 压缩
日期:2026-11-15环境:macOS / Git 2.54.0 (Apple Git-157) / 24GB RAM / 12 CPU+ 子模块(Gerrit 评审流程)
Qwen2.5_PyQt5_情感分析桌面应用实战
使用 Git LFS 下载模型权重;使用 Transformers 在本地加载 Qwen;正确截取模型新生成的 token;使用 Qt Designer 制作桌面界面;在 Python 中连接信号与槽;使用后台线程避免界面卡死。对初学者来说,最容易混淆的是“界面”和“功能”的关系。这一句就是界面与程序逻辑之间的桥梁。完成这个项目后,还可以继续增加批量评价分析、结果导出、情感统计图、模型切换和历史记录等功能,把一个简单演示逐步扩展成真正可用的本地 AI 工具。
ElasticSearch vs MySQL:短链接服务中
在当今互联网中,短链接服务已成为许多应用场景的重要工具,例如社交媒体、广告推广、数据分析等。而面对海量数据的存储与高效检索需求,系统设计时常常面临一个关键问题:使用 ElasticSearch 还是 MySQL?本文将通过短链接服务的案例,从数据结构、查询性能、可扩展性等多个维度出发,对比分析两者的技术实现与适用场景,并为零基础开发者或在校学生提供清晰的选型建议。
用 Python 审计 git worktree:分支锁报错与残留记录实测
同一个仓库并行跑三个任务,给每个任务开一个 git worktree 最省事:多个目录共享一份 .git 对象库,各有独立 HEAD 和索引。真动手会撞两个卡点:在 B 目录检出 A 目录占用的分支,
2131



被折叠的 条评论
为什么被折叠?



