Question: hi , i want sql commend for thise data Patient ( P_ID , P_Gender, P_PHONE, P_NAME, P_AGE) Clinic ( C_ID , C_NAME, C_TIME, D_ID ,

hi , i want sql commend for thise data

Patient (P_ID, P_Gender, P_PHONE, P_NAME, P_AGE)

Clinic (C_ID, C_NAME, C_TIME, D_ID, P_ID )

Doctors (D_ID, D_AGE, LEVEL, Specialization, D_NAME)

Appointments ( A_ID, TYPE, DATA, DESCRIPTION, C_ID)

Medications ( MID, MNAME, MCOMPNY, MTYPE, COST, P_ID, C_ID)

1-create table

2- insert 3 record

3-update

4-select date

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

hi please i want SQL Statements (DDL & DML) for this ERD diagram pleasee answer this question as soon as posible today is mu deadline please do it i want a SQL Statements (DDL & DML) codes for this...

Q:

In C++. Add as many comments as possible to make it easier to understand. Both parts need to be done separately Case.txt contains the following This file shows all the test case names, and what will...

Q:

hi, I want you to help me to continue my left problems, I did not know why shows 'no data found' in my SQL code run. please help me to finish questions 5 6 7 ,8,9. there is my left questions: and...

Q:

Hi this is sql coding languaged from database management system question. Please provide me with the answer in 30 minutes. The deadline is soon 2. Consider a 'Owner-Pet' database with three tables -...

Q:

Required in C++ Required in C++ For this assignment, we want to process WORDS in input files and, potentially, change some of those WORDS before printing them out. For our assignment, a WORD is a...

Q:

For this assignment, we want to process WORDS in input files and, potentially, change some of those WORDS before printing them out. For our assignment, a WORD is a sequence of characters, separated...

Q:

WRITE THE CODE WITH C++ PROGRAM. PLEASE HEPL WILL RATE. For this assignment, we want to process WORDS in input files and, potentially, change some of those WORDS before printing them out For our...

Q:

C++ Your program will process a file containing SUBSTITUTIONS and a file containing WORDS. Each SUBSTITUTION in the first file is a replacement rule for WORDS in the second file. Your program should...

Q:

Hi i want to achieve this in sql; The most active seller (the one who has offered the most number of items) The most active buyer (the one who has bought the most number of items) The most popular...

Q:

hi, I want the short answer to answer this question ( 3 lines ) , please 1- How to use a view in a database to increase data security? Simply put, VIEWS are virtual tables .By virtual, we mean, the...

Q:

We are working towards an actual importation into Canada (simulation) The work that you will be doing involves creativity and attention to detail. 1. Create a company in Canada (you are now the...

Q:

R&R. Inc., purchased a new machine on September 1, 2009, at a cost of $180,000. The machine's estimated useful life at the time of the purchase was five years, and its residual value was $10,000....

Q:

12.62 In the Department of Fisheries and Wildlife Conservation at Virginia Tech, an experiment was conducted to study the effect of stream characteristics on fish biomass. The regressor variables are...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

Draft a proposal for a risk assessment exercise.

Q:

Understand the business case for equal opportunities and be able to identify how it applies in differing organisations.

Q:

Assess the implications of putting a policy into practice and evaluating the success of initiatives in this area.