2.0 KiB
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.
- Your initial E-R diagram (WEEK 8 – 30%) You will provide two outputs:
- An English paragraph given in a PDF Þle that describes your personal ERD and
- 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%).
- 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%).
-
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%)