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 is denormalization and why would someone consider doing so?
What is field in database give an example?
What are indexes? Mention the differences between the clustered and non-clustered index?
Explain the necessary techniques to control deadlocks?
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
What information can be stored in a database?
What is pdo in database?
Can you explain fourth normal form and fifth normal form ?
RDBMS file system can be defined as
What does a database contain?
What are the three levels of data abstraction?
What is Distributed 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)