Answer / hr@tgksolutions.com

The four core database management operations are Create, Read, Update, and Delete, or CRUD for short.

Create: To add new records to a table, use the INSERT INTO statement.
Read: To extract data from a table, use the SELECT statement.

Update: To make changes to already-existing records, use the UPDATE statement.
Delete: To eliminate records, use the DELETE FROM statement.

What is TERM ?

1 Answers  

---

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

0 Answers  

---

Describe why operational and informational systems are separate.

0 Answers  

---

what the List of Values (LOV) supports ?

2 Answers  

---

What do you understand by proactive, retroactive and simultaneous update?

0 Answers  

---

What is the purpose of normalisation?

0 Answers  

---

What is built_in Subprogram ?

0 Answers   BBAU Babasaheb Bhimrao Ambedkar University, HCL, TCS,

---

Define checkpoint.

0 Answers  

---

How many rows can a database hold?

0 Answers  

---

What is the main purpose of database?

0 Answers  

---

hello to all i want code for like this site "Submit Question" page.please give answers thanks.

0 Answers  

---

What is system r? How many of its two major subsystems?

0 Answers  

---