Use Microsoft SQL Software

Write SQL commands to create a SQL Server database with the structure described below. You are to hand in a printout of the SQL commands used to create the database structure. Relational Database Design This database contains information about a hospital emergency room. The database contains the following tables: patient(patientid, name, street, city, province, postalcode, nokname, nokphone) Foreign key (nokname, nokphone) references nextofkin nextofkin(nokna me, nokphone) resident(patientid, mcpnumber) Foreign key patientid references patient nonresident(patientid, creditcardnum, creditcardexpiry) Foreign key patientid references patient physician(physicianid, name) nurse(nurseid, name) visit(visitid, date, time, modeofarrival, complaint, symptoms, priority, pulserate, bloodpressure, temperature, disposition, patientid, nurseid, physicianid) Foreign key patientid references patient Foreign key nurseid references nurse Foreign key physicianid references physician test(testid, date, time, description, results, visited) Foreign key visitid references visit Diagnosis diagnosticcode, description) Treatment(treatmentname, description) Resolution(visitid, diagnosticcode, treatmentname) Foreign key visitid references visit Foreign key diagnosticcode references diagnosis Foreign key treatmentname references treatment