Overview

Indicative content includes:

• Fundamental database concepts; what is a database, tables, queries, etc.
• SQL as a language and its function within databases.
• Database design and normalisation; logical and physical design concepts and techniques.
• Implementation of a database design.
• Security concerns, concepts, and mechanisms.
• Transactions and concurrency control.

Assessment Strategy

Threshold - Equivalent to 50%: Uses key areas of theory or knowledge to meet the Learning Outcomes of the module. Is able to formulate an appropriate solution to accurately solve tasks and questions. Can identify individual aspects, but lacks an awareness of links between them and the wider contexts. Outputs can be understood, but lack structure and/or coherence.

Good - Equivalent to the range 60%-69%: Is able to analyse a task or problem to decide which aspects of theory and knowledge to apply. Solutions are of a workable quality, demonstrating understanding of underlying principles. Major themes can be linked appropriately but may not be able to extend this to individual aspects. Outputs are readily understood, with an appropriate structure but may lack sophistication.

Excellent - Equivalent to the range 70%: Assemble critically evaluated, relevant areas of knowledge and theory to constuct professional-level solutions to tasks and questions presented. Is able to cross-link themes and aspects to draw considered conclusions. Presents outputs in a cohesive, accurate, and efficient manner.

Learning Outcomes

• Appraise the issues of executing multiple queries simultaneously, and how transactions solve them.

• Create ER models for particular applications.

• Examine and describe the major characteristics of a relational database.

• Understand and apply the conceptual, logical and physical database design methodologies including the different levels of normalising data.

• Use SQL to query, manipulate and secure a database.