Class Diagram Medical Data Patient data + Id int Pk () Id int Pk Room Data + Medical History Varchar(40) Patient Id Varchar(30) First Name Varchar (30) Last Name Varchar (35) Date of Birth Date ()...

Extracted text: Class Diagram Medical Data Patient data + Id int Pk () Id int Pk Room Data + Medical History Varchar(40) Patient Id Varchar(30) First Name Varchar (30) Last Name Varchar (35) Date of Birth Date () Gender fk int (10) Emergency Con int (30) Medical int (30) Address Varchar (40) + Id int Pk () + Rooms_level varchar(20) +Rooms Varchar(20) Fuse + Doctor Varchar (40) + Assign Med History () + Assign Room Level () + Assign Record Room() + Store Doctors Room () + Assign Doctor 0 Use Store Patient Data () Gender Type Class Use Id # int Pk Gender_Name Varchar (10) Check ups Blood Class + Id int Pk () Visit Date int () Check up history () Assign type of Gender () + Id int Pk () + Blood type varchar (20) + Count Visit() + Count Check ups () + Assign Check up history() + Store type of Blood Emergency Contact Id int pk First Name Varchar(40) Last Name Varchar (40) Address Varchar (100) Gender int (10) Phone number (15) Parent type int (20) use Doctors + Id int Pk() + Doc Name varchar (40) Store Emergency Contact Patient Data Sickness Class + Id int pk () + sickness type Varchar( 30) -Store Doctor Name Use + Store type of sickness Emergency Contact Id Int Emer_cont_Name Varchar (40) Assign type Emergency () Question: Create a database in microsoft sql server from the above diagram, tables, add and delete records, apply constraints on the columns, create indexes, relationships, views and query data using a view.