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!
Define single valued and multivalued attributes.
Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes.
Multivalued attributes: Attributes with a set of value for a certain entity are known as multivalued attributes.
What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data
Explain Hierarchical Model ? Hierarchical Model - It was established to model several kinds of hierarchical organizations which exist in the real world. It uses tree structur
What are the two types of serializability? The two types of serializability is a) Conflict serializability b) View serializability
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
Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and
Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if
Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of
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
What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.
Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.
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