Modiwl ICP-2221:
Database Systems 1

Ffeithiau’r Modiwl

Rhedir gan School of Computer Science and Electronic Engineering

10 Credyd neu 5 Credyd ECTS

Semester 1

Trefnydd: Mr Andrew Harbach

Amcanion cyffredinol

To provide students with an introductory level of understanding of database systems: concept of a database, database management systems, ER and EER modelling and the relational model, normalization, and SQL.

Cynnwys cwrs

Concept of a Database What is a database; their uses and benefits; what came before; what is a DBMS. What information can be stored. Issues over storing user data in a database. Ethics of storage, dissemination and use. Principles: Accessible, Confidential, Completeness.

Database Modeling Database Design Concepts, Entity Relationship Modeling, UML diagrams.

Relational Databases Basic concepts of relational model.

Normalisation First, second, and third normal forms.

SQL Updating and querying tables using SQL.

Cyswllt Canlyniad dysgu i Meini Prawf

  threshold

40%

good

60%

excellent

70%

Understand and describe the major characteristics of a relational database.

Can explain in outline the concept of a database. Can describe some of the problems assocaited with the traditional file based approach. Can describe the structure of a DBMS and identify the principal components. Can describe in outline the ANSI-SPARC three layer model. Can offer a sophisticated explanation of the ANSI-SPARC three layer model.

Use SQL to query and update a database.

Can understand and write a range of basic SQL statements(both DDL and DML) Can understand and write queries involving multiple tables (Joins and Nested Queries). Can develop and interrogate a non-trivial database (e.g. containing five or more tables). Can define appropriate key structures, referential actions and indexes.

Understand the relational model and have an awareness of relational algebra.

Be able to recognise basic relational algebra expressions involving select and projection A basic understanding of Cartesian and join operators. Be able to write and understand simple relational algebra operations.

Use normalisation techniques.

Can create a simple ER model that does not contain too many relationships. Can create an ER/EER model involving many relationships and subclasses. Can create a large complex ER/EER model involving many different types of relationships and subclasses.

Understand and use E/R diagrams.

.Can describe 1NF, 2NF and 3NF. Can explain why these forms are important in the process of database design Can examine a given set of relations and if necessary convert to 1NF. Can examine a given set of relations and if necessary convert to 3NF.

Dulliau asesu

Math Enw Disgrifiad Pwysau
PRAWF DOSBARTH Class Test 40
GWAITH CWRS Assessed lab on basic queries and grouping 30
GWAITH CWRS Assessed lab on multi table queries 30

Strategaeth addysgu a dysgu

Oriau
Lecture

Formal lectures covering theory and demonstrating practical topics.

13
Laboratory

Practical sessions writing SQL. Includes marking where students are expected to explain their work to a member of staff. Also includes class tests.

20
Private study

To include working on lab assignments and self-study.

61
Tutorial

Interactive sessions covering writing SQL, case studies, and revision.

6

Sgiliau Trosglwyddadwy

  • Llythrennedd - Medrusrwydd mewn darllen ac ysgrifennu drwy amrywiaeth o gyfryngau
  • Rhifedd - Medrusrwydd wrth ddefnyddio rhifau ar lefelau priodol o gywirdeb
  • Defnyddio cyfrifiaduron - Medrusrwydd wrth ddefnyddio ystod o feddalwedd cyfrifiadurol
  • Adalw gwybodaeth - Gallu mynd at wahanol ac amrywiol ffynonellau gwybodaeth

Sgiliau pwnc penodol

  • Knowledge and understanding of facts, concepts, principles & theories
  • Use of such knowledge in modelling and design
  • Problem solving strategies
  • Analyse if/how a system meets current and future requirements
  • Deploy theory in design, implementation and evaluation of systems
  • Knowledge of information security issues
  • Specify, design or construct computer-based systems
  • Deploy tools effectively
  • Deploy systems to meet business goals
  • Methods, techniques and tools for information modelling, management and security
  • Knowledge of systems architecture
  • System Design
  • Knowledge and/or understanding of appropriate scientific and engineering principles
  • Knowledge and understanding of mathematical principles

Adnoddau

Rhagofynion a Chydofynion

Cyrsiau sy’n cynnwys y modiwl hwn