ew of the COMP1121 course at the University of Leeds a summary A database is a common component of many computer systems and is used to store and retrieve data about the state of the system. This module covers the principles of database system design, architecture, implementation and the role of database management systems. To understand the design of a database system requires an understanding of relational theory as well as the tools and techniques to decompose the system and model it in an appropriate manner. This module introduces the tools used to manipulate data in a database and the design principles for ensuring data security and integrity. two goals This module provides a foundation for the design and implementation of databases, with an emphasis on relational database systems Three Learning Outcomes Upon successful completion of this module, students will demonstrate the ability to: – Describe the purpose and architecture of a database management system. – Use appropriate tools to operate database systems. – Design and implement databases using appropriate tools. – Apply relational modeling techniques to real-world situations. – Apply normalization and explain the advantages and disadvantages of normalization. – Describe the ethical, legal and security-related issues associated with the implementation and management of databases and their management systems. Four Syllabus – Database Management Systems: Purpose of Database Management Systems, Architecture of Database Management Systems, Administration of Database Management Systems, ACID Principles and Concurrency. – Ethical issues concerning the use of databases in society. – Relational Databases: relational algebra, relational calculus, table design (including identifying functional dependencies, primary keys, foreign keys, choosing appropriate data types) and paradigms. – Query Language: Declarative Query Language, Comparison of Alternatives, Manipulating Databases Using Query Language.