Lab1SubmissionTemplate - MET CS 669 Database Design and...

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 Submission This submission template is a convenient document for you to provide the screenshots and explanations for Lab 1. This submission template is intended to be used in conjunction with the 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 Person table illustrated below: This Person table has three columns -- person_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 Person( person_id DECIMAL (12), first_name VARCHAR (256), last_name VARCHAR (256) ); INSERT INTO Person (person_id, first_name, last_name) VALUES (1, 'John', 'Smith'); SELECT * FROM Person;
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 Person SET last_name = 'Glass' ; SELECT * FROM Person; DELETE FROM Person ; SELECT * FROM Person; DROP TABLE Person ;
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 Person;
Image of page 4
SECTION TWO The goal of Section Two is to apply what is learned in Section 1 to create and populate the following table: This Book table has three columns -- book_id, title, and subtitle -- with data types specified in the diagram above. 19. Execute the command to create the Book table. Capture a screenshot of the command and the result of its execution.
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