Đang Thực Hiện

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

Regards

Ben

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

Regards

Consider the following Tables:

Consultant

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

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

Visit_ID Date Time Patient_ID Consultant_ID Fee

2 02/02/2002 14:00 2 2 €[url removed, login to view]

3 02/02/2002 15:00 4 2 €[url removed, login to view]

4 02/03/2002 14:00 2 2 €[url removed, login to view]

5 02/03/2002 10:00 3 4 €[url removed, login to view]

6 02/03/2002 11:00 1 3 €[url removed, login to view]

7 02/04/2002 12:00 4 1 €[url removed, login to view]

8 02/02/2002 10:00 3 1 €[url removed, login to view]

9 04/02/2002 12:00 2 6 €[url removed, login to view]

10 02/04/2002 14:00 2 5 €[url removed, login to view]

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

table.

3

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

information:

• 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 thêm: sql get date, sql database consultant, sql consultants, powerpoint consultants, php create table, need sql help, needs project consultants, needs consultant, money table, john crane, joe carter, help need powerpoint, group o, creating php table, creating group php, create table php, sql experience, joe g, write sql project, write project, time table, table, sql work needed, sql query, sql queries

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

Mã Dự Án: #1038392

Đã trao cho:

ansi2

Ready to start

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

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

kcmakwana

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

$150 USD trong 2 ngày
(7 Đánh Giá)
3.3
vrushabh

please check pmb

$50 USD trong 2 ngày
(5 Đánh Giá)
3.1
cigara9393

check your PM...

$40 USD trong 0 ngày
(1 Đánh Giá)
2.4