Specification Overview Aim: To implement part of a database application by first completing the database table definitions, then writing interactive SQL statements. Coursework Description See Attached at Page 4. Relationship to Formative Assessment All SQL Labs build towards this exercise, with each lab helping you to perform Transactions of Interest that contribute to building this solution. Labs include expected query results so you can ensure you get correct answers and perform a form of self-assessment. iuww520iuww520iuww520iuww520iuww520iuww520iuww520iuww520 Summary of Deliverables Part 1: A copy of your SQL data definition statements and test data should be produced and submitted electronically. Part 2: Your SQL statements for each of the Transactions of Interest should be produced and submitted electronically together with evidence of testing for each statement on your own data and assessment data. There will be two documents – one with your own data and one with the assessment data using the assessment template. The Assessment Template file issued nearer the submission time (48 hours prior to submission deadline). Resources The necessary materials are in the lecture notes/lab materials. Links to relevant PosgreSQL help pages are in the lecture slides. Recommended books in reading list are also useful. Assessment criteria • Good use of SQL data definition language to complete the table definitions; • Good use of SQL data manipulation language to write interactive queries; • Ability to interpret project specification correctly and accurately. This may include a little bit of independent thinking on what may make a table/report look good; • Correct functionality and output as required by each requirement; • Neatly presented work with correct program output in the assessment template; Sufficiency and completeness of Submitted code and tests data.
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。 |
