assess your knowledge of business requirements, database design and normalisation

Charles Sturt University Subject Outline ITC114 201430 S I-12 February 2014-Version 1 Page 14 of 24 1. 2. 1. 2. 3. Assessment item 3 Online Quiz 2 Value: 5% Due date: 27-Apr-2014 Return date: 18-May-2014 Submission method options Alternative submission method Task Complete the online quiz on Topics 3, 4 and 5 in the ITC114 Interact Test Centre. Rationale This assignment will assess your knowledge of business requirements, database design and normalisation. Marking criteria This assignment is a series of multiple choice questions. Each correct answer will score 1 mark. Marks will not be deducted for incorrect answers. Assessment item 4 Create and query databases using SQL Value: 20% Due date: 25-May-2014 Return date: 15-Jun-2014 Submission method options Alternative submission method Task Part A: SQL Queries (50 marks) Use the ClassicModels database (ClassicModels.sql) from the ITC114 Interact Resources site. Answer the following queries from that database. You are required to submit: The appropriate SQL statements for each query, which should be copied from your SQL code in MySQL and pasted into your submission file; and Screenshots of the resultant tables which are to be pasted into your submission file immediately after the SQL code for that query. Typing or manually drawing the results is NOT acceptable. NOTE: Your SQL code should be correct for any data, not just any sample data that you create. Write SQL SELECT statements to retrieve the following information from the ClassicModels database: Select the product name, scale, vendor and product code for all models of classic cars built between 1948 and 1966. Display the results in order of manufacture. (5 marks Select the product name, scale, vendor and product code for all models of Vintage cars built before 1930 and with a scale smaller than 1:20. Display the results in order of manufacture. (5 marks) Charles Sturt University Subject Outline ITC114 201430 S I-12 February 2014-Version 1 Page 15 of 24 3. 4. 5. 6....