Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create view that shows all doctors information that treats patients who stay in hospital more than two days. Name of view: v_Doctor . [1 Mark]

Create view that shows all doctors information that treats patients who stay in hospital more than two days. Name of view: v_Doctor. [1 Mark]

Answer & output:

image text in transcribed
Hospital database REMA TOSH.SQLEXP... dbe. Patients *SOLG2.00 LTOS SQLOery-Ra TOSH PAD Flame Lame Address Phonellum Gender 100 AB Ahmed Danmam 191242 101 Ahmed Nasser Dammam 1973457 M 102 Altober 1905324 303 Wala Abdullah Alba 196582 + 304 Note Riyadh 168712 F 105 Amesh Jamal Riyadh F NULL NULL NULL NULL NULL 1982-06-02 1975-06-03 NULL * REMA-TOSH.SQLEXP..tal-dbo Doctors X SQLQuery2.0-RTOSH_rema (53) SQL Queryd sal-R-TOSH Doc.ID Name Address Salary DGender Age 200 Al Ahmed Dammam 15000.0000 M 35 201 Abdullah Hamed Dammam 11000.000 M 202 Jamal Saleh Alkhobar 10000.0000 M 29 203 Hind Ahmed Alkhabar 15000.0000 F 204 Wassen Ali Dammam 1.2000.0000 F NULL NULL NULL NULL NULL 100 REMA-TOSH SQLEX...bo.Appointments SQLQuery2.sal-R. 2-TOSHirema (3 Pat_101 Doc_101 Apt_Date Apt_Time 300 200 2013-01-03 02:30:00 201 2013-03-04 03:30:00 200 2013-02-03 02:50:00 102 202 2013-04-04 05:00:00 103 203 2013-06-05 06:30:00 103 204 2013-06-05 07:50:00 NULL NULL NULL NULL 101 300 REMA-TOSH SQLEX..bo. Patients Room XSQL Query2.sql-R-TOSHema (53) SQL Query-R-TOSHA Room D Pat3 Date Stay Room Type Numberofdays Room cost 100 2013-05-04 Single 3 NULL 301 101 2013-05-06 VIP 4 NULL 302 102 2013-05-08 Single 2 NULL 301 103 2013-06-10 VSP 1 NULL NULL NULL NULL NULL VE NULL REMA-TOSH.SQLEXP.tal- dbo.Invoice SQLQuery2.sql-ReTOSHuremo 1531 SQLQueryi.sql-1 In_01 Pat_ID2 Date Time Treatment cost Total 400 100 2013-05-04 04:30:00.000 100.0000 NULL 401 101 2013-05-06 03:30:00.000 200.0000 NULL 402 102 2013-05-08 02:20:00.000 150.0000 NULL 403 103 2013-06-10 00:00:00.000 100.0000 NULL VLI NULL NULL NULL NULL PO

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

Proli Footwear Inc An Audit And Fraud Simulation For Team-Based Student Learning

Authors: Patricia Poli, Richard Proctor

2nd Edition

0615455492, 978-0615455495

More Books

Students also viewed these Accounting questions

Question

10.3 Discuss the five steps in the performance management process.

Answered: 1 week ago