DTS207TC Database Development and Design

Database Development and Design (DTS207TC)Python TitleDatabaseandDesignDTS207TC001:AssessmentTask1 (CWSubmissionDeadline23:59,15thDecFridayFinal WordCountNOTE: 阅读详情


XJTLU Entrepreneur College (Taicang) Cover Sheet
Module code and Title Database Development and Design (DTS207TC)
School Title School of AI and Advanced Computing
Assignment Title 002: Assessment Task 2 (CW)
Submission Deadline 23:59, 24th Dec (Friday)
Final Word Count NA
If you agree to let the university use your work anonymously for teaching
and learning purposes, please type “yes” here. Yes
I certify that I have read and understood the University’s Policy for dealing with Plagiarism, Collusion and the Fabrication of Data (available on Learning Mall Online). With reference to this
policy I certify that:  My work does not contain any instances of plagiarism and/or collusion.  My work does not contain any fabricated data. By uploading my assignment onto Learning Mall Online, I formally declare
that all of the above information is true to the best of my knowledge and
belief. Scoring – For Tutor Use
Student ID
Stage of
Marking
Marker
Code
Learning Outcomes Achieved (F/P/M/D)
(please modify as appropriate)
Final
Score
C D
1
st Marker – red
pen
Moderation
– green pen
IM
Initials
The original mark has been accepted by the moderator
(please circle as appropriate):
Y / N
Data entry and score calculation have been checked by
another tutor (please circle):
Y
2
nd Marker if
needed – green
pen
For Academic Office Use Possible Academic Infringement (please tick as appropriate)
Date
Received
Days
late
Late
Penalty
☐ Category A
Total Academic Infringement Penalty
(A,B, C, D, E, Please modify where
necessary) _____________________ ☐ Category B
☐ Category C
☐ Category D
☐ Category E
Database Development and Design (DTS207TC)
Assessment 002: Individual Coursework
Due: Dec 24
th
, 2024 @ 23:59
Weight: 40%
Maximum Marks: 100
Overview & Outcomes
This course work will be assessed for the following learning outcomes:
C. Illustrate the issues related to Web technologies and DBMS and XML as a semi-structured
data representation formalism. D. Identify the principles underlying object-relational models. Submission
You must submit the following files to LMO:
1)A report named as Your_Student_ID.pdf. 2)A directory containing all your source code, named as Your_Student_ID_code. NOTE: The report shall be in A4 size, size 11 font, and shall not exceed 8 pages in length. You
can include only key code snippets in your reports. The complete source code can be placed in
the attachment. Assessment Tasks
Now we have some stock-related datasets in XML format (attached). We would like to put it on
a website for users to query. 1) Browse through these XML files in the attachment, and define DTD and XML Schema for
them. Use both definitions to validate the XML files and manually fix any potential errors. Extract the file headers from the XML Schema and convert the XML to CSV. Open the
generated CSV with any editor and take a screenshot. (20 Marks)
2) Use flask_sqlalchemy in Flask to build an ORM for the CSV from task 1), and import the
data into PostgreSQL. Manually draw an Entity-Relationship diagram for the three tables, take a photo, and include it in the report. (20 Marks)
3) Use Flask to implement the required web page as shown in the diagram, which includes a
table with the necessary fields. To differentiate yourself, you can set the form style to your
preference and take a screenshot. (20 Marks)
4) Based on task 3), add filtering functionalities for stock name, start time, and end time,
implementing a page as shown below. Note that one or more of these filter conditions can
be empty, meaning no filtering based on that condition. To differentiate yourself, you can
set the form style to your preference and take a screenshot. (20 Marks)
5) Use the provided testing program to perform a performance test on task 4). The program
uses a POST request to query with all conditions set to empty, which should return the full
result set. As long as the returned content is correct, you can optimize performance in any
way. Take a screenshot of the test results. Ideal performance should be no higher than 0.2
seconds per query. (20 Marks)
NOTE:
a. Provide a brief introduction to the program logic in your own words; including code
snippets is encouraged, but please do not directly paste the entire program into the report
without explanation;
b. For your full academic development, the use of generative AI to gain inspiration is allowed
for this assignment; however, out of mutual respect, please do not directly paste its output into
your assignment and submit it;
c. To prove that you have indeed completed this assignment and did not rely solely on
generative AI, please provide screenshots of the running results for each task.
Marking Criteria
The tasks in this assessment can be divided into 3 categories:
 Charts Presentation & Analysis;
 Essay;
 Programs. Criteria(%) Exemplary
(100)
Good
(75)
Satisfactory
(50)
Limited
(25)
Very Limited
(0)
Design Provides a
detailed, accurate
description of
the methods. Provide
comprehensive
comparison
between the
methods,
including pros
and cons, performance
analysis.
The analysis
provided
demonstrates
that the
student's
understanding
of the various
methods is
correct and
that they have
the ability to
solve problems
independently. Although there
are certain
flaws, or
incomplete.
Provides
adequate
description of
the methods. Comparison is
provided with
some level of
details, however, with
some obvious
mistakes.
There are obvious
deviations in the
understanding of
the main
methods, and it
fails to reflect the
ability to
independently
design
algorithms. The
description of the
problem is vague, or the thought is
incomplete.
Limited or no
description of
methods. Limited
comparison
provided.
Programs Demonstrated
correctly
implemented
code that
produces
correct output. Excellent
coding quality
follows best
practices.
The program
runs correctly
and gives the
expected
results. However, special cases
are not fully
considered, or
the program
performs
redundant
calculations.
Program
basically
works
correctly for
major
functionality, however, with
some
conceptional
problems.
The program
implements some
minor
functionality, or
incorrectly
implements
major
functionality. There is a certain
degree of
misunderstanding
about the
requirements of
the questions.
Program
works
incorrectly
with limited
attempt or
irrelevant to
the task.
Charts
Presentation
& Analysis
Excellent
quality of
report with
clear structure, clear logic, Most of the
results in the
chart are
correct, but
there is a
Moderate
quality of
report with
basic
structure, Only some of the
results in the
chart are correct, or some of them
are not filled in.
Limited or no
attempt of
report.
concise writing, pleasing visual
aids. certain degree
of sloppy or
wordy in the
overview and
analysis. where writing
and visual aids
can be
improved. The analysis of
the results was
obviously biased. The mark allocations for the above tasks are:
Task Design Programs Charts Presentation &
Analysis
1 0 17 3
2 15 5 0
3 10 5 5
4 0 15 5
5 10 8 2

【信息科学与工程学】【数据中心】第三十二篇 云数据中心的计算/存储/网络的核心挑战01 状态方程: SOCk+1​=SOCk​−Qn​ik​Δt​;: 三相电流变换到αβ坐标系: iα​=32​​(ia​−21​ib​−21​ic​), iβ​=32​​(23​​ib​−23​​ic​). 计算瞬时有功功率p和无功功率q,经低通滤波器分离直流分量,反变换得基波电流,差值即为谐波指令。: 节点i的信念 bi​(xi​)=ϕi​(xi​)∏j∈N(i)​mji​(xi​), 消息 mij​(xj​)=∑xi​​ϕi​(xi​)ψij​(xi​,xj​)∏k∈N(i)\j​mki​(xi​). 阅读详情

相关推荐

2024从零开始使用VSCode编程(静态页面制作篇)HTML+CSS+JS阶段

VSCode第一个前端静态页面的编写

ssrsrrn的博客 9593

如何起草企业标准

企业在确定生产项目或准备开发新产品项目之前,应首先做好市场调研,对产品项目作可行性分析,并尽可能收集相关法规文献和技术资料,起码应了解国内是否有该产品的技术标准,再确定如何制定产品的企业标准。对这类已有上级标准的产品,应该转化成等同上级标准的企业标准,或者转化成高于上级标准的企业内控标准来执行组织生产。有的企业标准在国家标准发布之前,已按程序备案并在实施,这些企业标准在不与上级标准抵触的原则下,在标准的有效期内仍可执行。重要指标与上级标准不相符的,应废止该企业标准,依照新的上级标准重新制定企业标准。

li13325129735的博客 10万+

三菱 FX5U PLC 4轴程序 控制松下伺服3个, 步进电机一个

三菱 FX5U PLC 4轴程序。 控制松下伺服3个, 步进电机一个, 四轴自动堆垛码垛设备程序, 回原点动作用专用的原点回归指令写的, 手动运行用三菱相对定位指令写的 , 自动运行用绝对定位指令写的取料运行, 表格定位写的自动放料运行, 设备各种报警异常都有写出 程序每一步都有注释。 包括PLC程序、显控触摸屏 程序、松下伺服驱动器接线图。 程序内都有IO注释 编号:4816635519484681汇美0808 ...

m0_68069172的博客 3382

恶意网站http://www.chaxun.com,近日不断受到这个无耻网站的弹出广告骚扰(已找到解决方法)

弹出窗口的网址有如下两个:www.myip.cn和www.chaxun.com强忍怒火,去这两个网址看个究竟,原来就是下边这么弱智:screen.width-500)this.style.width=screen.width-500;" border="1" alt=""/>如果点击弹出窗口内的内容,将会访问到其他一些垃圾网站(估计是前者的客户)这个弱智网站,他们这种无耻行径,只会落得早日归天。下

小小草草的家家 4万+

从DIY到实战:手把手教你搭建一个媲美吉时利2450的nA级电流源表(附原理图与避坑指南)

本文详细解析如何从零打造nA级精密电流源,涵盖核心设计原理、PCB布局技巧、热电偶效应应对及校准验证体系。通过低成本替代方案和优化设计,实现媲美商用源表的性能,特别适合硬件爱好者和独立开发者。文章还提供原理图与避坑指南,助你轻松搭建高精度电流源系统。

weixin_42656416的博客 295

通信算法之267 : DJI无人机 云哨 DroneID 640ms

消费级无人机可以用于高级航拍、物流和人道主义救援等等。但是其广泛使用给安全、安保和隐私带来了许多风险。例如,攻击方可能会使用无人机进行监视、运输非法物品,或通过侵入机场上方的封闭空域造成经济损失。为了防止恶意使用,无人机制造商采用多种对策来强制安全可靠地使用无人机,例如对速度和高度施加软件限制,或使用地理围栏实施禁飞区。作为对传统对策的补充,市场领导者大疆(DJI)为无人机实施了一种称为 DroneID 的跟踪协议,该协议旨在将无人机及其操作员的位置传输给授权实体,例如执法部门或关键基础设施的运营商。

leegang12的专栏 3311

C语言的奇技淫巧(1-50)

01. 宏定义用do{}while(0) 如果定义的宏函数后面有多条语句,使用这样的方式会有问题: #define FUNC() func1(); func2() if(bRunF) FUNC(); 展开宏定义后会变成: if(bRunF) func1(); func2(); 逻辑就不对了。可以用这一的方式解决,非常好用: #define FUNC() do{func1(); func2();}while(0) 02. 数组的初始化 假如给arr的第2~6元素初始化为5,也

嵌入式软件实战派 1万+

详述 MIMIC 数据库26张数据表(一)

作者按照自身理解和实验要求对MIMIC-III的26张数据表进行整理归纳并进行介绍。

越努力 越幸运 7237

C89 C99 C11差异

C89 C99 C11差异

GBEDC的博客 27万+

YOLOv8 PCB缺陷检测系统全流程实战:从开发到UI展示详解

毕设路上难免有波折,但只要跟着这个教程把“数据集处理、模型训练、UI开发”每一步都落实,你就已经超越了大多数同学。这个“PCB缺陷检测系统”既有技术深度(YOLOv8是工业级主流算法),又有工程价值(解决电子制造的实际痛点),还具备出色的可视化展示——这样的毕设,拿高分是水到渠成的事。

FJN110的博客 217

解决k8s核心组件calico pod资源不创建问题

解决k8s核心组件calico pod资源不创建问题 1.问题描述 由于K8S集群Master节点故障,导致calico网络组件虽然处于Running状态,但是一直无法准备就绪,如下图所示 calico-node-lpt7h运行在master节点,第一时间紧急处理方法就是将其pod删除,让K8S自动重建该pod,使整个集群快速恢复 但是就当我将calico-node-lpt7h pod删除后,该pod始终无法自建,就好像是从来没有这个pod似的 2.解决方法 期初排查时,我觉得可能是由于当前master

江晓龙的博客 4808

Linux-常见指令及对应选项

一篇文章带你了解Linux最常用的指令

qq_61167424的博客 1万+

药物相关 PK(药代动力) 、PD(药效)指标知识

PK代表药物的药代动力学,指的是药物在体内的吸收、分布、代谢和排泄等过程,包括药物的药代动力学参数如Cmax(最大血药浓度)、Tmax(最大血药浓度出现的时间)、t1/2(半衰期)、AUC(药物曲线下面积)等。PD代表药物的药效学,指的是药物与生物体相互作用所产生的药理效应,包括药物的药效学参数如EC50(半数最大有效浓度)、ED50(半数最大效应剂量)、Emax(最大效应)等。PD(Pharmacodynamics)则研究药物的药效学特性,如药物的作用机制、效力、最大疗效、最小毒性等。

weixin_42357472的博客 2万+

Database Development and Design (DTS207TC) Assessment Task 2

TitleDatabaseDesignDTS207TC)Computing2(CW)SubmissionDeadline23:59,24thDecNOTE:

talifinior的博客 637

NTscan扫描工具

ntscan是一个扫描器,可以扫描没有密码和弱密码的共享,先到配置文件中填写猜测的用户名和密码,扫描过程中右侧出现的是扫描日志。

计算机控制技术及应用

《计算机控制技术及应用》通过总结作者的科研成果和吸收国内外的先进理论、方法和技术,以计算机控制系统的网络化、开放化、智能化和集成化发展趋势为主线索,主要介绍计算机控制系统的基本概念和计算机控制系统的典型形式,计算机控制系统的数学描述与基本分析方法,以及数字PID控制器、最少拍控制系统、达林算法、状态变量设计法等设计方法及其各种改进算法。重点突出计算机控制系统输入输出通道接口的设计方法和典型控制系统的设计案例与实现方法等。

Database Development and Design (DTS207TC) Assessment 002: Individual CourseworkSQL

andDesignDTS207TCNOTE:Essay;Programs.Exemplary(100)Good(75)(50)Limited(25)VeryLimited(0)DesignProvidesadetailed,accuratethemethods.Providecomparisonmethods,includingprosandcons,analysis.Theanalysis。

competionty的博客 952

VC中sqlite的使用

在VC中对sqlite的使用,实现数据库大批数据的快速插入,读取数据库中的数据在ListCtrl中显示

Database Development and Design (DTS207TC) Assessment 001: Individual CourseworkPython

andDesignDTS207TCNOTE:Essay;Programs.Exemplary(100)Good(75)(50)Limited(25)VeryLimited(0)DesignProvidesadetailed,accuratethemethods.Providecomparisonmethods,includingprosandcons,analysis.provided。

competionty的博客 764

IDEA的使用指南

IDEA基于java的使用手册,可以最快速的上手,在使用中不断的丰富自己的使用技巧.

signature=e3020ad5caa17ee07f1f9c55b406f82e,yarn-error.log

Arguments:D:\Program Files\nodejs\node.exe D:\Program Files (x86)\Yarn\bin\yarn.jsPATH:C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v10.0\bin;C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v...

weixin_42515340的博客 2万+

Practice_17_07_基础STL

A_排序   输入一行数字,‘5’看为空格,将一行数字分为若干非负整数。对这些分割得到的整数从大到小排序输出 多组测试用例输入。 思路:字符输入,放到stack,遇5对stack字符处理然后放入快速队列,遇'\n'输出。   这题我wa了很多次,先是多个5连在一起的情况没有处理把两个连续的5中间的整数记成了0...后来又发现忘记考虑存在一行数字的结尾不是5的情况..... AC...

weixin_30902251的博客 3989

C语言基础 Day07 指针和字符串

指针和函数、指针和字符串、带参数的main函数

月仙儿的博客 5431

Fast Intersection of Sorted Lists Using SSE Instructions

转:http://highlyscalable.wordpress.com/2012/06/05/fast-intersection-sorted-lists-sse/   Intersection of sorted lists is a cornerstone operation in many applications including search engines and da...

iteye_5443的博客 1400

基础知识 -- 问答

01.Main函数是什么?在程序中使用Main函数有什么需要注意的地方? Q:程序的入口函数!函数名字不能改变;一个程序中有且只有一个Main函数。 02.CLR是什么?程序集是什么?当运行一个程序集的时候,CLR做了什么事情? Q:Common Language RunTime 公共语言运行时。  编译后代码的集合。(包括exe和dll)。 加载项目里所有的类到内存,并找到其

逺磊之博客专栏 5298

【C++11新特性】| 【07】兼容性大汇总

文章目录1、C++11与C++03的不兼容2、C++与ISO C不兼容的项目3、C++11弃用特性4、gcc编译选项 1、C++11与C++03的不兼容 1、C++11支持自定义的字面常量; 3、C++11引入了一些新的关键字:alignas、alignof、char16_t、char32_t、constexpr、decltype.noexcept、nullptr.static_ assert和 thread_local; 4、C++11引人了C99的新类型long long; 5、C++11和C99

weixin_45926547的博客 2023

signature=c5a6cb07ae88a17cbdb151c390a87255,Review of biological diagnostic tools and their applicati...

摘要:Biological diagnostic tools are becoming an increasingly important aspect of geoenvironmental problems. Modern geoenvironmental professionals must be able to both understand and exploit biological ...

weixin_39631301的博客 1998
上一篇: CS209A Stack Overflow
下一篇: COMP2046 POSIX API in Linux
wx____codehelp
博客等级 码龄2年 538粉丝 99原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值