Nursing Infromatics Question Answer 2022

Running head: NURSING INFROMATICS
Nursing Informatics
Name of the Student:
Name of the University:
Author Note

1
NURSING INFROMATICS
Answer to question number 1
The sql commands for the development of the tables and the population of data is provided
below:
-- Table structure for table `admininstrator`
CREATE TABLE `admininstrator` (
`AdminID` int(11) NOT NULL,
`AdminName` varchar(20) NOT NULL,
`AdminAddress` varchar(30) NOT NULL
) ;
-- Dumping data for table `admininstrator`
INSERT INTO `admininstrator` (`AdminID`, `AdminName`, `AdminAddress`) VALUES
(101, 'Jhon', '42 silver street'),
(102, 'Kevin', '40 Silver Spring Road'),
(103, 'Philip', '39 Lewis Road'),
(104, 'James', '44 Hudson Street');
-- Table structure for table `alert`

2
NURSING INFROMATICS
CREATE TABLE `alert` (
`AlertID` int(11) NOT NULL,
`DoseID` int(11) NOT NULL,
`StaffID` int(11) NOT NULL,
`Intervals` time NOT NULL
);
-- Dumping data for table `alert`
INSERT INTO `alert` (`AlertID`, `DoseID`, `StaffID`, `Intervals`) VALUES
(1, 1, 1, '00:15:00'),
(2, 2, 2, '00:20:00'),
(3, 3, 3, '00:10:00'),
(4, 4, 4, '00:20:00');
-- Table structure for table `diagnosis`
CREATE TABLE `diagnosis` (
`DiagnosisID` int(11) NOT NULL,
`StaffID` int(11) NOT NULL,
`DiseaseID` int(11) NOT NULL,

3
NURSING INFROMATICS
`PatientID` int(11) NOT NULL
);
-- Dumping data for table `diagnosis`
INSERT INTO `diagnosis` (`DiagnosisID`, `StaffID`, `DiseaseID`, `PatientID`) VALUES
(1, 1, 1, 1),
(2, 2, 2, 2),
(3, 3, 3, 3),
(4, 4, 4, 4);
-- Table structure for table `disease`
CREATE TABLE `disease` (
`DiseaseID` int(11) NOT NULL,
`DiseaseName` varchar(20) NOT NULL
);
-- Dumping data for table `disease`
INSERT INTO `disease` (`DiseaseID`, `DiseaseName`) VALUES
(1, 'Tuberculosis'),
(2, 'Pneumonia'),