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 :)
相关推荐
AI 模型训练核心方法论:零基础也能落地的 8 个关键阶段
本文是为 AI 零基础学习者打造的模型训练入门指南,以生活化语言拆解核心概念,规避专业术语壁垒。内容先通俗阐释模型训练、监督学习、数据集划分等基础概念,再按问题定义、数据准备、模型选择、环境搭建、训练、评估、调参、部署 8 个阶段,拆解完整训练流程,搭配 PyTorch 代码示例与实战案例,同时提供资源预算、常见问题解决方案及学习路径。指南强调数据的核心重要性,推荐新手优先使用迁移学习和免费 GPU 资源,兼顾理论与实操,帮助学习者快速上手,避开训练误区,独立完成从模型搭建到部署的全流程。
INFT 2064讲解 、辅导 C++, Java设计编程
TasksThen:3.SubmittingPass (P):Fail (F):
DAP-Link DIY复刻指南
DAP-Link是ARM开源的一个项目,主要用于代码下载以及调试,支持SWD和JTAG调试接口,对于开发嵌入式的同学相信都或多或少有所耳闻。除了DAP-Link之外还有很多同类型的调试器,如ST-LinkJ-Link,但是这些都是不开源的,无法复刻或进行二次开发。但DAP-Link不同,完全开源,不用担心侵权问题,且随着开源社区大家的共同努力,DAP-Link经过了不断的迭代,先如今已取代ARM之前推出的CMSIS-DAP开源项目。
告别规则黑盒:基于JVS-Rules的风控规则治理实践——可视化决策编排+血缘追踪+版本快照
可读’——通过决策流图谱与业务语义节点,让非技术人员理解逻辑;‘可溯’——依赖规则版本快照与执行日志,实现任意交易的全链路回放;‘可担责’——基于血缘追踪与权限基线,清晰界定业务定义、技术实现、合规验证三方责任。这三者共同构成风控规则治理的三角支柱,将隐性经验转化为可版本化、可审计、可协同的组织级数字资产。
全球半导体设备氧化钇熔射服务行业规模预测:预计未来六年CAGR为7.8%
本文将对“半导体设备氧化钇熔射服务”行业进行深度分析,探讨市场趋势的演变、核心竞争者的战略布局、供应链结构的内外特点、研发创新的最新进展、法规政策环境的适应性调整以及投资机会与风险评估。这一稳健的增长趋势表明半导体设备氧化钇熔射服务在电子行业中的重要性逐渐增强。由于全球对于高效、高精度和可靠的电子解决方案的需求增加,对能够提供这些功能的半导体设备氧化钇熔射服务的需求日益增长。由于半导体设备氧化钇熔射服务主要为就地服务型,其“配送”主要依赖于专业团队和技术设备的及时调配,强调服务的时效性和高质量。
慕课软件质量保证与测试(习题集)
慕课金陵科技学院.软件质量保证与测试.期末复习.习题汇总0 总目录1 绪论1.1 软件质量保证与测试的产生与发展1.2 软件缺陷,软件错误,软件故障1.3 软件质量保证与测试的意义,原则和挑战1.4 单元测试1.5 课后作业2 软件测试策略2.1 软件测试的模型,过程和生命周期2.2 软件测试的方法和技术2.3 单元测试2.4 课后作业3 黑盒测试3.1 黑盒测试概述3.2 等价类划分测试3.3 边界值测试3.4 错误推测法3.5 判定表驱动法3.6 因果图法3.7 场景法3.8 正交实验法3.9 单元测试
把 KV Cache 压到 FP4:BitDecoding-FP4 的算法-系统协同设计复盘
长上下文推理卡在KV Cache的显存与带宽上,而现有FP4方案要么精度崩、要么速度废。这篇文章复盘BitDecoding-FP4如何用三个算法补丁加一个系统重构,在B300上把服务吞吐提升2.4–3.0倍,精度几乎不掉。
Win11更新导致TIA博途许可证出现问题的解决办法汇总
Win11更新导致TIA博途许可证出现问题的解决办法汇总
Git 工程化与内部原理完全指南:Hooks / LFS / 对象模型
本文深入解析 Git 工程化核心:通过理解内容寻址的对象模型与引用机制,掌握 Hooks(pre-commit、pre-push 等)实现自动化校验,借助 Husky 实现团队统一配置;使用 Git LFS 高效管理大文件,避免仓库膨胀;深入 .git 目录结构,理清 blob/tree/commit 三类对象与指针关系。强调“先自动化、再靠人”的工程原则,结合命令速查与实战 Checklist,助开发者从“会用”跃升至“懂它、能改造它”的境界。
基于STM32的多功能旅行箱_329
随着智能硬件技术的不断发展,智能化产品逐渐渗透到日常生活的各个领域。旅行箱作为出行必需的工具,其传统功能已无法满足现代用户的需求,尤其是在安全性、便捷性和智能交互方面。为了解决这一问题,本设计基于STM32单片机开发了一款多功能智能旅行箱,集成了移动防盗报警、语音寻箱、GPS定位、称重检测、手势控制和蓝牙通信等多项功能。通过STM32F103RCT6主控芯片与HC-05蓝牙模块进行通信,结合海凌科V20语音识别模块、ATGM336H-5N GPS模块和HX711称重模块,提供了全方位的智能化体验。
【32】C# WinForm入门到精通 ——打开文件OpenFileDialog 【属性、方法、事件、实例、源码】
本文介绍了WinForm开发中OpenFileDialog控件的关键属性及其应用。OpenFileDialog是.NET Framework提供的文件对话框控件,主要用于选择、打开文件操作。文章详细讲解了11个核心属性:AddExtension(自动补全扩展名)、AutoUpgradeEnabled(外观升级)、CheckFileExists/CheckPathExists(文件/路径存在验证)、DefaultExt(默认扩展名)、DereferenceLinks(解析快捷方式)、FileName/File
Windows 11 WSL2 网络代理连接问题排查与完整解决方案
针对 Windows 11 下 WSL2 无法连接宿主机代理及 Connection refused 报错,先通过 .wslconfig 开启 镜像网络模式(mirrored) 与 自动代理(autoProxy) 打通网络环境。随后按需二选一配置桌面代理客户端:日常开发推荐开启 Allow LAN(允许局域网连接) 配合系统代理,轻量且免管理员权限;针对无视环境变量的终端工具,则以管理员身份开启 TUN 虚拟网卡模式 底层接管流量,即可实现 WSL 顺畅联网。
基于simulink 的不间断电源ups的项目实例
UPS系统的核心组件包括整流器、逆变器、电池管理系统和控制系统。- **Three-Phase Controlled Rectifier**:设置触发角为0度,用于控制整流器的输出电压。- **Three-Phase Inverter**:设置逆变器的输出频率为60Hz,用于将直流电转换为交流电。- **Control System**:编写MATLAB函数,用于监测市电状态并控制各模块的工作模式。- **Step**:设置阶跃时间,例如0.05秒,阶跃前后的值分别为0和1,用于模拟市电中断。
多存储协同架构:JPA + MyBatis + Elasticsearch + Redis 的职责分工与通用实现
本文阐述了在高并发订单系统中,通过JPA、MyBatis、Elasticsearch与Redis的多存储协同架构实现职责分离:JPA负责事务性写操作与简单查询;MyBatis处理复杂联查与报表统计;Elasticsearch承载海量数据下的多维检索与聚合;Redis用于缓存、防回滚暂存及分布式锁。各存储分工明确,通过异步同步机制联动,兼顾一致性、性能与扩展性,构建高效稳定的系统架构。
文档:亲测可用解决vnc灰屏,黑屏,鼠标大黑叉情况
主要解决vnc-viewer灰屏,黑屏,鼠标大黑叉等现象,详细见文档。
Probability and Statistics - 4th edition
Probability and Statistics - 4th edition
Elasticsearch 9.x 从入门到精通(5/7):集群、分布式与运维
《Elasticsearch 9.x 从入门到精通》共 7 篇,本篇为第 5 篇,覆盖第 21~26 章。:Elasticsearch 9.x 源码 main 分支()与官方全量文档。:每个知识点标注官方文档出处,涉及实现原理均给出源码锚点路径:行号,禁止编造 API。
温度PID控制PLC程序
温度PID稳定控制程序,适用于欧姆龙PLC,对其他PLC也具有很大参考价值
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 目录占用的分支,
469



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



