Module ICL-1004:
Database Design and Management

Module Facts

Run by School of Computer Science and Electronic Engineering

20 Credits or 10 ECTS Credits

Semester 1 & 2

Overall aims and purpose

This module will provide the learners with the skills required to design, create and maintain a relational database. The skills gained will then help the learners to enter a commercially operated database environment and to administer the system to the requirements of the industry.

Firstly, the module is designed to develop an understanding of the fundamentals behind the efficient and effective organisation of data and data relationships. Secondly, it is designed to develop, by means of practical examples, the skills involved in using the SQL to create a database system and also how to manage and interrogate the information contained within the system.

Course content

Indicative content includes:

● Fundamentals of database design – For example, Relationships between tables, Primary and Foreign Key, data integrity, fields, Data types(such as TEXT, DATE, NUMBER etc)

● Conceptual data modelling (Entity Relationship Model) – For example Logical relationships including One to one, one to many and Many to Many

● Relational design – functional dependency and normalisation (up to third normal form)

● Create a database structure using a suitable front end database. (Create tables, reports, forms and query the database)

● Create a database structure using SQL commands

● Develop SQL commands to maintain a database (CREATE, INSERT, UPDATE, ROLLBACK, COMMIT, JOIN, ALTER etc)

Assessment Criteria

excellent

Equivalent to the range 70%+. Assemble critically evaluated, relevent 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.

threshold

Equivalent to 40%. 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.

Learning outcomes

  1. Demonstrate understanding of the principles of the relational database model, normalisation and functional dependencies.

  2. Analyse the data requirements of a system to a design and a relational model.

  3. Build a database to satisfy the data requirements.

  4. Demonstrate understanding of the principles of SQL

Assessment Methods

Type Name Description Weight
REPORT Theory of Relational Databases and Normalisation

A report on the theory of Relational databases and normalisation, including examples. Design a database from a specified scenario. This will include the development of an Entity Relationship Model (ERD).

40
COURSEWORK SQL Laboratories

Laboratory exercises on SQL. The questions will be answered using SQL commands. These include table creation, insertion, and querying data.

30
COURSEWORK Implement a Working Database in Access

Implement a working database in Access using designs from Assignment 1. An evaluation on your own performance towards the assignment.

30

Teaching and Learning Strategy

Hours
Lecture

The classroom-based element will include student-centred learning methods such as interactive lectures, case studies, group discussions and practical workshops.

60
Tutorial

The tutor directed student learning will be supported by online learning materials hosted or signposted on the Grŵp VLE.

140

Transferable skills

  • Literacy - Proficiency in reading and writing through a variety of media
  • Computer Literacy - Proficiency in using a varied range of computer software
  • Self-Management - Able to work unsupervised in an efficient, punctual and structured manner. To examine the outcomes of tasks and events, and judge levels of quality and importance
  • Critical analysis & Problem Solving - Able to deconstruct and analyse problems or complex situations. To find solutions to problems through analyses and exploration of all possibilities using appropriate methods, rescources and creativity.

Subject specific skills

  • Knowledge and understanding of facts, concepts, principles & theories
  • Problem solving strategies
  • Deploy theory in design, implementation and evaluation of systems
  • Knowledge and understanding of commercial and economic issues
  • Knowledge of management techniques to achieve objectives
  • Specify, design or construct computer-based systems
  • Deploy tools effectively
  • Development of general transferable skills
  • Deploy systems to meet business goals
  • Methods, techniques and tools for information modelling, management and security
  • Specify, deploy, verify and maintain information systems
  • Knowledge and understanding of computational modelling
  • Specify, deploy, verify and maintain computer-based systems

Resources

Reading list

Beighly, L., 2007. Head First SQL , O’Reilly

Carter, J., 2003. Database design and programming with Access, SQL and Visual Basic . 2 nd ed. McGraw-Hill

Date, C.J., 2003. Introduction to Database Systems : 8 th ed. Addison Wesley.

Date, CJ and Darwen, H., 2006. Databases, Types and the Relational Model: The Third Manifesto , Addison Wesley.

Taylor, A.G., 2013. SQL for Dummies : 8 th ed. Wiley & Sons

Courses including this module