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 five main functions of a database administrator?
What are the partitions types available in Oracle10g. How it will do? Simple example?
What is distributed queries?
Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
Explain by listing some of dbms major advantages.
What is primary key in dbms?
How do you set a primary key?
What is the difference between a delete command and truncate command?
What is data example?
Why would someone use a database?
Define join types.
Explain the Surrogate Key in DBMS.
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)