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
- 1624 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by checkpoints in dbms?
Explain some of the uses of openedge architect features useful for a developer?
What is db context?
Which free database is best?
Define b-trees.
What is built_in Subprogram ?
0 Answers BBAU Babasaheb Bhimrao Ambedkar University, HCL, TCS,
What is a system concept?
Mention some advantages of using dbms.
Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz
How to reorder the table columns (fields)?
Explain primary key and composite key.
Explain types of indexing in dbms?
-
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)
