辅导 FIT9132 Introduction to Databases Assignment 1辅导 SQL语言

FIT9132 Introduction to Databases

Assignment 1 - ReadMore Community Library (RCL)

Assignment 1 Logical Checklist

Required Actions:

❏ Carefully checked the Marking Rubric in the assignment document so you are aware of the mark allocation

❏ Normalisation

❏ Normalised two forms (Library Catalogue and Borrowers Quarterly Report [two samples are provided for the Library Catalogue but only normalise each type of form. once]). Normalised each from UNF to 3NF, showing all stages and dependencies at each step (i.e. partial dependencies in 1NF, transitive

dependencies in 2NF, full dependencies in 3NF)

❏ included all candidate keys for each relation at 1NF

❏ Included all attributes shown on the forms

❏ Did not add any surrogate keys in normalisation

❏ Indicated PK's using underline of the PK attributes

❏ Completed attribute synthesis

❏ Logical Model

❏ Followed the unit logical model notation/requirements:

❏ Used Crow’s foot/Information Engineering notation for the logical model

❏ Does not show data types and sizes

❏ Does show legend on the logical model

❏ Does show a label for each relationship

❏ Added common prefix for all attributes in each relation (e.g. emp_no, emp_name)

❏ Added comments for all attributes (used comments in RDBMS)

❏ Added at least one surrogate key to the logical model and added an explanation of why chosen to the assumptions document

❏ No relation with more than two attributes in the key remains (if more than two, a surrogate must be added)

❏ Included all required check clauses and lookup tables

❏ Included FULL normalisation results (final 3NF) in the logical model - all relations and attributes

❏ Checked that the relation/attribute names in the normalisation document are

identical to the logical model relation/attribute names on your model

❏ For each relation, all attributes are shown on the diagram (no downward

pointing diamond displayed to show some attributes are hidden)

❏ Made sure there are no data anomalies in the final logical model (ie. all relations are in 3NF)

❏ Schema File

❏ Schema file has extension .sql

❏ Included DROP table commands at the head of the schema file

❏ Has not been edited other than to add a header (student details) and SPOOL/ECHO commands

❏ Captured run of schema file via SPOOL/ECHO commands

Required files have been pushed to the FIT GitLab server (at least 9 pushes of the model):

❏ rcl_normalisation source file (.docx in MS Teams) and final pdf on Git Lab

❏ rcl_logical.pdf (check this is your final model and produced via File - Print Diagram - To PDF File from within Data Modeller, do not use screen capture)

❏ rcl_model project folder, which includes:

❏ the .dmd file,

❏ and the folder of the same name

You must push this project folder at least nine times while you are drawing the model with the Oracle Data Modeler

❏ rcl_schema.sql

❏ rcl_schema_output.txt

❏ rcl_assumptions source file (.docx in MS Teams) and final pdf on Git Lab

❏ rcl_####_diary source file (.docx in MS Teams) and final pdf on Git Lab (#### replaced by group number)

Finally, 7 individual files have been submitted to Moodle:

❏ rcl_normalisation.pdf

❏ rcl_logical.pdf

❏ rcl_model.zip, which includes:

❏ the .dmd file,

❏ and the model folder.

You MUST ensure that the zip archive of the model is tested for completeness, i.e. includes both logical and relational models (unzipped and opened in a new location - see video: Preparing Files for Submission in ed)