Table Name: Books
FIELD NAME DATA TYPE CONSTRAINT
Book_ID
Book_Name
Book_Price
a. Write Data type and constraint for the above fields.
b. Write SQL Command for inserting following data in the table.
Book_ID Book_Name Product_Price
B001 Physics 275.00
B002 Info Technology 395.00
B003 English 185.00
c. Write SQL command for displaying the Book the price of which is
greater than 200.00
d. Write the SQL command for displaying the Book whose ID is “B003”
e. Write the SQL command for displaying all records.
Answers
Answered by
2
Answer: MARK ME AS BRAINLIEST THAN I ANSWER
Explanation: MARK ME AS BRAINLIEST THAN I ANSWER
Similar questions