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.
Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,.... FROM TABLE WHERE );
Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.
What are segments in oracle? Segments - Each table has single field of disk space, known as segment, set aside for it in the tablespace. Segments consist of contiguous sections
Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY
Define the Attribute Inheritance The attributes of a higher level entity set are inherited through a lower level entity set made by specialization-generalization hierarchy. Nam
What is ICR? A. ICR (Intelligent Character Recognition) is a technology that gives scanning and imaging systems the ability to identify images of hand-printed or script charact
Which component is not included in database environment ? A users component is not included in database environment.
File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is
external view of DBMS in healthcare department?
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