Inserting data 10. Enter your own information in the student table. For example, I entered the last student, Sara. dept_name tot_cred Comp. Sci.102 ID name 00128 Zhang 12345 Shankar Comp. Sci. 32...

Please answer all my questions by using sql
Inserting data<br>10. Enter your own information in the student table. For example, I entered the last student, Sara.<br>dept_name tot_cred<br>Comp. Sci.102<br>ID<br>name<br>00128 Zhang<br>12345 Shankar Comp. Sci. 32<br>History<br>Finance<br>44553 Peltier Physics<br>19991 Brandt<br>23121 Chavez<br>80<br>110<br>56<br>46<br>Physics<br>54321 williams Comp. Sci. 54<br>38<br>Physics<br>Comp. Sci. 58<br>Elec. Eng. 60<br>98765 Bourikas Elec. Eng. 98<br>Biology<br>45678 Levy<br>55739 Sanchez Music<br>70557 Snow<br>76543 Brown<br>76653 Aoi<br>98988 Tanaka<br>120<br>43123 Sara<br>Comp. Sci. 99<br>11. # Also, add an instructor into the instructor table.<br>dept_name salary<br>10101 Srinivasan Comp. Sci. 65000<br>90000<br>ID<br>name<br>12121 Wu<br>Finance<br>Music<br>15151 Mozart<br>22222 Einstein Physics<br>32343 El Said<br>33456 Gold<br>40000<br>95000<br>60000<br>History<br>Physics<br>Comp. Sci.75000<br>87000<br>45565 Katz<br>58583 Califieri History<br>76543 Singh<br>76766 Crick<br>83821 Brandt<br>98345 Kim<br>62000<br>Finance<br>80000<br>Biology<br>Comp. Sci. 92000<br>Flec. Eng l80000<br>72000<br>43612 Hamid<br>Comp. Sci. 50000<br>12. Add a new department

Extracted text: Inserting data 10. Enter your own information in the student table. For example, I entered the last student, Sara. dept_name tot_cred Comp. Sci.102 ID name 00128 Zhang 12345 Shankar Comp. Sci. 32 History Finance 44553 Peltier Physics 19991 Brandt 23121 Chavez 80 110 56 46 Physics 54321 williams Comp. Sci. 54 38 Physics Comp. Sci. 58 Elec. Eng. 60 98765 Bourikas Elec. Eng. 98 Biology 45678 Levy 55739 Sanchez Music 70557 Snow 76543 Brown 76653 Aoi 98988 Tanaka 120 43123 Sara Comp. Sci. 99 11. # Also, add an instructor into the instructor table. dept_name salary 10101 Srinivasan Comp. Sci. 65000 90000 ID name 12121 Wu Finance Music 15151 Mozart 22222 Einstein Physics 32343 El Said 33456 Gold 40000 95000 60000 History Physics Comp. Sci.75000 87000 45565 Katz 58583 Califieri History 76543 Singh 76766 Crick 83821 Brandt 98345 Kim 62000 Finance 80000 Biology Comp. Sci. 92000 Flec. Eng l80000 72000 43612 Hamid Comp. Sci. 50000 12. Add a new department "Law" in the "Watson" building with a budget of 0. If you see a problem, what could be the reason? Explain. The integrity constraint on budget does not allow a budget of 0. ||

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here