Explain Specialization and Generalization in E-R diagram with example.
Fantastic news! We've Found the answer you've been seeking!
Question:
- Explain Specialization and Generalization in E-R diagram with example.
Expert Answer:
Answer rating: 100% (QA)
For all practical purposes generalization and specialization is inversion of each other Specialization A top down design process that creates subclasses based on some different characteristics of the entities in the superclass An entity set may include sub groupings of entities that are distinct in some way from other entities in the set For example a subset of entities within an entity set may have attributes that are not shared by all the entities in the entity set Consider an entity set person with attributes name street and city A person may be further classified as one of the following customer Employee For example customer entities may be described further by the attribute customerid creditrating and employee entities may be described further by the attributes employeeid and salary The process of designating sub groupings within an entity set is called specialization The specialization of person allows us to distinguish among persons according to whether they are employees or customers Now again employees may be further classified as one of the following officer teller secretary Each of these employee types is described by a set of attributes that includes all the attributes of entity set employee plus additional attributes For example officer entities may be described further by the attribute officenumber teller entities by the attributes stationnumber and hoursperweek and secretary entities by the attribute hoursperweek In terms of an ER diagram specialization is depicted by a triangle component labeled ISA The label ISA stands for is a and represents for example that a customer is aperson The ISA relationship may also be referred to as a superclass subclass ... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these computer engineering questions
-
Explain the difference between Specialization and Generalization in E-R diagram.
-
Explain types of constraints on specialization and Generalization
-
Explain how the specialization of labor can lead to increased productivity.
-
How can adults continue to function relatively normally after surgery to remove the thymus, tonsils, spleen, or lymph nodes?
-
Leonard Wolfe was killed in an automobile accident while driving his Toyota Camry. The car was rendered a total loss, and Wolfes insurance carrier paid his estate $18,550 for damage to the vehicle....
-
In this exercise, we explore the concept o f marginal rates of substitution (and, in part B, its relation to utility functions) further. A: Suppose I own 3 bananas and 6 apples, and you own 5 bananas...
-
The one-dimensional heat equation is solved on a grid consisting of \(N\) spatial grid points and \(M\) time layers. The boundary conditions are of Dirichlet type. Calculate, in terms of \(N\) and...
-
Midland Telecom provides communication services in Iowa, Nebraska, the Dakotas, and Montana. Midland purchased goodwill as part of the acquisition of Shipley Wireless Company, which had the following...
-
Brandolph sells candles for $35. The unit variable cost per candle is $19. Fixed costs total $126,000 for the year. a. What is the contribution margin per lamp? What is the Contribution margin...
-
Dwight Donovan, the president of Donovan Enterprises, is considering two investment opportunities. Because of limited resources, he will be able to invest in only one of them. Project A is to...
-
Perpetual inventory using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows: July 1 Inventory 106 units @ $28 July 8 Sale 85 units July 15 Purchase 118 units @ $32 July 27...
-
This digital advertising media channel uses an advertising model in which a company compensates a third-party network of publisher to generate traffic or leads to the company's products and services....
-
9. A taxpayer works two jobs during 2022. He earns $71,400 at the first job, and $84,810 at the second job. Each employer withholds the correct amount of FICA taxes (OASDI and Medicare). The...
-
Local city government is beginning a project to add more parks to the available open areas, and they are going to hold a series of meetings to begin public comment hearings. What is the best method...
-
(3) A new city engineer wants to upgrade some city's solid waste management facilities and equipment. The capital cost of the upgrades has been estimated to be $850,000, and it will cost...
-
How well are you modeling these traits? Are you still hanging onto old characteristics or sins or trying to be clothed in both the old and new at the time? Identify an area that takes your focus off...
-
Pinder Ltd is considering investing $500,000 in a factory that will produce electric bicycles. PinderLtd has secured a contract with a major retailer who has guaranteed that Pinder Ltd will receive...
-
The baseball player A hits the ball from a height of 3.36 ft with an initial velocity of 34.8 ft/s. 0.14 seconds after the ball is hit, player B who is standing 15 ft away from home plate begins to...
-
Oil companies have functional databases, and the consumer-product industry tends to have product databases. How do financial institutions and the airline industry classify their enterprise database...
-
Consider the relation schema STUDENT (Sid, Shoe_size, Marital_status) F: fd1: Sid Shoe_size;...................fd2: Sid Marital_status a. Does STUDENT possess a multi-valued dependency? Why or why...
-
Describe mutual referencing and the complexities that it introduces.
-
What are G.E. Moulton's fraud identifiers?
-
Give the percentages when CEOs and CFOs are involved in fraudulent financial fraud cases.
-
What was the pressure on Tracey Henderson, an executive of the Australia Football League, to steal?
Study smarter with the SolutionInn App