Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Problem :
(b) A deductive database system is essentially the outcome of applying mathematics logic to database management, where logic is used for both data representation and data manipulation.
(i) Explain the relationships and the differences between a deductive databases and relational databases. (ii) In the context of deductive databases, explain the following concepts:
♦ Intentional database. ♦ Extensional database. ♦ Recursive query.
With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee
Sub query in the UPDATE command : Example : //Double the commission for employees, who have got at least 2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE
A field-groups statement or an insert statement reverses storage space and transfers values. False.
What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs
What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini
Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.
List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization
When are two schedules said to be view equivalent? Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met
Define the notation for classes and atrributes The notation for class, attribute, and operations are shown below: Figure: Class with attributes and operations A
Special comparison operator used in where Clause a. between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd