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!
Cardinality of Relationship
One-to-One
Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher is teaching only one learner.
One-to-Many
Only one entity of the first set is related to many entities of the second set. E.g. A teacher teaches learners.
Many-to-One
Multiple entities of the first set are related to many entities of the second set. E.g. Teachers teach a learner.
Many-to-Many
Multiple entities of the first set are related to multiple entities of the second set. E.g. Teachers teach learners
What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only
Define deadlock avoidance. An alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested. Each request requires the s
Self-Join: In a self join a table is joined with itself. Let consider the following sample partial data of EMP table EMPNO ENAME MGRID
The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by
Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co
What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim
statical data
Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic
Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)
Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level
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