CMP111: Information Systems and Databases Assessment Brief 1

Module aims of CMP111:

The aim of the module is to provide a study of the key principles, systems and techniques used in information systems.

1. Identify and define the requirements of a database system for a given scenario.
2. Discuss industry standard information systems and database tools.
3. Describe a relational database solution using industry design standards.
4. Demonstrate the use of information systems and database development tools and techniques.

CMP111 Learning Outcomes

LO1: Identify and define the requirements of a database system for a given scenario.
LO 2: Discuss industry standard information systems and database tools.

Assessment 1: Report (50% Weighting)

You have been asked to demonstrate your knowledge and understanding of data management tools and systems. Whilst you have been asked to develop your solution with php My Admin and SQL, there are other industry standard tools available. You are to write a report that identifies, defines, and briefly discusses four of these available tools. You then select two of the tools and compare them in line with the provided outline below.

You are also required to outline the functional and non-functional requirements of the case study system. You should outline these clearly in a logical order in line with the outline below:

1. Cover Page
2. Identify and briefly discuss four database management tools that could be used in designing your database for the given scenario. 

3. Select two tools from the four discussed above and carry out a comparative analysis of the selected ones as follows:
a.    Tool 1

1. What is it, how is it used
2. Advantages
3. Disadvantages

b.    Tool 2

1. What is it, how is it used
2. Advantages
3. Disadvantages

c.    Which of the two, based on your analysis, would you recommend for the Case Study? Back your choice up with evidence.

4. Functional/Non-Functional Requirements of your system (5 of each).
5. Reference List

Assessment CMP111 criteria:

• Content and Analysis (40%) 
  Depth and relevance of the analysis carried out. 
• Structure and Organization (30%) 
  Logical flow, coherence, and presentation. 
• Communication and presentation (20%) 
  Clarity and Style of expression, correct use of terminologies, formal and professional tone, grammar, and spelling.
• Referencing (10%) 
  Quality, relevance, proper citation, and integration of sources.

Learning and Teaching Strategies of CMP111:

Our philosophy of learning and teaching, our understanding of teaching for level 4 and NCG policies and strategies have all influenced our specific approach to learning and teaching for the level 4. Our teaching methods have been developed with explicit attention to debates pertaining to student learning styles. As such, our teaching methods provide a framework via which students develop the capacity to manage their own learning and evolve, over the course of their studies, into independent learners, acquiring the knowledge, understanding and skills that are essential to learning in Higher Education and to lifelong learning, post-graduation. Lectures, tutorials, and student-centred learning exercises will be employed. Practical sessions will support the learning of abstract concepts. Workshops and demonstrations will be organised in different topics to help the students master the necessary skills to develop their knowledge in these areas. Wherever possible, reference will be made to additional material and academic journals in the relevant field of computing. The VLE will be used to augment face to face teaching and learning with additional opportunities for learning and access to resources. There will be an introduction to the use of the library and a supportive tutorial framework to give individual support where required.