ICT285 Database Assignment 1: Felicity Stillwell Hospital Database

This assignment presents a comprehensive database design and implementation for the Felicity Stillwell Hospital. The solution begins with a revised Entity-Relationship Diagram (ERD) that models the hospital's data requirements, including staff, patients, wards, and local doctors. A detailed data dictionary is provided, outlining table structures, data types, and constraints for each entity. The core of the assignment involves creating and implementing the database using SQL, including the creation of tables for staff, patients, wards, and associated relationships. SQL statements are provided for data insertion, and the solution incorporates views to facilitate data retrieval and manipulation. Furthermore, the assignment demonstrates understanding of database concepts by including SQL queries and discussion of check constraints and triggers. The solution includes a bibliography citing relevant database management resources.