Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: zz-x2580
ICT285 Databases Assignment 2 Marking Rubric
Part Criteria Mark
Q 1 (15 marks) ERD
15 marks on the following basis
– Created an efficient entity-relationship diagram showing the data requirements of the system. Demonstrated an adequate understanding of how to develop an ERD
– Diagram is complete and concise. Diagram is clear and readable.
– Demonstrated an excellent understanding of all elements of the scenario, and a high level of independent thought and critical thinking.
Things to look out for
– Appropriate legend
– Entities that will support the data requirements of the system
– Relationships specified in such a way so as to support the system requirements
– Full set of attributes required
– Cardinality and participation constraints are correct
– Does the design work?
– Assumptions
Q2
(5 marks)
Changes
explanation
5 marks
Q3
(15 marks)
Data dictionary
15 marks
Things to look out for
Lists the tables, the columns, their domains and any other constraints that apply as per the question’s instructions
-For each table: Table Name, Primary key, foreign key(s) and referential actions
-For Columns: Name, Domain, Required(?), Some brief description, Default value,
Domain characteristics
-Checking for inappropriate data types/lengths
-Check for really short or really long columns
Q4
Database
implementation
20 marks distributed on the following criteria:
Provided complete correct responses to all 5 parts of the question (a-e)
(20 marks)
Things to look out for
Q5
(25 marks)
SQL
(Transactions)
5 marks for each of the transactions
Provided all the SQL statements
Things to look out for
– Correct attributes given
– Correct use of commands
– Linkage
-Capitals used for command and Attribute type e.g. INSERT
– Correct concept in undertaking the questions
Q6
(20 marks)
SQL (VIEWS)
4 marks for each view
Provided all the SQL statements (viewA-viewE)
Views should Run correctly, and They have met the specifications.
Formatting and presentation
(5 marks*)
*Up to 5 marks may be deducted from the overall mark based on the following:
– Standard Font Size and Colour i.e., Arial/12.
– Formatting and layout: double line spacing, page number, separate sections, aligning paragraphs.
– Includes a title page and table of contents. Correct use of equations, footers, and headers.
– Good technical style, avoiding excessive jargon, grammar, and spelling.
Please note the following about the marking of this assignment: