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????
- 0 Answers
- 1548 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is father dbms?
What is dbms function?
All questions related to Control m monitoring tool
How do you link a spreadsheet to a website?
What do you mean by conflict serializability in dbms?
does pl/sql support “overloading”? Explain
Define stored procedures.
What is the use of ANALYSE ( Ver 7) option in EXP command ?
How do you delete a table from database?
What is rdbms table?
Explain top-n analysis in DBMS.
0 Answers ITC Indian Tobacco Company,
How many types of rdbms are there?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
