Wilkes Sophia IT-520 Assignment 5
Assignment Deliverable #1
This shows that the database has been created.
Assignment Deliverable #2
1a). Creation of Patient table
Creation of Visit Table
1b). Insertion of data into Patient Table
Insertion of data into Visit Table
Output for Patient Table
Output for Visit Table
Patient name and number output
2. Exercise Case Page 355 1 c part i. Provide the query and its output.
Alphabetical listing of Patients
Specific Social Worker Selection
3. Case Exercise Page 355 1 c part ii. Provide the query and its output. How often has patient 8766 visited the MS Center at MVCH in a given month?
How many patients are assigned to each social worker?