10. Insert the following records to BOOKS table: BookID Category Title Price Writer 1 IT SQL 50 Khalid IT Database 75 Amar BS Ethics 60 Muna 4 Math Calculus 65 Ali 11. Change the Writer of Book I to Mazin in the BOOKS table. 12. Display the unique Writer in the BOOKS table. 13. Display the Price of all books with decrease by 7.5%, use the alias "Decreased by 7.5% rials".

Q: 1. X 0 0 0 0 1 1 1 Output of F(x, y, z) y 0 0 1 1 0 0 1 Z 0 1 0 1 0 1 0 F 0 0 1 1 0 0 0

A: A Boolean function is a mathematical expression that takes binary input variables and produces…

Q: Q.43) Í Icosx – sinx\dx =

A: Introduction :

Q: Covert (0101 )6-3-1-1 D2 (A) 0100 B) 0111 C) 0100 D) 0101

A: The binary is represented in 0 and 1 and base of 2.  The binary code is classified into different…

Q: Convert the following DFA to an equivalent CFG 91 1 94 1 1 93 DFA witth 5 states 92 95

A:

Q: Convert bases. (a) 17810, base 2. (b) 2518, base 3. (c) 27.67510, base 2.

A: a.) 17810 to base 2

Q: Convert the given NFA 5. to b. a a 3.

A: Given NFA :

Q: 9- In BCD (0100) + (0110) =?

A: According to the given conditions we need to solve 4 Questions as Such: 7- (11111)GRY = (?)2 8-…

Q: 2. pi in terms of base 26 is i) C.DRS ii) D.SQR iii) D.DRS iv) D.DSS

A: iii)- D.DRS

Q: Determine the decimal values of the three values below: • (1010101010)2 • (5713)8 • (F A83)16 (a)…

A: a) Assuming the above three values are unsigned numbers.  Given number (1010101010)2 Steps to…

Q: 5. Write a PYTHON Script to find y from the below equations depending on your entry. tan(ø) - cos…

A: The approach is to make the bifurcation based on theta and phi and use the inbuilt function in the…

Q: Discussion:- 1- Write A.L.P. to transfer (M3400) which equal to (F6)H to M3600

A: Here our task is to write an assembly language program to move the value in memory location 3400 to…

Q: EV: V7: VS: MY: E5: 30: A4D: AD9: Provide the description of the following error codes, and explain…

A: Error CodeAn error code is a unique code or identifier that is used to identify a specific issue,…

Q: Explain how to break a character substitution cipher

A: Answer: Initially we are provided with a string of characters known as plain text and a number know…

Q: The intuitive method for converting fractional  values from base 2 to base 10 can be applied when…

A: The above question is solved in step 2 :-

Q: 1FC B AD I6= X Xz 47,0= Xz to

A: We have 2 values. One is in hexadecimal and we need to convert it into octal and then in binary. And…

Q: P(XUY

A: Answer P(X∪Y)⊆P(X)∪P(Y) Now this statement is true if and only if X ⊆ Y or Y ⊆ A. Suppose X ⊆ Y or X…

Q: Match each of the following integers with its equivalent representation in a different base. (32) 16…

A: Writing the integers in its decimal place We get

Q: 423 in base 5 to base 10

A: Hello student

Q: ASCII stands for A) American Standard Code for Introduction Interchange B) American Standard Code…

A: The ASCII is the character encoding format or standard used worldwide for text encoding.

Q: -10 7 8 -6 -6 0 7 1 A = -7 -1 1 7 B = -3 7 -7 -3 -6 7 -4 -2 0 -10 3 1 -3 10 -3 3 1 -4 C = 6 -8 7 D =…

A: Given:

Q: 4. For each of the following, match the values on the left to those on the right. g. CAFE 16 h.42…

A: Your answer is given below.

Q: Perform the following calculations and show your answers in their original base. (You are required…

A: 1) 2278 X 468 = 131528 Steps: First, convert into binary numbers for simpler and easy calculation…

Q: Find the following: 1-(A2) 16-(1010) 2 2. A*2C

A: Convert the number to decimal first :  The first number  - ( A2 ) 16 = - ( 10 * 161 + 2 * 160 ) = -…

Q: =Lcm(21,6) إجابتك

A: LCM of 6 and 21 is 42.

Q: Which types of data are to be avoided when using the arithmetic mean? The topic of this…

A: Definition: The trace decay hypothesis of neglecting shows that learning and review occasions have…

Q: 3 5 1 6 2 0 8 7 4

A: Solution-   1. Traversal of the Binary Tree:There are several ways to traverse a binary…

Q: 11 1 1 1001onoisins 0 1

A: Binary value:   11111001 + 10011101 = 0110010110   Decimal value: 249 + 157 = 406

Q: ( 10110111,101001 )2 = ( ? )16     Which one is the result in base 16?   ( B7,A4 )16   ( 117,104…

A: I have given an answer in step 2.

Q: λ а 92

A: Here in this question we have given € - NFA. and we have asked to find the transition  move on (qo…

Q: Create the transition table for the Mealy machive olo D/1 9₁ 0/0 (93 4/4 1/0 below:

A: Mealy machine is a finite state machine. In a mealy machine, the values of output are determined by…

Q: الرمز الرمادي (10110111101) = ()'' بالرقم العشري 931 1753 867 1877 لا احد منهم 1749 1750 869

A: Answer:

Q: Convert to base 10: a) 1101001two b) 3E5twelve

A: a) 1101001two  1.To convert to base 10 we need to multiply each digit by power of 2.   b)    3E5…

Q: Q 3).   1 0 0 1 1 0 1 1 0 1 0 0 1 1 0 ➔ 16 A. 4DA5 B. 4EA6 C. 4DA6 D. 4DB6

A: Given the binary number we have to convert it into hexadecimal number.

Q: Q 6)   11010110 ➔ 8 A. 322  B. 326 C. 331 D. 324

A:

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.