daabase

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?