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!
Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples.
Insert operation can violet any of the subsequent four constraints:
1) Domain constraints could be violated if given attribute value does not appear within corresponding domain. 2) Key constraints could be violated if given attribute value does not appear within corresponding domain. 3) Entity integrity can be violated if the primary key of the latest tuple t is NULL. 4) Referential integrity can be violated if value of any foreign key in t refers to a tuple in which does not exist in referenced relation.
Delete operation can violate only referential integrity constraints, if the tuple being deleted is referenced through the foreign keys from other tuples within the database.
Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.
what is physical data structure
Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.
Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.
What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo
What is entity in DBMS? Entity: A DBMS entity is either a thing in the modelled world or a drawing element in an ERD.
What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n
What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers
Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. A long-standing international treaty am
Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd