This assignment on ICT701 relational database systems.  The database is in third normal form as the following database rules are used on the entire database.

ICT701 Relational Database Systems

ICT211 Database Design  Assignment

This report presents the database design for a wildlife hospital, including the ER diagram, relational schema, and normalization process. The database is designed to manage patient data, carer groups, carers, and treatments. The ER diagram and relational schema are provided, along with the normalization process. The database is in third normal form and follows all normalization rules.

Hartpury University and Hartpury College

Database Design for a Wildlife Hospital

In this document, we will discuss the database design of ER Diagram. Also, we cover the following assumptions: a&nbsp;one carer group may contain so many specializations,&nbsp;so many carers, the date and time of the DNA sample report should be saved in the database and all accession numbers should be saved along with medicines.

ICT211 - Relational Database Design

Individual Report

ICT211 Database Design Assignment

Geology

This SQL script contains the code for creating tables and inserting data into the Australia Zoo Wildlife Hospital database. The tables include BREAD_TYPE, AFFICITION, ANIMAL_INFO, PATIENT_INFO, PATIENT_DNA, RESCUER_INFO, CONTACTS, CARER_GROUP, CARER_INFO, TREATMENT, and ACCESSION.

ICT701 Relational Database Systems