Create a user Nurse. (Screenshot 1) Create a database Hospital. (Screenshot 2) Grant Nurse privileges to Hospital (Screenshot 3) As Nurse, create a table Patients with the following structure....

Create a user Nurse. (Screenshot 1)<br>Create a database Hospital. (Screenshot 2)<br>Grant Nurse privileges to Hospital (Screenshot 3)<br>As Nurse, create a table Patients with the following structure. (Screenshot 4)<br>PatientID<br>RoomNo<br>FirstName<br>LastName<br>Admission<br>Temperature double(10,2)<br>int(8)<br>Primary Key and not null<br>int(4)<br>varchar(14) not null<br>varchar(14) not null<br>datetime<br>Use a command to describe the table(Screenshot 5)<br>Insert 2 patients randomly to the above table(Screenshot 6)<br>Show all the contents of the table. (Screenshot 7)<br>

Extracted text: Create a user Nurse. (Screenshot 1) Create a database Hospital. (Screenshot 2) Grant Nurse privileges to Hospital (Screenshot 3) As Nurse, create a table Patients with the following structure. (Screenshot 4) PatientID RoomNo FirstName LastName Admission Temperature double(10,2) int(8) Primary Key and not null int(4) varchar(14) not null varchar(14) not null datetime Use a command to describe the table(Screenshot 5) Insert 2 patients randomly to the above table(Screenshot 6) Show all the contents of the table. (Screenshot 7)

Jun 11, 2022

SOLUTION.PDF

Create a user Nurse. (Screenshot 1) Create a database Hospital. (Screenshot 2) Grant Nurse privileges to Hospital (Screenshot 3) As Nurse, create a table Patients with the following structure....

Get Answer To This Question

Related Questions & Answers

Submit New Assignment