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'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
Consider a systems development project with the following data Activity Duration (weeks) Precedence Relationship 1. Software design
Types of data independence Data independence can be classified into the following two types: Physical Data Independence: This means that for any change made in the physi
Mention various steps required to draw an E-R Diagram. Draw an E-R Diagram for Student Information System. Mention all suitable assumptions to justify your answer.
Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014
What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape
A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....
What are the two integrity rules? Ans: The two integrity rules are: Entity Integrity Rule & Referential Integrity Rule. Entity Integrity Rule - If the attribute A of rel
What are the advantages of relational data model? Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer
What is use of generating such tables? How can you create temporary tables? When you require a table only for a short time after that you want it to disappear automatically you
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