DATABASES

❑ Definition of: ✓ Data ✓ Database ✓ Database Management System (DBMS) ❑ Terminologies related to database ✓ Relation ✓ Tuple ✓ Attributes ✓ Degree ✓ Cardinality ❑ Characteristics of the Database Approach ❑ Purpose of a database ❑ Types of Databases ✓ Centralized Database ✓ Distributed Database ✓ Relational Database ✓ Cloud Database ✓ Hierarchical Databases ✓ Network Databases ❑ Advantages of using a database ❑ Functions of DBMS ❑ Components of DBMS Environment ✓ Hardware ✓ Software ✓ Data ✓ Procedures

❑ Database design Phases are explained ❑ Entity Relational (ER) Model ✓ Entity ✓ Entity Set ✓ Attributes ✓ Keys ✓ Relationships ❑ Working with ER Diagrams ✓ Components of ER Diagram ❑ Codd's Rule for Relational DBMS ❑ Relational Data Structure ✓ table ✓ Tuple ✓ Attribute ✓ Relation Schema ✓ Relation Key ❑ Relational Integrity Constraints ❑ Characteristics of Relational Database ❑ Relational Database Design Process ❑ Logical Database Design ❑ Database normalization ✓ Definition of Normalisation ✓ Database Normal Forms

First normal form (1NF)

Second normal form (2NF)

Third normal form (3NF) ❑ Destroying/Altering Tables and ❑ Views Tables

❑ Advantages Of SQL ❑ SQL Data Types and Literals. ❑ Types of SQL Commands ❑ SQL Operators and Their precedence ❑ Tables, Views and Indexes ❑ Queries and Sub Queries ❑ Aggregate Functions ❑ Insert, Delete and Update Operations ❑ SQL Joins ✓ Inner join ✓ Left join . ✓ Right join ✓ Full join ✓ Self join ✓ Cartesian join ❑ Cursors in SQL ❑ Definition of Structured Query Language (SQL) ❑ Characteristics of SQL

❑ Definition of database monitoring ❑ Purpose of Database Monitoring ❑ Perform Database Monitoring ✓ Common Approaches to Database Monitoring

Proactive

Reactive ✓ Key Metrics to Track

Query Execution Performance

Hardware

Concurrency Problems ❑ Database Monitoring Best Practices ✓ Monitor Changes to the Database ✓ Measure Throughput ✓ Monitor Availability and Consumption of Resources ❑ Track Database Logs ❑ Examples of Database