ICT285 Databases Assignment 2 Solution - University Name

This document presents a complete solution for an ICT285 Databases assignment, focusing on database design and implementation for a hospital management system. It begins with a revised Entity-Relationship Diagram (ERD) based on feedback, detailing entities such as WARD, PATIENT, STAFF, and their relationships. A comprehensive data dictionary is provided, defining the attributes, data types, and constraints for each table. The solution includes the SQL statements necessary to create the database schema, populate tables with sample data, and define various views to retrieve specific information. The assignment also covers further constraints, such as triggers for bed allocation and user roles for database access. The provided bibliography cites relevant database design and relational theory resources, offering a well-structured and detailed approach to the assignment requirements.