(Solved) : Write Single Sql Statement Satisfy Requirement 1 Hospital Data Model Write Sql Add Record Q37204903 . . .
write a single SQL statement to satisfy each requirement:
1-Hospital data model: Write the SQL to add a record to theJobType table. JobTypeID is an identity attribute. Make up valueswhere necessary.
2-HOSPITAL: Write a user defined function which will receive asinput a room number and return the name of the department to whichthat room is assigned. RoomNum is an int data type and DeptName isa varchar field of size 20. Do not include any comments in youranswer but naming is a graded part of the question. DO NOT WRITE ANSQL STATEMENT TO USE THIS FUNCTION.
Expert Answer
Answer to write a single SQL statement to satisfy each requirement: 1-Hospital data model: Write the SQL to add a record to the Jo…
OR