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 is Explicit update
In explicit update, each derived attribute is defined with respect to one, or more fundamental base object(s). The object designer determines that derived attributes are affected by each change to a basic attribute, and inserts code into update operation on base object to explicitly update derived attributes which depend on it.
What is a disjoint less constraint? Ans: It needs that an entity belongs to no much more than one level entity set. Disjoint less constraint needs that an entity belongs to
How to reduce data redundency
What is known as a search key? An attribute or set of attributes used to look up records in a file is known as a search key.
What Is Recovery? During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state
Define instance and schema? Instance: Collection of data kept in the data base at a particular moment is known as an Instance of the database. Schema: The o
What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.
Define Physical and Logical independence Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic
Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.
What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an
What is Relational DBMS This is our subject of study. A DBMS is relational if the data is organized into relations, that is, tables. In RDBMS, all data are kept in the well-kno
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