Hospital Management System
Hospital Management System DATABASE DESIGN
1. Description A database is a collection of information and is systematically stored in tables in the form of rows and columns. The table in the database has unique name that identifies its contents. The database in turn is further described in detail giving all the fields used with the data types, constraints available, primary key and foreign key. Database design is used to manage large bodies of information. In this database we describe all the 4 tables available in the software, which are used to store all the records.
2. Data types and its description: Fields in database table have a data type. Some of the data types used in database table are explained below. a) Integer:- One optional sign character (+ or -) followed by atleast one digit (0-9). Leading and trailing blanks are ignored. No other character is allowed. b) Varchar:- It is used to store alpha numeric characters. In this data type we can set the maximum number of characters upto 8000 ranges by default SQL server will set the size to 50 characters large. 19
Hospital Management System c) Date/Time:- Date/Time data type is used for representing data or time.
Patient Table: Fields | Data Type | Relationships | Pid | Varchar(5) | Primary Key | name | Varchar(20) | Not Null | age | int | Not Null | weight | int | Not Null | gender | Varchar(10) | Not null | address | Varchar(50) | Not Null | phoneno | int | Not Null | disease | Varchar(20) | Not Null | doctorid | Varchar(5) | Not Null |
Doctor Table: Fields | Data Type | Relationships | doctorid | Varchar(5) | Primary Key | doctorname | Varchar(15) | Not Null | dept | Varchar(15) | Not Null |
20
Hospital Management System
Lab Table: Fields | Data Type | Relationships | labno | Varchar(5) |
1. Description A database is a collection of information and is systematically stored in tables in the form of rows and columns. The table in the database has unique name that identifies its contents. The database in turn is further described in detail giving all the fields used with the data types, constraints available, primary key and foreign key. Database design is used to manage large bodies of information. In this database we describe all the 4 tables available in the software, which are used to store all the records.
2. Data types and its description: Fields in database table have a data type. Some of the data types used in database table are explained below. a) Integer:- One optional sign character (+ or -) followed by atleast one digit (0-9). Leading and trailing blanks are ignored. No other character is allowed. b) Varchar:- It is used to store alpha numeric characters. In this data type we can set the maximum number of characters upto 8000 ranges by default SQL server will set the size to 50 characters large. 19
Hospital Management System c) Date/Time:- Date/Time data type is used for representing data or time.
Patient Table: Fields | Data Type | Relationships | Pid | Varchar(5) | Primary Key | name | Varchar(20) | Not Null | age | int | Not Null | weight | int | Not Null | gender | Varchar(10) | Not null | address | Varchar(50) | Not Null | phoneno | int | Not Null | disease | Varchar(20) | Not Null | doctorid | Varchar(5) | Not Null |
Doctor Table: Fields | Data Type | Relationships | doctorid | Varchar(5) | Primary Key | doctorname | Varchar(15) | Not Null | dept | Varchar(15) | Not Null |
20
Hospital Management System
Lab Table: Fields | Data Type | Relationships | labno | Varchar(5) |