MSIS$/$IT$230$

DATA FOR INSERT STATEMENTS

The following grids contain the data to be inserted into the tables. Please note that the grid columns may not be in the same order as the table columns, so be sure your Insert statements are syntactically correct. Only insert data for the tables included in this document.

All SQL statements must be in one $.$sql file and submitted to Blackboard. DO NOT INCLUDE THE CREATE TABLE SQL FROM PHASE $2.$ You must include the following:

$1.$ Delete statements for all tables must be done first.

$2.$ Insert statements for all tables must be done second.

Remember the order is important. Delete all data from tables with foreign keys first, then delete data from all tables with just primary keys. Insert data into all tables with just primary keys first, then insert data into all tables with foreign keys.

You must use the proper naming convention for the file or it will not be graded and you will need to resubmit. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Schedule$\}\backslash \backslash$

$\backslash$hline Bmployeel & Daypincek & Sortisa & Startime & Endolime $\backslash \backslash$

$\backslash$hline PP$001$ & MO & $1$ & $12$:$00$ & $20$:$00\backslash \backslash$

$\backslash$hline PP$001$ & WE & $3$ & $8$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline PP$001$ & FR & $5$ & $12$:$00$ & $20$:$00\backslash \backslash$

$\backslash$hline AA$001$ & $1$U & $2$ & $8$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline AA$001$ & TH & $4$ & $8$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline RK$002$ & TU & $2$ & $8$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline RK$002$ & TH & $4$ & $12$:$00$ & $20$:$00\backslash \backslash$

$\backslash$hline MB$002$ & MO & $1$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline MB$002$ & TU & $2$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline MB$002$ & WE & $3$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline MB$002$ & TH & $4$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline MB$002$ & FR & $5$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline WS$001$ & MO & $1$ & $12$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline WS$001$ & $1$U & $2$ & $12$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline WS$001$ & WE & $3$ & $12$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline WS$001$ & TH & $4$ & $12$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline WS$001$ & FR & $5$ & $12$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline LC$001$ & MO & $1$ & $8$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline LC$001$ & WE & $3$ & $8$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline LC$001$ & FR & $5$ & $8$:$00$ & $17$:$00\backslash \backslash$

$\backslash$hline MB$001$ & TU & $2$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline MB$001$ & TH & $4$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline KN$001$ & MO & $1$ & $8$:$00$ & $12$:$00\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$c$|\}\{$Appointment$\}\backslash \backslash$

$\backslash$hline Aprointmentip & Patientur & Bmplayeelu & Anpipate & Startine & Duration & Status $\backslash \backslash$

$\backslash$hline APP$001$ & SJ$001$ & MB$002$ & $07/05/2023$ & $09$:$00$ & $2$ & Scheduled $\backslash \backslash$

$\backslash$hline APP$002$ & RA$001$ & AA$001$ & $09/13/2023$ & $12$:$00$ & $3$ & Scheduled $\backslash \backslash$

$\backslash$hline APP$003$ & TA$001$ & PP$001$ & $07/11/2023$ & $16$:$00$ & $1$ & Scheduled $\backslash \backslash$

$\backslash$hline APP$004$ & CM$001$ & JE$002$ & Nuil & Nuil & & $\backslash \backslash$

$\backslash$hline APP$005$ & HB$001$ & RK$002$ & $08/23/2023$ & $08$:$00$ & $1$ & Scheduled $\backslash \backslash$

$\backslash$hline APP$006$ & FLO$01$ & EL$001$ & Nuil & Nuil & & $\backslash \backslash$

$\backslash$hline APP$007$ & JW$001$ & WS$001$ & $07/25/2023$ & $15$:$00$ & $2$ & Scheduled $\backslash \backslash$

$\backslash$hline APP$008$ & MY$001$ & EL$001$ & Nuil & Nuil & & $\backslash \backslash$

$\backslash$hline APP$009$ & TA$001$ & JE$002$ & Nuil & Nuil & & $\backslash \backslash$

$\backslash$hline APP$010$ & CM$001$ & PP$001$ & $07/19/2023$ & $11$:$00$ & $2$ & Scheduled $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{3\}\{|$c$|\}\{$MericalifistoryCond$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$MericalistoryPres$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$Mericalisistorysurg$\}\backslash \backslash$

$\backslash$hline Patiendlu & MHCDate & Conditiond & Paticuthe & Merenate & Prescristion & Paticuthe & Mrisuate & Surgervil $\backslash \backslash$

$\backslash$hline SJ$001$ & $02/02/2022$ & ARIH & SJ$001$ & $02/02/2022$ & FAMO & KY$001$ & $03/02/2023$ & APP $\backslash \backslash$

$\backslash$hline NS$001$ & $05/05/2022$ & CHOL & NS$001$ & $05/05/2022$ & EZE & SJ$001$ & $07/09/2022$ & JNTREP $\backslash \backslash$

$\backslash$hline CM$001$ & $11/15/2022$ & CHSTP & HB$001$ & $06/06/2022$ & TAM & HB$001$ & $06/06/2022$ & ARTH $\backslash \backslash$

$\backslash$hline HB$001$ & $06/06/2022$ & FRACT & SJ$001$ & $09/09/2022$ & FIN & CN$001$ & $12/15/2022$ & CORON $\backslash \backslash$

$\backslash$hline SJ$001$ & $09/09/2022$ & HDACH & CN$001$ & $12/12/2022$ & WARF & SW$001$ & $05/09/2022$ & INGH $\backslash \backslash$

$\backslash$hline CN$001$ & $12/12/2022$ & CHSTP & TA$001$ & $10/12/2022$ & AMOX & SM$001$ & $02/27/2022$ & JNTREP $\backslash \backslash$

$\backslash$hline TA$001$ & $10/01/2022$ & EAR & JS$001$ & $05/13/2022$ & PROZ & & & $\backslash \backslash$

$\backslash$hline PH$001$ & $05/19/2022$ & DIAB$1$ & JW$001$ & $04/09/2022$ & AMOX & & & $\backslash \backslash$

$\backslash$hline JW$001$ & $04/09/2022$ & PNEUM & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{3\}\{|$c$|\}\{$DondayceSpecialty$\}\backslash \backslash$

$\backslash$hline Bmplaveelu & Sequence & Specialtyld $\backslash \backslash$

$\backslash$hline PP$001$ & T & FAM $\backslash \backslash$

$\backslash$hline PY$001$ & $2$ & PED $\backslash \backslash$

$\backslash$hline AA$001$ & $1$ & GENSG $\backslash \backslash$

$\backslash$hline EL$001$ & $1$ & VASSG $\backslash \backslash$

$\backslash$hline RK$002$ & $$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Assignment overview Suzie is a mouse in the big city. She needs to collect a lot of cheese that will last her throughout the cold winter months. Each day, Suzie travels to a new city to gather up all...

Q:

Java Assignment overview Suzie is a mouse in the big city. She needs to collect a lot of cheese that will last her throughout the cold winter months. Each day, Suzie travels to a new city to gather...

Q:

Java Assignment overview Suzie is a mouse in the big city. She needs to collect a lot of cheese that will last her throughout the cold winter months. Each day, Suzie travels to a new city to gather...

Q:

pls i need help with the samsung wiley Annual Report Project only the other 4 Attachment is a guideline telling you what need to be done.pls see the attached Apple company wiley Annual Report ANNUAL...

Q:

EVELINER ERG Sheet h at the 1. Enter the me celles main the past w or the form beloww w El Tease kothe head COLUMN und d These AUTOFIT SELECTION C them set the FORMAT and G 2. Enter the fol use of a...

Q:

For: Amazon year 2020 Market Update: (Sock price this weel) Price on date OVERVIEW OF FINANCIAL STATEMENT By now you have recented your Financial statement and hare narrowed your focus to one...

Q:

Please, this assignment is about Database integration, we have worked on html web page creation where we create html web pages, then we move on to the MVC application with servlet and JSP, then...

Q:

Please answer it in c++ asap, Thank you! The Basic Game Here's a crash course on the game of bowling: Each game consists of 10 frames. For each frame, 10 pins are set up at the end of the alley. The...

Q:

Pro ta Fit Reply Advanced From HE Wat Oroup Text to a Home Des Console Cute Duplica Widation Unge ube Ir from the baba Test Query Xf KS2 U 1 ID kry wa Mipais Age Prome Service medel w Do not...

Q:

Part One Make a new file database _ generator.py - inside this file you must include SQL query to create a database, create a table called Products, and it must require these columns: id , name,...

Q:

Discuss how the accuracy of cost estimates becomes more precise during a project.

Q:

What is meant by the term political risk? Is there political risk in every country of the world? Explain.

Q:

| | | | | | | | | | | | 1 1 3 of 1 9 Concepts completed Multiple Choice Question The industry life cycle stage in which the company's growth merely tracks growth in the general economy is typicaly...

Q:

Question:

Previous Question Next Question