43 lines
2.0 KiB
Markdown
43 lines
2.0 KiB
Markdown
Players.csv - The main player and character data Þle, which contains player character definitions, with customer and billing data.
|
||
Items.csv - Character inventory of weapons.
|
||
Combat.csv - Records the activity and results of battles between players.
|
||
|
||
1. Your initial E-R diagram (WEEK 8 – 30%)
|
||
You will provide two outputs:
|
||
|
||
1) An English paragraph given in a PDF Þle that describes your personal ERD and
|
||
2) your ERD (embedded in the PDF Þle). We will assess your ERD by reading your paragraph.
|
||
You will receive full mark if your paragraph matches to your ERD.
|
||
Otherwise we will reduce your marks based on the following rules:
|
||
a) For each participation constraint fault (-1.5%).
|
||
b) For each multiplicity fault (-1.5%).
|
||
c) For each notation/Symbol fault (-1.5%).
|
||
|
||
2. SQL DDL ( WEEK 9 – 30%)
|
||
You will provide a PDF Þle that contains your
|
||
Relational Schemas (RS),
|
||
Integrity Constraints (IC),
|
||
Normalisation reports for each RSs and
|
||
the DDL statements written in SQL.
|
||
|
||
You will receive full mark if
|
||
your RS and ICs matches with your ERD.
|
||
Otherwise, you we will reduce your mark based on the followings:
|
||
a) For each typo for SQL code (-0.6%).
|
||
b) Reporting wrong(or none) Normalisation level (for each table -1.5%).
|
||
c) For each IC mismatch (from ERD to ICs) and (from ICs to DDL) (-3%).
|
||
|
||
3. Java Library and SQL queries (WEEK 10 – 40%)
|
||
You will provide a PDF Þle that contains the English versions of your queries.
|
||
You will also provide a java library that reads CSV Þle and
|
||
builds required tables and answers the queries you provided.
|
||
You will receive full mark if your library successfully accomplishes these tasks.
|
||
|
||
Otherwise we will reduce your mark according to the following rules:
|
||
a) Not compiles (-40%).
|
||
b) Compiles but cannot populate tables (-20%).
|
||
c) Cannot read CSV Þles but read from other Þle format and populates tables (-0%).
|
||
d) For each SQL warning, error (-3%).
|
||
e) For each failed query (-3%).
|
||
f) Providing Relational Algebra statements (for each query) (+3%)
|