Data dictionary and sql queries

1Data dictionary and sql queries
Data dictionary and sql queries
Student’s Name:
Institution affiliation:
Part 1

2Data dictionary and sql queries
Data dictionary
Database name: Care and cure management systems
Table Login
Field Data Type Constraints Description
Username varchar(80)
Password varchar(90)
Table Room
Field Data Type Constraints Description
Room_no int Primary key Auto Increament
Room_type varchar(20)
Rate_per_day int
Floor_ID int Foreign Key
Room_Location varchar(100)
Room_Status boolean
Date datetime

3Data dictionary and sql queries
Table patients
Field Data Type Constraints Description
Patient_ID int Primary Key Auto Increament
First Name varchar(60)
Patient_Type varchar(60)
Last Name varchar(60)
Address varchar(150)
Date_of_Birth datetime
Info_ID int Foreign Key
Phone varchar(13)
Emergency_contact varchar(13)
Date_of_admit datetime
Mode_of_Payment varchar(150)
Initial_Condition varchar(400)
Diagnosis varchar(500)
Treatment varchar(400)
Doctor varchar Foreign Key
Health_Insurance boolean
Room_No int Foreign Key
Operation_Type varchar(200)
Date_of_Operation datetime