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  

---

When connection to database is failed, Which exception will be thrown?

0 Answers   MCN Solutions,

---

How do you create a database?

0 Answers  

---

List few disadvantages of file processing system.

0 Answers  

---

What are the basic components of notification services?

0 Answers  

---

---

What are the main components of a database in healthcare?

0 Answers  

---

Explain the advantages and disadvantages of a hierarchical database?

0 Answers  

---

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers  

---

How do you create a simple database?

0 Answers  

---

what the List of Values (LOV) supports ?

2 Answers  

---

What is limit in dbms?

0 Answers  

---

What is the difference between shrink database and shrink file?

0 Answers  

---