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!
Describe the two alternatives for specifying structural constraints on relationship kinds?
Relationship kinds have certain constraints in which limit the possible combination of entities that might participate in relationship. An example of a constraint is in which if we have the entities Doctor and Patient, the organization might have a rule that a patient cannot be seen through more than one doctor. This constraint needs to be elaborates in the schema. There are two major kinds of structural relationship constraints on: cardinality ratio, and participation.
Compare the Nested-loop join and block-nested loop join Ans: Nested loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r where b
what are the states of transaction?
Group By clauses • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used
what are the limitations of dbms?
ERD Diagram of Medical Recruitment Agency?
Rules Of Data Normalisation Let us now summarise Normalisation with the help of various clean rules. The following are the necessary rules for the Normalisation process: 1.
What is the initial step for object-oriented designing The initial step for object-oriented designing is object modeling. Before we go into deep about object modeling first of
Question 1: a) What is the difference between a non-impact and impact printer? b) Which type of printer is generally used in a supermarket to print your receipt? Describe
Define Assertions in SQL a. An assertion is a predicate that is expressing a condition we wish the database to always satisfy. b. Domain constraints, functional dependency
What are the DBMS languages? Explain. Ans: a) Data Definition Languages (DDL): It is employed to specify database schema for example CREATE DROP statements etc. b) Dat
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