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!
What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer.
There are three primary update separation on relations: (i) Insert : It is used to insert a latest tuple or tuples in a relation. Insert can violate any of the four tuples of constraints: Domain constraints, key constraints, entity integrity and referential integrity (ii) Delete : It is used to delete tuples. The delete operation can violate just referential integrity, if the tuple being deleted is referenced through the foreign keys from other tuples in the database (iii) Modify: It is used to change value of a few attributes in existing tuples. Modify can also violate any of the four constraints as specified within insert operation.
Examples: (1) Inserting a tuple having null value for primary key violates entity integrity (2) Deleting a tuple in a table for that tuples exist other tables that are dependent on those tuples will violate referential key integrity. (3) Modifying a primary key attribute to any other such that is aheady exists in the table will violate entity integrity.
Define the terms i) DDL ii) DML DDL: Data base schema is specified by a set of definitions expressed by a special language known as a data def
Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change
Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both
Explain weak and strong entity sets? Weak and Strong entity sets: A physically powerful entity set has a primary key. All tuples in the group are distinguishable through that k
In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.
What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha
Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the
You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup
Discuss deferred update technique of recovery. What are the advantages? Ans: The deferred update methods do not physically update the database on disk till after a transact
Data Redundancy -A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main ro
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