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?
-
What is the difference between applied research and basic or pure research? Use a decision about how a salesperson is to be paid, by commission or salary, and describe the question that would guide...
-
Lansing Mfg. prepared the following 2010 abbreviated flexible budget for different levels of machine hours: Each product requires 4 hours of machine time, and the company expects to produce 10,000...
-
Extreme Machine manufactures machines and parts for various industries; they have an office in Youngstown, Ohio. Avery Dennison manufactures and sells labels from a plant in Mentor, Ohio. They use...
-
Southworth Company uses a job-order costing system and applies manufacturing overhead cost to jobs on the basis of the cost of direct materials used in production. At the beginning of the current...
-
(a) Find the local extrema and saddle points of the function (x,y) = + -2y-xy+y+1 (b) Use Taylor's approximation around the point (x,y)=(0,0) to obtain an approximation of the above function up to...
-
Greenville has provided the following information from its General Fund Revenues and Appropriations/ Expenditure/Encumbrances subsidiary ledgers for the fiscal year ended. Assume the beginning fund...
-
Hollywood megastars often represent brands that are recognized globally in major media advertising; but fans might be surprised to learn that many stars have leveraged their reputation in foreign...
-
What information in computer games would most likely be stored in memory?
-
What will be printed by the following code snippet? 1 res = "12 is>than 1." 2 ans = res [-5:-1] 3 print (ans)
-
2) Students that want to study Spanish take a placement test and are placed based on their language ability. Students are placed as beginners, intermediate, or fluent. Identify the type of data and...
-
17. What can be useful as a quick, throwaway single line function? A. A Lambda function B. A Class function C. A Static function D. A Null function
-
Objective Type Question: What is a key responsibility of forensic accountants in the legal context? A) Enhancing financial reporting accuracy B) Offering tax planning advice C) Providing litigation...
-
Daube Industries' operations for the month of July are summarized as follows: A. Provided $7,200 of services in July on account. B. Received $3,500 cash from customers for services provided in July....
-
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.
-
Show that the Lorentz group commutation relations (13.20) are satisfied by the choices \(K_{i}= \pm \frac{i}{2} \sigma_{i}\) and \(J_{i}=\frac{1}{2} \sigma_{i}\), where the \(\sigma_{i}\) are Pauli...
-
Find the relationship of the eight SU(3) operators \(T_{ \pm}, V_{ \pm}, U_{ \pm}, T_{3}\), and \(Y\) defined in Eqs. (8.2) and (8.7)-(8.8), and the nine oscillator operators \(\left(A_{i}^{j}...
-
Verify that the set of matrices (5.14) is closed under ordinary matrix multiplication. Data from Eq. 5.14 T(oc)= = 629 > - (+19) TOO) = (721) TO) = ( ). T(oa)= T(b) TO) -(11) T(4-(11) TO=(9) T(C3)= =
Study smarter with the SolutionInn App