ICT285 Assignment 2: Database Implementation and SQL Queries

This assignment focuses on the implementation of a database for Felicity Stillwell Hospital, encompassing various aspects of database design and management. The solution includes an Entity-Relationship Diagram (ERD) illustrating the database structure, with explanations of the changes made to the original design. It provides a detailed data dictionary for each table, outlining column names, data types, and constraints. The assignment requires the implementation of the database in Oracle SQLPlus, including the creation of tables and the execution of SQL statements for data insertion and retrieval. The solution also covers the creation of views to simplify complex queries and the granting of privileges to users. The database design includes tables for wards, patients, next of kin, local doctors, appointments, inpatients, staff, staff work experience, staff allocation, qualifications, and beds, ensuring comprehensive data management for the hospital's operations. The SQL statements are provided to create tables, insert data, and define relationships between tables. The solution also includes views to simplify the retrieval of data from multiple tables and granting privileges for users. This assignment demonstrates the ability to design, implement, and manage a relational database using SQL.