Entity Relationship Diagram in Crows Foot Notation (please use
[login to view URL] or similar software).
• Relational Schema – including all relationships and appropriate key notation
(please use [login to view URL] or similar software).
• Supplementary Design Requirements formatted as a data dictionary. The
following information can be used as a guide for the elements to be included:
o Table names and their data attributes and descriptions;
o Information on data type, length, format, acceptable values;
o The compulsory/optional nature of the attribute and if null values are
• Copies of SQL scripts and output to address the requirements in Part C (copied
from MySQL, do not embed links to .sql files):
o SQL queries/scripts in the SQL Query Panel;
o A summary of the executed MySQL statements including errors and
general status information displayed in the Action Output Panel; and
o The Results Grid or SQL View Panel showing the output results from
executed MySQL statements.
More details in chat