IT
2019,
2::302019118
PythonSQLitewebHTML
SQLitePython
HTMLIT
HTML3040HTML
moviesurveySQLitedumpsqlSQLite DB:actorscustomersactorsmoviesfavoriteactors:customersfavoriteactors
Table customerscustomerID27:
CRICOS 00213 j
1
JIT104IT2019
customerID INT6INT11VARCHAR30VARCHAR10 maritalstatus VARCHAR20, numberofcars INT11 numberofchildren INT11customerID
favoriteactors
Table favoriteactorsIDcustomerIDactoractor:
ID INT6 customerID INT6 actor VARCHAR100ID
CRICOS 00213 j
JIT104IT2019
givennamegivenname
PythonSQLHTML:;
HTML:
;
;
30 40;
1HTML30 4030 402popularity.py
420
CRICOS 00213 j
3
IT
2019,
1301Tom HanksSandra Bullock1Tom Hanks420420
88
1:5030 40Test02, p2
PythonSQLmoviesurveyPythonshowpopularitywebHTML
CRICOS 00213 j
4
IT
2019,
130401549
1previousnext Female Male 3040 HTML3040304030 403040
24 Female Male 3040 20popularity.py1
2:20
CRICOS 00213 j
5
JIT104IT2019
3:20Test01, p2
4:20
CRICOS 00213 j
6
IT
2019,
py
1.moviesurvey moviesurvey.sql
2.showpopularityPython,:a,,b,c
:
showpopularity20 4040 80, ,30Test03
:2040204040804080
:
HTMLHTMLHTML:
Test032040html test0340 80html Test03All.html
CRICOS 00213 j
7
IT
2019,
givenname1
3.HTML610
5:Test10, p2
4.30 50showpopularity
SQLite DBSQLitePythonPythonSQLite
customerscustomerfavoriteactorsPythonDB.sql
CRICOS 00213 j
8
IT
2019,
SQLfan
DBPythonHTML
popularitypy
1.showpopularitySQLiteHTML
2.Python
SQLSQL
showpopularityHTML
:
SQL4SQL
CRICOS 00213 j
9
IT
2019,
HTML2HTML
2HTML
HTML10HTML:
oan
oa
oa:
group;
group.
HTML10HTML:
;
oactors;oa;
oactors;HTML
Python2JIT104PythonHTML:
oclear;
;;
;
ocode;
;
CRICOS 00213 j
10
IT
2019,
::
CRICOS 00213 j
QUTQUTIC 2019
11