SIT103Y2010C_Ass1

SIT103Y2010C_Ass1 - SIT103 Database Assignment 1 Due Date Thu 16th December 2010 Trimester 3 2010 Background You will be working with a set of

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SIT103 Database - Assignment 1 Trimester 3 – 2010 Due Date: Thu 16 th December, 2010 Background You will be working with a set of tables for a clinic. To access these tables in oracle create the following synonyms: SQL> CREATE SYNONYM APPOINTMENT FOR VBRUNO.APPOINTMENT; SQL> CREATE SYNONYM DOCTOR FOR VBRUNO.DOCTOR; SQL> CREATE SYNONYM DISEASE FOR VBRUNO.DISEASE; SQL> CREATE SYNONYM DIAGNOSED FOR VBRUNO.DIAGNOSED; SQL> CREATE SYNONYM PATIENT FOR VBRUNO.PATIENT; Queries You are to prepare 15 SQL query statements that will provide answers to the following 15 requests for information. You must submit the syntax of the queries themselves, not all the output. 1. Show a list of all the doctors that have worked at the clinic for five (5) or more years. Show just the doctor’s name and order the list by the doctor’s surname then given. 2. Show the name of the patient and doctor, along with the date of the appointment, where a disease is diagnosed which is some type of “Depression”. Show only appointments during 2010. 3. Create a view called “todays_appointments”. The view should list all appointments for the current day. Include the appointment date and time, the doctor’s name, the patient’s name
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/03/2011 for the course SIT 202 taught by Professor Robindoss during the Three '09 term at Deakin.

Page1 / 3

SIT103Y2010C_Ass1 - SIT103 Database Assignment 1 Due Date Thu 16th December 2010 Trimester 3 2010 Background You will be working with a set of

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online