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 1**
2 15 5 0
3 10 5 5
4 0 15 5
5 10 8 2

請加QQ：99515681  郵箱：99515681@qq.com   WX：codinghelp