Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bookkeeping And Accounting For Beginners

Authors: D.K. Livingston

1st Edition

1686248598, 978-1686248597

More Books

Students also viewed these Accounting questions

Question

Summarize some human resource management training initiatives.

Answered: 1 week ago

Question

Summarize the training and development process.

Answered: 1 week ago

Question

Explain the concept of careers and career paths.

Answered: 1 week ago