Given the-structure and contents of the StartAPPCo database above, answer the following questions.1. Given the information above, create the StartAPPCo database.2. Write SQL code to insert data into all the tables created.3. Write the SQL code to list the employee number, last name, first name, and middle initial of allemployees whose last names start with Smith. In other words, the rows for both Smith and Smithfieldshould be included in the listing. Sort the results by employee number. 1. Table : ASSIGNMENTIASSIONVENTASON NM ASSIN SATEPROJ MM. EMP MM. ASSEN JO6 ASSIGN CHS ASSIGN HOURS ASSON CHAGE2 1422 Ma 14.222M1422M 1422M 14221-14 2222 M 14252Mar 142) Ma1423Mer 14100034.55422015 1134561001001000100100100064502242011040167550.25StartAPPCo database stores data for a consulting company that tracks all charges to projects. The14240011734.56charges are based on the hours each employee works on each project. The ASSIGNMENT table stores2Ma 1421Mer 142Me 14252Me 142501the JOB_CHG_HOUR values as an attribute (ASSIGN_CHG_HR) to maintain historical accuracy of thedata. The JOB_CHG_HOUR values are likely to change over time. In fact, a JOB_CHG_HOUR change will1013115501190 0216150187510354523-Mar14 2223Ma-142Ma-14 2524Mar 14 2524Me 14151060013 20be reflected in the ASSIGNMENT table. The structure and contents of the StartAPPCo database are30150210131shown below.10.50AM 142215110.505.0se 4524M142224Ma142M1433421511EMPLOYEEPK EMP NIMgorEMP LNAMEPK JOn_coDE2. TABLE: EMPLOYEEEMP FNAMEJOU DESCHTIONEMP INITIALaEMROVEEJOB OO HOUREMP RCDATEEN E . Eh MPA ,hewSerA reRaas AJt AeSmtteit Wm100lentJOB LAST UPOATEJOB CODE100104106106101914at fa sEMP_VLARSAkreWaing RuGehOekoWVar131510022Aup1s01HE110deadA11-Deca5 10+11116ASSIGNMENTSet Dat12113etrodDetertR11413T ASSGNNUM25 01tavrPstWamee ngeFranneTee1510102110GesdASSIGN DATE4.11719.in36500JumePROJECTPROJ NUMPK PROI NUMEMP MUM3. TABLE: JOBPROI NAMEASSGN KORPROI VALUEASSGN CHG HRPopamee AraDatere DespreCaca ge355PROI ALANCKASGN HOURShon1250024M20wEMP NUMASSIGN CHANGEeche agre20 t20w20oy 132024Mar.430 2020o-Clence Suppet26Aooimoe DesgrerTachscanC pat510184. TABLE: PROJECTE PROECTPRO RO NAE PROJ ALUE PR ALANC E NL1000 e 1021DS E IAmberSaig230 e10

Ans 1: Creating the StartAppCo database First, we have to create the database. The query for that…

Given the-structure and contents of the StartAPPCo database above, answer the following questions. 1. Given the information above, create the StartAPPCo database. 2. Write SQL code to insert data into all the tables created.

Given the-structure and contents of the StartAPPCo database above, answer the following questions. 1. Given the information above, create the StartAPPCo database. 2. Write SQL code to insert data into all the tables created.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

1 Datal.head(200) InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerlD Country 536385 85123A WHITE HANGING HEART T-LIGHT HOLDER 01/12/2010 8:28 2.55 17850 United Kingdom 536365 71053 WHITE METAL LANTERN 6 01/12/2010 8:26 3.39 17850 United Kingdom 2 536365 84406B CREAM CUPID HEARTS COAT HANGER 01/12/2010 8:28 2.75 17850 United Kingdom 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 01/12/2010 8:26 3.39 17850 United Kingdom 4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 01/12/2010 8:26 3.39 17850 United Kingdom 194 536388 21115 ROSE CARAVAN DOORSTOP 4 01/12/2010 9:59 6.75 18250 United Kingdom 195 536388 22469 HEART OF WICKER SMALL 12 01/12/2010 9:59 1.65 18250 United Kingdom 196 536388 22242 5 HOOK HANGER MAGIC TOADSTOOL 12 01/12/2010 9:59 1.65 18250 United Kingdom 197 536389 22941 CHRISTMAS LIGHTS 10 REINDEER 6 01/12/2010 10:03 8.50 12431 Australia 198 536389 21622 VINTAGE UNION JACK CUSHION COVER 8 01/12/2010 10:03 4.95 12431 Australia 199 rows x 8 columns Task…
ID Student Number Surname Name Test 1 Test 2 Test 3 Test 4 Final mark PASS/FAIL 1 217545455 Johaness Wheeler 45% 34% 49% 21% 37 FAIL 2 217452154 David Albertina 45% 34% 49% 4% 33 FAIL 3 217454151 Waldo Gertze 75% 75% 63% 88% 75 PASS 4 217486414 Kalimbo Andreas 51% 56% 90% 90% 72 PASS 5 217454155 Hakweenda Junior 44% 28% 35% 14% 30 FAIL Answer the following questions using the table above Use student 2017 table to create a query that will display Student Number, Surname, Name and Pass/Fail field for all the students whose final result is "PASS". Save the query as "Pass". Use student 2017 to create a query that will display the student's surname and final mark field for all the students whose final mark is between 0 - 40. Save the query as "Fail" Use student 2017 to create a query that will display the student number and surname for all the students whose surname consist of letter "O" in it. Save the query as "Surname".
Use the diagram to answer the following questions: 0000 80 cc 9c 00 a6 ca 6c 6a 77 43 c1 5f 08 00 45 00 0010 00 34 a2 5e 40 00 80 06 00 00 co a8 00 ee 34 d9 0020 43 7c c8 4e 01 bb ab 4a 0030 fa fø 39 32 00 00 02 04 05 b4 01 03 03 08 01 01 53 e4 00 00 00 00 80 02 0040 04 02 Is the message going from Client to Server, or Server to Client? (circle the correct message direction) b. What protocol is associated with the well-known port in this segment? c. What part of the conversation is this segment? (setup, middle, teardown) а.
Convert: from (26)10 to (?)2 from (2343)8 to (?)16 from (0.6800)10 to (?)2 from (0.111)2 to (?)10
Task 3: Amazon wants to find the best customer and likes to reward 50% discount on his next purchase. Find the Customer with the highest amount of total purchase amount. The output should the one as below: ]: 1 from IPython.display import Image 2 Image(filename = "Screenshot_72.jpg') ]: Custoner ID:16229 is the best custoner since he has spent a lot on our business. His total purchase amount is 3702.12 pesos.5e1 discount will be given on his next purchase
* If X= (53)oct X + (111010)Gray X+ (1110110)Ex-3 X+ (43)10 X+ (2B)Hex
Evaluate the expression (11011∧01011)⊕(00001∨00111)
Computer Science pamuk_uretimi YEAR_ birincifarki alinmis_ser var var var 1 19579 1932 2 27791 1933 8212 3 37762 1934 9971 4 52228 1935 14466 51068 1936 -1160 6 67185 1937 16117 64731 1938 -2454 8 63950 1939 -781 9 77115 1940 13165 10 64184 1941 -12931 11 74055 1942 9871 12 53392 1943 -20663 13 58916 1944 5524 14 54379 1945 -4537 15 59027 1946 4648 16 51456 1947 -7571 17 58198 1948 6742 18 104156 1949 45958 19 118377 1950 14221 20 150000 1951 31623 21 165000 1952 15000 Do it using Box and Jenkins Method and R program.
a) Normalize the following table to the third normal form. PROJ NUM PROJ NAME 15 Evergreen 18 22 25 Amber Wave Rolling Tide Starflight EMP_NUM 103 101 105 106 102 114 118 104 112 105 104 113 111 106 107 115 101 114 108 118 112 EMP NAME June E Arbough John G News Alice K Johnson William Smithfield David H. Senior Annelise Jones James J. Frommer Anne K. Ramoras * Darlene M. Smithson Alice K Johnson Anne K. Ramoras Delbert K. Joenbrood Geoff B. Wabash William Smithfield Maria D. Alonzo Travis B Bawangi John G. News T Annelise Jones Ralph B. Washington James J. Frommer Darlene M. Smithson 8 JOB CLASS Elect Engineer Database Designer Database Designer Programmer Systems Analyst Applications Designer General Support Systems Analyst DSS Analyst Database Designer Systems Analyst Applications Designer Clerical Support Programmer Programmer Systems Analyst Database Designer Applications Designer Systems Analyst General Support DSS Analyst CHG HOUR HOURS 84.50 105.00 105.00 35.75 96.75 48 10…
Evaluate the expression (11011∧01011)⊕(00001∨00111) . A) 01011 B) 00111 C) 01100 D) 01010
ASCII Table Dec Hex Oct Char 0 0 0 1 1 1 2 3 4 5 6 7 8 9 10 11 one em5 6 7 8 9 2012 242525728 29 30 31 +SSTABLOLAAN194944 0123456017845252730 1 2 33 34 35 36 37 55 55 可 58 59 50 61 2 3 12 13 14 16 17 18 19 2 3 23 4 26 5 6 7 15 F 8 А с D E 10 11 12 13 15 16 17 18 18. 1C 1D 1E 2 1F 3 4 5 6 7 31 Dec Hex Oct Char 32 20 40 [space] 33 21 34 22 32 35 36 37 38 39 40 42 43 44 41 29 45 46 47 48 49 50 51 52 53 54 NNN 57 23 24 NN 62 34 25 26 46 27 47 28 35 36 56 38 37 51 2A 52 2B 2C 2D 2E 2F 30 31 32 33 39 60 3C 662852818 41 ! H 3D 42 3E 43 44 45 63 3F 53 54 55 56 57 60 61 62 63 64 S5 矽012345无刀 50 ( 65 66 3A 72 3B 73 # 见识的非 74 75 $ 76 % 77 & ) + COLEM & IT co...VIA 1 67 7 2 70 8 3 71 9 4 5 6 = > ? Dec Hex Oct Char 科 5 6 印酸的 70 12及45万刀龙鸡0128455幻89012 95 94 95 0123456880=F501望3科5%望859弘8 50 50 无 55 64 65 66 67 68 69 71 47 72 73 74 75 76 77 79 83 44 86 4A 78 4E 93 4B 4C 4D 87 57 5A 5B 5C 5D 5E 5F 100 101 102 103 104 105 106 107 110 111 113 114 115 116 117 120 112 J 121 122 123 124 125 126 127 130 131…
(c) Table below shows a dataset of contacts: Max Temp (°C) Weight (kg) 67 Height (cm) 163 Gender Company Good Friend Abu 37 M Ben 37 51 154 M Good Christine 28 76 182 Bad Dennis 29 68 159 M Good Eliza 28 99 151 F Bad Farhan 38 105 184 M Good Gina 34 51 160 Bad Hua 26 96 156 F Bad Iris 25 60 184 Bad John 26 63 184 M Good Kelvin 27 72 167 M Bad Latifa 26 106 155 F Good Maria 36 86 185 F Bad Ning 29 105 174 M Good Based on the table below, plot any TWO(2) charts to represent the CS Scanujingifomationn Scanner Max Temp ii. Weight