Đã hoàn thành

Need Sql and table querys written for a project

I need some help creating sql queries and tables for a project i am currently doing

being honest i am stumped and need someone with proper relevant experience to

do this for me.

This needs to be done IN PDF MS WORD OR POWERPOINT

This is for display only its not needed for an actual database

in mysql, I just need this done as a guidline for future work

I am hoping i get a reply here from some reputable coder who can do this for me

all other details can be discussed in pm



Question and details below this is needed for a practice and needs to be done by today


Consider the following Tables:


Consultant_ID Firstname Surname Senior/Junior Specialism

1 Hawkeye Pierce Senior Surgeon

2 Gonzo Gates Junior Oncologist

3 Julius Hibbird Junior Psychiatrist

4 Frasier Crane Senior Psychiatrist

5 John Carter Junior Surgeon

6 Bob Kelso Senior Oncologist#


Patient_ID Firstname Surname Date_of_Birth

1 John McNamara 10/10/1965

2 Mary O'Brien 02/04/1975

3 Peter Prior 20/07/1999

4 Joe Jenkins 13/09/1951


Visit_ID Date Time Patient_ID Consultant_ID Fee

2 02/02/2002 14:00 2 2 €40.00

3 02/02/2002 15:00 4 2 €50.00

4 02/03/2002 14:00 2 2 €30.00

5 02/03/2002 10:00 3 4 €60.00

6 02/03/2002 11:00 1 3 €20.00

7 02/04/2002 12:00 4 1 €50.00

8 02/02/2002 10:00 3 1 €30.00

9 04/02/2002 12:00 2 6 €50.00

10 02/04/2002 14:00 2 5 €60.00

a) Indicate which fields are appropriate Primary Key and Foreign Key fields

for the above tables.

b) Given the Primary Keys and Foreign Keys which you have indicated in

part a, write a SQL CREATE TABLE query which would Create the Visit



c) Write a SQL query which will show all senior consultants.

d) Write a SQL query which will show all senior psychiatrists.

e) Sort the Visit table by date and time.

f) Display the total number of patients on the Visit table.

g) Display the total amount of fees payable by the patients.

h) Write a SQL query which joins two tables together to display the following


• Visit Date

• Visit Time

• Patient Firstname

• Patient Surname

i) Write a SQL query which joins all three tables together. Include the

following fields in your answer.

• Patient Firstname

• Patient Surname

• Consultant Firstname

• Consultant Surname

• Visit Date

• Visit Time

j) Write a SQL GROUP BY query which will show the total amount of money

billed by each Consultant. Include the following fields in your answer:

• Consultant_ID

• Firstname

• Surname

• Fee

Kĩ năng: PHP, SQL

Xem nhiều hơn: write sql query will show senior consultants, sql display total number patients visit table, who needs a consultant, sql get date, sql database consultant, sql consultants, powerpoint consultants, php create table, need sql help, needs project consultants, needs of a consultant, needs a consultant, need a consultant for a project, money on the table, money on table, john crane, joe carter, help i need a powerpoint, group o, get in written, get a consultant, creating php table, creating a group in php, create table php, sql display total amount fees payable patients

Về Bên Thuê:
( 1 Nhận xét ) dublin, Ireland

ID dự án: #1038392

Được trao cho:


Ready to start

$30 USD trong 0 ngày
(87 Đánh Giá)

4 freelancer đang chào giá trung bình $68 cho công việc này


php mysql expert here. Can help solving all your queries perfectly. Thanks

$150 USD trong 2 ngày
(7 Nhận xét)

please check pmb

$50 USD trong 2 ngày
(5 Nhận xét)

check your PM...

$40 USD trong 0 ngày
(1 Nhận xét)