Question
Implementation requirement: Considering the following queries, first finalize the schema (by adding required relations and/or changing the above relations) and then implement your relations. Next,
Implementation requirement: Considering the following queries, first finalize the schema (by adding required relations and/or changing the above relations) and then implement your relations. Next, populate your relations with appropriate data. Make sure each table in the database has enough number of tuples so that each query gets a meaningful and reasonable size output. For this, you should store at least 5 hospital 5 Systems department5 doctors for each department,5, 3 lab ,5patient ,3child and 5 nurse . Department of Computer Science Finally, implement the following queries in SQL. The queries are as follows. 1- Display all information about hospital and the structure of hospital able 2- Find the paint_name whose the third litter paint_name is h. 3- For each hospital find hosp_id and number of department. 4- For each department find first_name and maximum salary for all doctors when the maximum salary greater than 5000 sort the result by maximum salary in descending order 5- For each department , find nurs_name and number of nurse that have number of nurse less than 5. 6- For each Find the dept_name , paint _name,count of patient and admission date. 7- Write a query to display the last_ name, Dept_no and dept_Name name for all doctor whose work in dept_name equal surgery 8- Create query to displays the Dept_no ,first_name , and email for every doctors in the obstetrics department. 9- Find the nur_id,nurs_name,salary for all nurse whose the salary greater than minimum salary
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started