writing queries and creating database using create statement nd insert data into those tables uising insert command
## Deliverables
create database as per the specification
## Platform
1. Create Statement (2 marks)
1 mark for creating all the tables (90% correct should be given 1 mark; 60% correct 0.5 mark otherwise no mark)
1 mark for correct constraints, such as primary key, foreign key (90%, 1 mark; 60% correct 0.5 mark otherwise no mark)
2. Insert Statement (2 marks)
For over 90% successful insert statement, give 2 marks.
Otherwise: 75%: 1.5 marks, 50%: 1 mark, 25%: 0.5 mark
3. Query (15 marks)
There are 15 SQL questions in total. I will repeat some common requirements of output formatting:
Name of people should be printed as GivenName FamilyName (e.g. John Smith) in a column labelled NAME
Addresses should be printed as Street, Suburb State Postcode (e.g. 123 Anzac Pde, Maroubra NSW 2038)
Each SQL worths 1 mark.
Mark given for each query: 0, 0.3, 0.7, 1
4. Documentation (1 mark)
This is about the document presentation. Does the document include everything? Is the document well presented?