In Class Practice Assignment: INSERT INTO statements for the Medical Lab Database

Create sample data for your Medical Lab Database.  Use a Spreadsheet Workbook or a sequence of Tables in a Word Processor to document the test data values that you will use.   Keep your Sample Size Small.  Between t5 to 10 rows per table.

Once your test data values are organized, write the SQL Statements to populate the tables of the database with your test data.  You can use all INSERT INTO Statements, or a combination of the two.  If you are using SQL LOAD Statements with your INSERT INTO Statements,  you must also include the Comma Separated Value (CSV) Files that you created to from your spreadsheet to test your Load Statements.

Upload the Following Documents for the Assignment

Spreadsheet Workbook or Word Processing Document containing the Test Data.  Must be in DOC or PDF Format

Text file containing the SQL Script to Populate the Tables of your Database

If also including LOAD Statements, include the CSV Files used with your LOAD Statements

Many Students had problems with their Schema and Metadata Documentation. If you received feedback concerning Primary and Foreign Key Problems, you may want to use the Metadata and Schema that I provided below. 

One of the main goals of this assignment is for you to create a continuous sequence of SQL statements to create the database, use the database, create the tables, and insert data into the database without the any errors.