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!
Aggregation
Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is composed of other objects. You can characterize a house as a combination of its roof, floors, walls, foundation, windows, and rooms and so on. A room may in turn be, composed of walls, floor, ceiling, doors and windows, as shown in Figure.
In UML, a link is placed among the "whole" and "parts" classes, with a diamond head (Figure) attached to the complete class to indicate which association is an aggregation. Multiplicity can be precise at the end of the association for each of "part-of" classes to indicate constituent parts. The method of decomposing a complex object into its component objects can be extended until desired level of detail is reached.
Figure: A house and some of its component
Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un
Define data conversion? Helpful to load data into temporary staging tables. Then can write SQL code to do much of data processing. SQL code is simpler and faster to write than
Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every
Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager
Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.
Find out the names and company names of all employees sorted in ascending order of company name and descending order of employee names of by which company. SELECT EMPLOYEE_NAME,
Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form
Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join
What is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th
Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider
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