CSC3400 & CSC8500 { Database Systems Assignment 2 Page 1 Relational Query Languages Answer the following questions in a word processing document, export the document as a PDF file, and submit via the course web site. For mathematical symbols you can normally use the “Symbols” font that is available in your word processor. If you are unable to create a join (◃▹) symbol, you may simulate it as |><|. It is recommended (but not required) that you test your SQL answers using a relational database. Such tests may help you find the correct answers. Contest(starter, ender, pointsStarter, pointsEnder, debatedate) Debater(name, club, age) Figure 1: Relational Schema. The relational schema shown in Figure 1 models a very simple database for a Debating club. In a debating contest, one debater starts and is followed by his opponent who ends the contest. Debaters are both given points by an independent jury. The debater with the most points wins; draws are possible. It is assumed that not all the debaters in Debater relation participate the contest. The following two Foreign Keys exist in the schema: FK Contest(starter) references Debater(name) FK Contest(ender) references Debater(name) For the relational schema shown in Figure 1, answer the following four questions. Please use (A) the Relational Algebra, (B) the Domain Relational Calculus, and (C) SQL for Question (a) and use only SQL for Question (b), (c) and (d). For all the questions in this assignment, please include screen snapshots of the query results you obtain from XAMPP MySQL. This is important for demonstrating your ability in running your queries on a real-life database platform. We accept query results from other relational database platforms as well. Note that a large portion of marks (ranging from 33% to 50%) will be deducted if the snapshots are missing in your answers. A test dataset is provided which can be downloaded under the instruction of the assignment on the Studydesk. Please kindly note that all the students should only use this test dataset for testing their SQL answers and preparing the screen snapshots. Other test dataset is NOT allowed and you may lose some significant marks ranging from 33% to 50% if you do so. (a) Give all contest details of contests where the starting debater is a member of the \Plato" club and prevented his opponent from scoring any points. (b) List the names of debaters won at least one contest. (c) List the names of debaters who participated the contest but have not won a contest. (d) Give the name and age of all debaters who have lost exactly one debate as a starter. .../2CSC3400 & CSC8500 { Database Systems Assignment 2 Page 2 For Question(c), please try to avoid the use of EXCEPT when calculating the difference between 2 sets as it is not supported by XAMPP MySQL. You can consider using other alternative ways such as NOT IN to answer this question. .../3CSC3400 & CSC8500 { Database Systems Assignment 2 Page 1 Relational Query Languages Answer the following questions in a word processing document, export the document as a PDF file, and submit via the course web site. For mathematical symbols you can normally use the “Symbols” font that is available in your word processor. If you are unable to create a join (◃▹) symbol, you may simulate it as |><|. It is recommended (but not required) that you test your SQL answers using a relational database. Such tests may help you find the correct answers. Contest(starter, ender, pointsStarter, pointsEnder, debatedate) Debater(name, club, age) Figure 1: Relational Schema. The relational schema shown in Figure 1 models a very simple database for a Debating club. In a debating contest, one debater starts and is followed by his opponent who ends the contest. Debaters are both given points by an independent jury. The debater with the most points wins; draws are possible. It is assumed that not all the debaters in Debater relation participate the contest. The following two Foreign Keys exist in the schema: FK Contest(starter) references Debater(name) FK Contest(ender) references Debater(name) For the relational schema shown in Figure 1, answer the following four questions. Please use (A) the Relational Algebra, (B) the Domain Relational Calculus, and (C) SQL for Question (a) and use only SQL for Question (b), (c) and (d). For all the questions in this assignment, please include screen snapshots of the query results you obtain from XAMPP MySQL. This is important for demonstrating your ability in running your queries on a real-life database platform. We accept query results from other relational database platforms as well. Note that a large portion of marks (ranging from 33% to 50%) will be deducted if the snapshots are missing in your answers. A test dataset is provided which can be downloaded under the instruction of the assignment on the Studydesk. Please kindly note that all the students should only use this test dataset for testing their SQL answers and preparing the screen snapshots. Other test dataset is NOT allowed and you may lose some significant marks ranging from 33% to 50% if you do so. (a) Give all contest details of contests where the starting debater is a member of the \Plato" club and prevented his opponent from scoring any points. (b) List the names of debaters won at least one contest. (c) List the names of debaters who participated the contest but have not won a contest. (d) Give the name and age of all debaters who have lost exactly one debate as a starter. .../2CSC3400 & CSC8500 { Database Systems Assignment 2 Page 2 For Question(c), please try to avoid the use of EXCEPT when calculating the difference between 2 sets as it is not supported by XAMPP MySQL. You can consider using other alternative ways such as NOT IN to answer this question. .../3MCOM4040 Marketing and Communications Spring 2017 Marketing and Communications Coursework Brief Handout: [FEB 2017] Deadline for Submission: [Time (am/pm), Date, Month Year] Submit this coursework through the Student Portal with a Turn-it-in Report Word Limit:2000 words (Plus or minus 10%) Learning outcomes assessed: 1. Identify and explain the marketing concept, the marketing mix and the components of the marketing communications mix. 2. Explain the relationship between the marketing environment, its impact upon organisational decision making and consumer behaviour. 3. Discuss the factors that determine competitive advantage within organisations 4. Explain key theories, concepts and models underpinning business communication to create effective communications. 5. Examine and discuss organisational issues and challenges that impact on the effectiveness of business communication through the use of pre-defined criteria to assist in improving communication within the organisation. 6. Demonstrate an application of concepts and techniques related to business communication processes used within the workplace.This coursework is worth 50% of the total marks for this module.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 1 of 16 Coursework Instructions Please read carefully • Carefully read the module handbook, the marking criteria and the grade descriptors. Academic Misconduct You are responsible for ensuring you understand the policy and regulations about academic misconduct. You must: • Complete this work alone except where required or allowed by this assignment briefing paper and ensure it has not been written or composed by or with the assistance of any other person. • Make sure all sentences or passages quoted from other people’s work in this assignment (with or without trivial changes) are in quotation marks, and are specifically acknowledged by reference to the author, work and page.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 2 of 16 BlankModule Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 3 of 16 Assignment Questions Part 1 Individual - Marketing Plan (2000 words) Case: Real Marketing 3.1 - Chipotle’s Environmental Sustainability Mission: Food With Integrity (Kotler and Armstrong, 2016, Principles of Marketing sixteenth edition…p.109-10 – accessible via dawsonera too) The case above gives a brief overview of the company and provides a summary of the situation analysis relevant to the development and growth of Chipotle. Students are required to develop a marketing plan for Chipotle with a new objective and strategy that will support the organisations vision/mission. The marketing plan should follow the following structure: 1. Executive Summary 2. Company Overview (very brief taken from the case and inclusive of new findings) 3. Current Marketing Situation Analysis (SWOT accompanied by summary) 4. Objectives (one new objective) 5. Strategy & Segmentation, Targeting and Positioning (STP) 6. Tactics & Action 7. Budget 8. Control 9. Conclusion / Recommendation 10. References 11. Appendix (Meets LO1, 2, & 3) End of Assignment BriefModule Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 4 of 16 Spring – A17- MCOM4040) - Marketing & communication mark scheme Part I – Marketing Plan (50%) 2000 words Strength Adequate Needs Improvement Overall Knowledge and understanding of the subject 45% • Clearly understands the assignment question and application to chosen case • Knowledge and understanding of the steps required in a marketing plan demonstrated (executive summary, company overview, situation analysis, objectives, marketing strategy, STP, tactic & action, budget, control, conclusion, references, appendix). • Identified key theories and /or concepts such as PESTLE, Ansoff Matrix, SWOT, STP, 7P’s, etc (refer to guide of plan) __/45 Cognitive and intellectual skills 30% • Analysis and synthesis – e.g. discussion of internal and external environment leading SWOT analysis • Logic argument - e.g. with evidence articulate how a specific • objective, strategy and tactic has been reached • Select relevant evidence to support recommendation and / or conclusion __/30 Graduate Skills 25% • Has a number of reliable sources (e.g. Organisation reports, • academic journals, academic text) • Has researched beyond the key reading appropriate for __/25Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 5 of 16 the subject. • Academic honesty - Has avoided plagiarism • Has used Harvard referencing (in-text and reference list) • Uses appropriate academic conventions (e.g. summaries, paraphrasing etc.) • Research-related skills (evidenced by collection and interpretation of data to support the marketing plan • Written and graphical skills (used the recommended format to present the marketing plan e.g. illustrations used to enhance plan) • Problem-solving (is the strategy and recommendation based on the analysis • Practical and professional skills (work has right level of detail/ complexity) TOTAL ____/100Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 6 of 16 Marking Criteria GSM LONDON GENERIC ASSESSMENT MARKING CRITERIA LEVEL 4 Level 4 introduces students to HE. Students are expected to demonstrate relevant skills and competencies; to be articulate in expressing ideas orally; and to be coherent and structured in terms of written or other media. Forms of expression at this level may be descriptive or imitative, but students are expected to demonstrate an increasing understanding of the theoretical background of their study and the analytic competence to explore it, as well as its relationship, where appropriate, to particular skills. Students are expected to develop an awareness of strengths and weaknesses in their skill sets. These criteria are designed to be a reference point for assessment criteria in all subjects. Where the generic criteria are deemed to be sufficient, they can be used directly for assessing students' learning. KNOWLEDGE & UNDERSTANDI NG INTELLECTUAL & COGNITIVE SKILLS Graduate Skills: transferable, employability, practical and academic skills Factual and conceptual knowledge and understanding; use of class materials; independent reading Critical thinking; conceptualisation; creativity; synthesis, analysis and evaluation; application; problem solving and research/investiga tion Written, oral and presentation skills; interpersonal, group and teamwork skills; leadership skills; numeracy; digital skills; practical, professional and academic skills (including referencing/presenta tion MARKIN G BAND CLASSIFICATIO N WEIGHTED AT 45% WEIGHTED AT 30% WEIGHTED AT 25% 86 - 100% FIRST (1ST) Includes all required factual content, accurately summarised. Well developed, relevant, reasoned introduction and conclusions. Within word count or presentation time. Accurate identification of relevant concepts, theories and/or principles, appropriate to this level and likely to extend beyond core of classroom content Clearly and logically structured material. Accurate spelling, grammar, punctuation, paragraphing. Structured appropriately Excellent understanding of factual and Information or data selected from a good range of Fluent, interesting writing style, appropriate to theModule Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 7 of 16 conceptual material, relative to this level. appropriate primary and/or secondary sources, and categorised, analysed or evaluated using relevant methods or techniques. assignment OR engaging, confident, audible and well paced presentation. Calculations are accurate, clearly set out, with explanations. Well developed, coherent arguments, referencing primary and secondary literature. Appropriate visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Well developed integration of theory and practice, for this level, using defined conceptual frameworks. Correct use of academic conventions, references and bibliography. Very good application of numerical and statistical methods to defined problems. Outstanding, consistent delivery of group work obligations, for this level. Substantiated, relevant, logical recommendations. Very good awareness of ethical issues, where relevant. Insightful reflection on own strengths and weaknesses in relation to defined professional and practical skills. 70 - 85% FIRST (1ST) Includes all required factual content, accurately summarised. Well developed, relevant introduction and conclusions. Within word count or presentation time. Includes relevant factual content only. Well structured material. Accurate spelling, grammar, punctuation, paragraphing. Structured appropriately Accurate identification of relevant concepts, theories and/or principles, appropriate to Information or data selected from a good range of appropriate primary and/or secondary sources, and categorised, Fluent writing style, appropriate to the assignment OR engaging, audible and well paced presentation. StructuredModule Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 8 of 16 this level. analysed or evaluated using relevant methods or techniques. appropriately Very good understanding of factual and conceptual material, relative to this level. Coherent arguments, referencing primary and secondary literature. Appropriate visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are accurate, clearly set out, with explanations. Very good integration of theory and practice, for this level, using defined conceptual frameworks. Correct use of academic conventions, references and bibliography. Good application of numerical and statistical methods to defined problems. Very good, consistent delivery of group work obligations, for this level. Relevant and logical recommendations. Good awareness of ethical issues, where relevant. Good reflection on own strengths and weaknesses in relation to defined professional and practical skills. 60 - 69% UPPER SECOND (2:1) Includes most required factual content, mostly accurately summarised. Relevant introduction and conclusions. Appropriate visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Includes relevant factual content only. Clearly structured material. Mostly accurate spelling, grammar, punctuation, paragraphing. Mainly accurate identification of relevant concepts, theories and/or principles, appropriate to this level. Information or data selected from some relevant primary and secondary sources, and categorised, analysed or evaluated using relevant methods or techniques but with some gaps or misunderstandings. Mainly fluent writing style, appropriate to the assignment OR mainly engaging, audible and well paced presentation. Sound Mostly coherent Mostly appropriateModule Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 9 of 16 understanding of factual and conceptual material, relative to this level. arguments, referencing primary and secondary literature. visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are mainly accurate, mostly clearly set out, with mostly good explanations. Good integration of theory and practice, for this level. Mostly correct use of academic conventions, references and bibliography. Independent reading and research from sufficient and mostly authoritative primary and secondary sources, appropriate to this level. Mainly good application of numerical and statistical methods to defined problems, with some gaps, errors or misunderstandings. Consistent delivery of group work obligations, for this level. Some relevant recommendations. Satisfactory awareness of ethical issues, where relevant. Clear reflection on own strengths and weaknesses in relation to defined professional and practical skills. 50 - 59% LOWER SECOND (2:2) Includes essential required factual content, but with some gaps or misunderstandin gs. Adequate introduction and conclusions. Within 10% of word count or presentation time. Includes some irrelevant factual content. Mostly clearly structured material. Some mistakes in spelling, grammar, punctuation, paragraphing. Some identification of relevant concepts, theories and/or principles, appropriate to this level. Information or data selected from mainly secondary sources, and categorised, analysed or evaluated using mostly relevant methods or techniques but with gaps or Writing style is appropriate but not always fluent OR a presentation that is not always engaging, audible or well paced.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 10 of 16 misunderstandings. Adequate understanding of factual and conceptual material, relative to this level. Limited arguments, referencing mostly secondary literature. Inconsistent visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations may have inaccuracies, or issues relating to set out and explanation. An adequate attempt to relate theory to practice, for this level, using defined conceptual frameworks. Inconsistent use of academic conventions, references and bibliography. Some independent reading and research from mainly secondary sources, appropriate to this level. Adequate application of numerical and statistical methods to defined problems, with gaps, errors or misunderstandings. Inconsistent delivery of group work obligations, for this level. Basic recommendations. Satisfactory awareness of ethical issues, where relevant. Some evaluation of own strengths and weaknesses in relation to defined professional and practical skills. 40 - 49% THIRD (3RD) Includes limited required factual content, with many gaps or inaccuracies. Basic introduction and conclusions. Within 10% of word count or presentation time. Includes considerable irrelevant factual content. Unevenly structured material. Frequent mistakes in spelling, grammar, punctuation, paragraphing. Limited identification of relevant concepts, theories and/or principles, appropriate to this level. Information or data selected from secondary sources, and poorly categorised, analysed or evaluated using inappropriate methods or techniques. Awkward or inappropriate writing style OR a presentation that is not engaging, audible or well paced. Limited understanding of factual and conceptual Sense of emerging argument, mainly descriptive or personal opinion, Clear but inappropriate visual presentation, including font,Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 11 of 16 material, relative to this level. with little reference to literature. spacing, margins, headings, graphics, images and appendices. Calculations are often inaccurate, with many issues relating to set out and explanation. Limited attempt to relate theory to practice, using defined conceptual frameworks. Inconsistent or incomplete use of academic conventions, references and bibliography. Limited independent reading and research from secondary sources, appropriate to this level. Weak application of numerical and statistical methods to defined problems, with many gaps or errors. Unreliable delivery of group work obligations, for this level. Recommendations lack clarity or may be incomplete. Little awareness of ethical issues, where relevant. Limited reflection on own strengths and weaknesses in relation to defined professional and practical skills. 30 - 39% FAIL. POSSIBLE COMPENSATI ON. Includes insufficient required factual content, with significant gaps or inaccuracies. Incoherent or irrelevant introduction and conclusions. More than 10% outside word count or presentation time. Includes substantial irrelevant factual content. Incoherently structured material. Serious mistakes in spelling, grammar, punctuation, paragraphing. Very limited or inaccurate identification of relevant concepts, theories and/or principles, appropriate to this level. Little selection of information or data, and little attempt at collation, categorisation, analysis or evaluation. Poor writing style OR a presentation that is not engaging, audible or well paced. Very limited understanding of factual and conceptual material, relative to this level. Little or no argument, entirely descriptive or personal opinion, with no reference to literature. Poor visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are mostly Theory only sporadically related Inaccurate or incomplete use ofModule Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 12 of 16 inaccurate, or incorrectly set out or explained. to practice, using defined conceptual frameworks. academic conventions, references and bibliography. Minimal independent reading and research, appropriate to this level. Very weak application of numerical and statistical methods to defined problems, with significant errors. Poor delivery of group work obligations, for this level. Irrelevant recommendations. Little or no awareness of ethical issues, where relevant. Very limited reflection on own strengths and weaknesses in relation to defined professional and practical skills. 16 - 29% FAIL. NO COMPENSATI ON. Includes almost no required factual content, and with very significant inaccuracies. Incoherent or missing introduction and conclusions. More than 10% outside word count or presentation time. Includes mainly irrelevant factual content. Very incoherently structured material. Serious and extensive mistakes in spelling, grammar, punctuation, paragraphing. No identification of relevant concepts, theories and/or principles. No evidence of the selection, categorisation, analysis or evaluation of information or data. Incoherent writing style OR an inaudible, poorly paced and unengaging presentation. No understanding of factual and conceptual material, relative to this level. No argument, entirely descriptive or personal opinion, with no reference to literature. Very poor visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are inaccurate, with no explanations. Theory not related to practice. Very inaccurate or no use of academic conventions, references and bibliography. No independent reading and research, appropriate to this level. Minimal application of numerical and statistical methods and techniques to defined problems, Very poor delivery of group work obligations, where relevant.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 13 of 16 with significant errors. No recommendations. No awareness of ethical issues, where relevant. Minimal or no evaluation of own strengths and weaknesses in relation to defined professional and practical skills. 0 - 15% FAIL. NO COMPENSATI ON. Does not include required factual content. No introduction and conclusions. More than 10% outside word count or presentation time. Includes entirely irrelevant factual content. Very incoherently structured material. Serious and extensive mistakes in spelling, grammar, punctuation, paragraphing. No identification of relevant concepts, theories and/or principles. No evidence of the selection, categorisation, analysis or evaluation of information or data. Incoherent writing style OR an inaudible, poorly paced and unengaging presentation. No understanding of factual and conceptual material. No argument, entirely personal opinion, with no reference to literature. Exceptionally poor visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are missing, with no explanations. Theory not related to practice. No use of academic conventions, references and bibliography. No independent reading and research, appropriate to this level. No application of numerical and statistical methods to defined problems. No delivery of group work obligations, for this level. No recommendations. No awareness of ethical issues, where relevant.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 14 of 16