need A hospital system quaries

[shanshayan]

Ms access A hospital system has following tables?

A hospital system has following tables:

patients (patient-id, name, insurance, date-admitted, date-checked-out)
doctors (doctor-id, name, specialization)
test (testid, testname, date, time, result)
doctor-patient (patient-id, doctor-id)
test-log (testid, patient-id)
performed-by (testid, doctor-id)

1.Create appropriate tables and relationships.

Develop following quaries

2. Retrive name of all the patients in the hospital



3..Retrive the name of the doctors who treated to a patient called "Mahiya"

4..Retrive all the tests that were carried out by the doctors who are spcialized in "Gynaecology "

5.Retrive all the tests that were crried out for a patient called "Amaya" between "12/12/2000" and "2/2/2010"

I need queries. for 4,5 Please Help

[shanshayan]

any one help

[rzw0wr]

1.Create appropriate tables and relationships.

Have you created tables yet?
Are the tables properly related?

Dale

[shanshayan]

ya
i done all
but i don't know only querys