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????


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Database Management Interview Questions

What is a driver in programming?

0 Answers  


What is equi-join?

1 Answers  


What is stored procedure in database?

0 Answers  


hi, i am new to database cau give me link where can i get about databse..

0 Answers  


What are different types of data models?

0 Answers  






How to monitor firebird server activity?

0 Answers  


What is a database management system and give examples?

0 Answers  


What is the best database management system?

0 Answers  


What do you mean by index hunting?

0 Answers  


for what purpose we use MDM(master data management)tell me plz.

0 Answers  


What is the concept of sub-query in terms of sql?

0 Answers  


Define scalar functions.

0 Answers  


Categories