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
What are the differences between drop, truncate and delete commands?
Explain what is an Exception ?
Is it good to save image in database?
Explain what are triggers and rules?
What do you understand by index hunting?
What is 2nf in dbms?
What are the various types of relationships in database? Define them.
What is compound key?
What is a database in computer?
What is the purpose of database?
What type of file is used for porting Forms 4.5 applications to various platforms?
when A set of Dictionary tables are created ?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)