logo

Database Design for a Wildlife Hospital

Assignment for ICT701 Relational Database Systems Task 2

8 Pages870 Words375 Views
   

Added on  2023-06-11

About This Document

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.

Database Design for a Wildlife Hospital

Assignment for ICT701 Relational Database Systems Task 2

   Added on 2023-06-11

ShareRelated Documents
Database Design for a Wildlife Hospital_1
Report
Part A: Database Design
ER Diagram
Database Design for a Wildlife Hospital_2
Relational Schema
1. CarerGroups
Attribute Data Type Key
FLLDPermitNumber NTEXT(49) PRIMARY KEY
FLLDCarerGroupName NTEXT(90)
FLLDExpiryDate DATE
2. CarerGroupSpecialization
Attribute Data Type Key
FLLDPermitNumber NTEXT(49) PRIMARY KEY
FOREIGN KEY
REFERENCES
CarerGroups
(FLLDPermitNumber)
FLLDSpecialization NTEXT(200) PRIMARY KEY
3. Carers
Attribute Data Type Key
FLLDCarerID NTEXT(20) PRIMARY KEY
FLLDPermitNumber NTEXT(49) FOREIGN KEY
REFERENCES
CarerGroups
(FLLDPermitNumber)
FLLDPermitOptions NTEXT(200)
FLLDFirstName NTEXT(49)
FLLDLastName NTEXT(49)
FLLDPhone NTEXT(20)
FLLDMobile NTEXT(49)
FLLDEmail NTEXT(49)
FLLDAddress NTEXT(49)
FLLDCity NTEXT(49)
FLLDState NTEXT(49)
FLLDCountry NTEXT(49)
FLLDPostCode NTEXT(49)
4. Breed_Type
Attribute Data Type Key
FLLDBreedTypeID INT PRIMARY KEY
FLLDBreedType NTEXT(90)
FLLDBreed NTEXT(90)
Database Design for a Wildlife Hospital_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
ICT701 Relational Database Systems
|9
|851
|121

ICT211 Database Design Assignment
|6
|685
|111

ICT211 - Relational Database Design
|6
|701
|111

ICT211 Database Design Assignment
|6
|689
|49

SQL script for Australia Zoo Wildlife Hospital database creation and data insertion
|14
|3786
|478

Data Management: The Queensland College database
|8
|1018
|333