CIS 336 iLab 4 Introduction to Select , Insert , Update , and Delete Statements ( only SQL Command , No output )
way for checking that FKs have been properly created . Examples : DESCRIBE STUDENT ; SHOW CREATE TABLE STUDENT ; This is the end of Lab 3 _____ ---------------------------------------------------------------------------------------
CIS 336 iLab 4 Introduction to Select , Insert , Update , and Delete Statements ( only SQL Command , No output )
FOR MORE CLASSES VISIT www . cis336study . com
CIS336 : Lab 4 : Introduction to Select , Insert , Update , and Delete Statements
LAB OVERVIEW
Lab 4 will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables . This lab will also introduce the fundamentals of updating and deleting records . This lab may be completed using either DeVry ‘ sOmnymbus EDUPE- APP lab environment , or a local copy of the MySQL database running on your own computer using the OM database tables . The lab will utilize a set of tables that are represented by the ERD ( OM _ ERD . docx ) and are created and populated by the script file ( create _ OM _ db . sql ). Follow the instructions in the file CreateOMTables . docx to create your database , tables , and data .