ICT285 Database Assignment: Relational Algebra, SQL, and Design

This document presents a comprehensive solution for the ICT285 database assignment, encompassing various aspects of database management. The solution begins with relational algebra, providing answers to multiple queries using operators like PROJECT and SELECT. Following this, the document offers detailed SQL solutions, including SELECT queries for retrieving and manipulating data from tables, and further SQL solutions, including creating and altering tables using CREATE and ALTER statements. The assignment also addresses normalization, explaining the importance of normalization and converting a table to the 3NF form. Finally, the document includes a conceptual design, presenting an entity-relationship diagram (ERD) for a hospital database, along with a bibliography of relevant resources. The assignment covers key concepts such as data retrieval, table manipulation, and database design principles, providing a practical understanding of database management systems.