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!
Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them?
Generalization: Consider extending the entity set account through classifying accounts as being either savings-account or chequing-account. Each of these is described through the attributes of account plus additional attributes. (Savings has interest-rate and cheque has overdraft-amount.) We can express the similarities among the entity sets through generalization. This is the procedure of forming containment relationships among a higher-level entity set and one or more lower-level entity sets.
Aggregation: The E-R model cannot express relationships between relationships. When would we require such a thing?
Consider a DB along with information about employees who work on a particular project and use a number of machines doing in which work. We get the E-R diagram shown in Figure.
Figure: E-R diagram with redundant relationships
Relationship sets work and uses could be combined into a single set. Therefore, they shouldn't be, as this would obscure the logical structure of this scheme. The solution is to use aggregation.• An abstraction by those relationships is treated as higher-level entities.• For our instance, we treat the relationship set work and the entity sets employee and project as a higher-level entity set called work.• Another figure shows the E-R diagram with aggregation.
Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin
Most computer systems authenticate users by asking them for the user name and password. However, the user names and passwords often can be guessed by hackers. Suggest an automated,
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
Natural Join : It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation
What is Data dictionary? A data dictionary is a reserved space in a database that is employed to store information about the database itself. A data dictionary may consist o
Using Literal Character String Example: To print IS A as one string with column name employee SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;
Define Join and Outer Join and differentiate between them. Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition. Oute
how to write a in a text and load it on mysql
Association as a cache This association must be updated when any new element is added to it, but testing for overlap using association is more efficient. Figure:
why shadow copy technique is used?
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