Lab1HealthSubmissionTemplate - MET CS 669 Database Design...

Info icon This preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
MET CS 669 Database Design and Implementation for Business Lab 1 Health Submission This submission template is a convenient document for you to provide the screenshots and explanations for Health Lab 1. This submission template is intended to be used in conjunction with the Health Lab 1 Instructions document. The instructions document illustrates how to correctly execute each SQL construct, explains important theoretical and practical details, and contains the complete set of instructions on how to complete this lab. Name : Date: Page 1 of 12 Copyright 2012-2015 Boston University. All Rights Reserved.
Image of page 1

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

View Full Document Right Arrow Icon
SECTION ONE In Section One we will create the Patient table illustrated below: This Patient table has three columns -- patient_id, first_name, and last_name -- with data types specified in the diagram above. 2. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. 4. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. 6. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. Page 2 of 12 CREATE TABLE Patient( patient_id DECIMAL (12), first_name VARCHAR (256), last_name VARCHAR (256) ); INSERT INTO Patient (patient_id, first_name, last_name) VALUES (1, 'John', 'Smith'); SELECT * FROM Patient;
Image of page 2
8. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. 10. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. 12. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. 14. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. 16. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. Page 3 of 12 UPDATE Patient SET first_name = 'Jane' ; SELECT * FROM Patient; DELETE FROM Patient ; SELECT * FROM Patient; DROP TABLE Patient ;
Image of page 3

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

View Full Document Right Arrow Icon
18. Insert a screenshot of executing the following SQL command, ensuring that the results of the execution are also shown. Page 4 of 12 SELECT * FROM Patient;
Image of page 4
SECTION TWO The goal of Section Two is to apply what is learned in Section 1. We will use to the following table to do so: This Medication table has three columns -- medication_id, brand_name, and generic_name -- with data types specified in the diagram above.
Image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern