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
Describe why operational and informational systems are separate.
What do database languages do?
What is system r? How many of its two major subsystems?
What is rdbms and also explain its components?
Why indexing is used in database?
What are the Different Types of Joins and How do They Work?
What are the Roles and responsibilities of database administrator?
What is implicit cursor in dbms?
Is google scholar a database?
What you mean by Object Relational DBMS?
What do you understand by unique key?
What are the 4 main objects of a database?
Oracle (3259)
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)