MySQL Project, KimTay Pet Supplies and StayWell Student Accomodation questions 1-6. Input and output would be appreciated. QL WorkbenchMigration XLocal instance MySQL80 xEdit View Query Database ServerSQLtor:GEMENTServer StatusClient ConnectionsUsers and PrivilegesStatus and System VariablesData ExportData Import/RestoreNCEStartup/ShutdownServer LogsOptions FileRMANCEDashboardPerformance ReportsPerformance Schema Setupstrationationumn: last_nameSchemaslation:3_general_ciFinition:ast_name varchar(45)InfoSessionor closedType here to searchDEQuery 1121321414151656910111078LL218 19 .20OutputVDF0Action OutputTools Scripting HelpTimeSQL File 1*create table REP;REP ID char (2) PRIMARY KEY,FIRST NAME varchar(20),LAST_NAME varchar(20),ADDRESS varchar(20),CITY varchar(15),ESTATE char(2),POSTAL char(5),CELL PHONE char(12),COMMISSION DECIMAL (7,2),RATE DECIMAL (3,2),);insert into KIMTAY.SALES_REP values('05', 'Susan', 'Garcia',42 Mountain Ln, Codyinsert into KIMTAY. SALES_REP values('15', 'Donna','Smith',insert into KIMTAY.SALES_REP values('10', 'Richard', 'Miller', '87 Pikes Dr',312 Oak Rd,insert into KIMTAY.SALES_REP values ('20', 'Daniel', 'Jackson', '19 Lookout DrRalstonPowell,Elk Butte,2 31-17-09 presta datahaea STAYWEUOActionSQL File 2* x SQL File 3*%R TG5BYHSQL File 4*Limit to 1000 rows#87U99+KWMessageNYWXNY82414, 307-824-1245, 12743.16,8244082448 387-486-43211, 20872.11,387-982-8401 14912.92,(307-883-9481Error Code: 1007. Can't crasta datahaca otswall datahaca avieto00.06,P0.04);8.06);0.84);8.84);88°F ^ QContext Help Snippetsto 4)prt scSQLAdditi1Autom.disabled.manuallcurrent catoggle aDuration/ Fetch0.000 ser6:45 PM9/21/2022deletebackspace 2.3.1.To print a copy of your commands and results using Oracle, use the browser's PrintYou may also consult with your instructor for any specific instructions on how she/he wmand on the File menu or click the Print button on the browser's toolbar.like your work submitted.Kim Tay Pet SuppliesUse SQL to complete the following exercises.6.shown in Figure 3-15 except the LAST NAME column should use the VARCHAR data typeand the COMMISSION and RATE columns should use the NUMERIC data type. ExecutaCreate a table named REP. The table has the same structure as the SALES REPthe command to describe the layout and characteristics of the REP table.Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser,address: 427 Billings Dr.; city: Cody; state: WY; postal: 82414; cell phone: 307-555-6309,Run the script file for the Kim Tay Pet Supplies database to create the five tables and addcommission: 0.00; and rate: 0.05. Display the contents of the REP table.Delete the REP table.you areusing (MySQL, Oracle, or SQL Server). (Note: If you do not have the script files for thisrecords to the tables. Be sure to select the script file for the particular DBMS thattext, ask your instructor for assistance.)5.2.Module 33.4.com1.comparingConfirm that you have created the tables correctly by describing each table andthe results to Figures 3-15, 3-39, 3-41, 3-43, and 3-45.Confirm that you have added all data correctly by viewing the data in each table and com-paring the results to Figure 2-1 in Module 2.Critical ThinkingReview the data for the ITEM table in Figure 2-1 in Module 2 and then review thedata types used to create the ITEM table in Figure 3-34. Suggest alternate data typesfor the DESCRIPTION, ON_HAND, and STOREHOUSE fields and explain yourrecommendations.Stay Well Student AccommodationUse SQL to complete the following exercises.1.Create a table named SUMMER SCHOOL_RENTALS. The table has the same structureas the PROPERTY table shown in Figure 3-48 except the PROPERTY_ID and OFFICEshould be changed to WEEKLY RENT. Execute the command to describe the layout andNUMBER columns should use the NUMBER data type and the MONTHLY_RENT columncharacteristics of the SUMMER SCHOOL RENTALS table.Add the following row to the SUMMER SCHOOL RENTALS table: property ID: 13; officeID: 1; address: 5867 Goodwin Ave; square feet: 1,650; bedrooms: 2; floors 1; weekly rent:400; owner number: CO103.Delete the SUMMER SCHOOL RENTALS table.Fun the script te for the SyncOracle, or SQL Server (Noinstructor for assistance)Confirm that you have created the tables conectly by describing nach table and comparingthe results to Figures 3-48.Confirm that you have added all data corectly by viewing the data in each table and comparing the results to Figures 1-4 through 19 in Module 1OFFICECOLUMNOFFICE NUMOFFICE NAMEADDRESSAREACITYSTATEZIP CODETYPEDECIMALOWNERCOLUMNOWNER NUMLAST NAMEFIRST NAMECITYADDRESSCHARCHARCHARSTATEZIP CODETYPECHARCHARCHAR25PROPERTYCOLUMNPROPERTY IDOFFICE NUMADDRESSSQR FTCHARBDRMSCHARLENGTHCHAR2CHARTYPE25DECIMAL PLACES NULLS ALLOWEDDECIMALDECIMALCHARLENGTH22Property ID (primary key)Number of office managing the propertyProperty addressProperty size in square factNumber of bedrooms of the propertyNumber of floorsFLOORSMONTHLY RENTOWNER NUMMonthly property rentNumber of property ownerFIGURE 3-48 Table layouts for the StayWell Student Accommodation databaseDECIMALDECIMALDECIMAL25.5DECIMALCHARDECIMAL PLACES NULLS ALLOWED DESCRIPTIONOkner zip code25

Question

MySQL Project, KimTay Pet Supplies and StayWell Student Accomodation questions 1-6. Input and output would be appreciated. QL WorkbenchMigration XLocal instance MySQL80 xEdit View Query Database ServerSQLtor:GEMENTServer StatusClient ConnectionsUsers and PrivilegesStatus and System VariablesData ExportData Import/RestoreNCEStartup/ShutdownServer LogsOptions FileRMANCEDashboardPerformance ReportsPerformance Schema Setupstrationationumn: last_nameSchemaslation:3_general_ciFinition:ast_name varchar(45)InfoSessionor closedType here to searchDEQuery 1121321414151656910111078LL218 >19 .20OutputVDF0Action OutputTools Scripting HelpTimeSQL File 1*create table REP;REP ID char (2) PRIMARY KEY,FIRST NAME varchar(20),LAST_NAME varchar(20),ADDRESS varchar(20),CITY varchar(15),ESTATE char(2),POSTAL char(5),CELL PHONE char(12),COMMISSION DECIMAL (7,2),RATE DECIMAL (3,2),);insert into KIMTAY.SALES_REP values('05', 'Susan', 'Garcia',42 Mountain Ln, Codyinsert into KIMTAY. SALES_REP values('15', 'Donna','Smith',insert into KIMTAY.SALES_REP values('10', 'Richard', 'Miller', '87 Pikes Dr',312 Oak Rd,insert into KIMTAY.SALES_REP values ('20', 'Daniel', 'Jackson', '19 Lookout DrRalstonPowell,Elk Butte,2 31-17-09 presta datahaea STAYWEUOActionSQL File 2* x SQL File 3*%R TG5BYHSQL File 4*Limit to 1000 rows#87U99+KWMessageNYWXNY82414, 307-824-1245, 12743.16,8244082448 387-486-43211, 20872.11,387-982-8401 14912.92,(307-883-9481Error Code: 1007. Can't crasta datahaca otswall datahaca avieto00.06,P0.04);8.06);0.84);8.84);88°F ^ QContext Help Snippetsto 4)prt scSQLAdditi1Autom.disabled.manuallcurrent catoggle aDuration/ Fetch0.000 ser6:45 PM9/21/2022deletebackspace 2.3.1.To print a copy of your commands and results using Oracle, use the browser's PrintYou may also consult with your instructor for any specific instructions on how she/he wmand on the File menu or click the Print button on the browser's toolbar.like your work submitted.Kim Tay Pet SuppliesUse SQL to complete the following exercises.6.shown in Figure 3-15 except the LAST NAME column should use the VARCHAR data typeand the COMMISSION and RATE columns should use the NUMERIC data type. ExecutaCreate a table named REP. The table has the same structure as the SALES REPthe command to describe the layout and characteristics of the REP table.Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser,address: 427 Billings Dr.; city: Cody; state: WY; postal: 82414; cell phone: 307-555-6309,Run the script file for the Kim Tay Pet Supplies database to create the five tables and addcommission: 0.00; and rate: 0.05. Display the contents of the REP table.Delete the REP table.you areusing (MySQL, Oracle, or SQL Server). (Note: If you do not have the script files for thisrecords to the tables. Be sure to select the script file for the particular DBMS thattext, ask your instructor for assistance.)5.2.Module 33.4.com1.comparingConfirm that you have created the tables correctly by describing each table andthe results to Figures 3-15, 3-39, 3-41, 3-43, and 3-45.Confirm that you have added all data correctly by viewing the data in each table and com-paring the results to Figure 2-1 in Module 2.Critical ThinkingReview the data for the ITEM table in Figure 2-1 in Module 2 and then review thedata types used to create the ITEM table in Figure 3-34. Suggest alternate data typesfor the DESCRIPTION, ON_HAND, and STOREHOUSE fields and explain yourrecommendations.Stay Well Student AccommodationUse SQL to complete the following exercises.1.Create a table named SUMMER SCHOOL_RENTALS. The table has the same structureas the PROPERTY table shown in Figure 3-48 except the PROPERTY_ID and OFFICEshould be changed to WEEKLY RENT. Execute the command to describe the layout andNUMBER columns should use the NUMBER data type and the MONTHLY_RENT columncharacteristics of the SUMMER SCHOOL RENTALS table.Add the following row to the SUMMER SCHOOL RENTALS table: property ID: 13; officeID: 1; address: 5867 Goodwin Ave; square feet: 1,650; bedrooms: 2; floors 1; weekly rent:400; owner number: CO103.Delete the SUMMER SCHOOL RENTALS table.Fun the script te for the SyncOracle, or SQL Server (Noinstructor for assistance)Confirm that you have created the tables conectly by describing nach table and comparingthe results to Figures 3-48.Confirm that you have added all data corectly by viewing the data in each table and comparing the results to Figures 1-4 through 19 in Module 1OFFICECOLUMNOFFICE NUMOFFICE NAMEADDRESSAREACITYSTATEZIP CODETYPEDECIMALOWNERCOLUMNOWNER NUMLAST NAMEFIRST NAMECITYADDRESSCHARCHARCHARSTATEZIP CODETYPECHARCHARCHAR25PROPERTYCOLUMNPROPERTY IDOFFICE NUMADDRESSSQR FTCHARBDRMSCHARLENGTHCHAR2CHARTYPE25DECIMAL PLACES NULLS ALLOWEDDECIMALDECIMALCHARLENGTH22Property ID (primary key)Number of office managing the propertyProperty addressProperty size in square factNumber of bedrooms of the propertyNumber of floorsFLOORSMONTHLY RENTOWNER NUMMonthly property rentNumber of property ownerFIGURE 3-48 Table layouts for the StayWell Student Accommodation databaseDECIMALDECIMALDECIMAL25.5DECIMALCHARDECIMAL PLACES NULLS ALLOWED DESCRIPTIONOkner zip code25

Accepted Answer

BELOW STEP BY STEP COMPLETE SOLUTION REGARDING YOUR PROBLEM WITH EXPLANATIONS