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 flag in database?
Explain what are called fat clients and fat servers?
I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?
What do you mean by Correlated subquery in database?
How to load a file into database column?
Describe the difference between homogeneous and heterogeneous distributed database.
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What do you understand by aggregation and atomicity?
What are some disadvantages of a standard language such as sql?
Explain a database server?
How can you perform pattern matching in sql?
what is the use of EXP command ?
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)