Site Loader
Rock Street, San Francisco

QUESTION#1:

When is the concept of a weak entity used in data modelling? Define the
terms owner entity
type, weak
entity type, identifying
relationship
type, and
partial key.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

 

ANSWER:

Concept of weak entity is used in conceptual
phase of data modelling while

Modelling
entity types who don’t
have key attribute of
their
own.

 

Owner entity type:

As
we know that weak entity type is identified by being related to specific
entity from another entity type, so the entity type from which weak entity type is related is called owner
entity
type.
Owner entity type
has their own key attribute.

 

Example: The Student’s unique Roll No will identify the students. So, Roll
No is set to be the Primary Key of the STUDENT entity, &
Hence STUDENT is an owner entity type because of
its key attribute.

 

Weak entity type:

 

Those entities type which don’t have a key attributes of their own. They depend

on other entities
for their existence.

 

Example: Dependent entity type cannot exist without Employee entity type in company database
model.

 

Identifying relationship type:

 

An
Identifying Relationship is a relationship between a strong and a weak entity
type, where the key
of the strong entity type is required to uniquely identify instances of the weak entity type.

Partial key:

 

 

It is the attribute which uniquely
identify weak entities that are related to the same

Owner entity.

 

Example: if we assume that no two dependents of the same employee ever have the same first name,
the attribute Name of DEPENDENT is the partial
key.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Page 1 of 3

QUESTION#2a:

 

 

What is
the difference
between a specialization hierarchy and
a

Specialization lattice?

ANSWER:

 

 

In  specialization  hierarchy
 a
 subclass
 can  be  a  subclass  in  only  one

Class/subclass relationship, that
is, each subclass has only one parent, whereas, in
specialization lattice a subclass can be a subclass in more than one class/subclass
relationship, that is, each
subclass has more than one parent.

 

 

In above figure subclass STUDENT_ASSISTANT has two parents (EMPLOYEE
and STUDENT), whereas, FACULTY subclass has only
one parent, so STUDENT_ASSISTANT is example of specialization lattice and
FACULTY is example of specialization hierarchy.

 

QUESTION#2b:

What is the difference between specialization and generalization? Why do we not display this
difference in schema diagrams?

 

ANSWER:

 

 

Specialization is a process of defining set of subclasses of an entity set. Specialization is defined on the basis of distinct characteristics
of the entities in superclass.

 

Specialization corresponds to a top-down conceptual
refinement
process during conceptual schema design.

 

Generalization is a reverse process of abstraction in which we identify  
the  common 
 features
of entity   and   generalize  
them into a single superclass. It is a process of defining generalize entity
type from the given entity type.

 

Generalization corresponds
to a bottom-up conceptual refinement process
during conceptual schema design.

 

 

 

 

Page 2 of 3

An arrow pointing to the
generalized superclass represents a generalization, whereas arrows pointing to the specialized subclasses represent a
specialization. We
will
not use this notation because
the decision as to which process is
followed in a particular
situation is
often subjective.

 

QUESTION#3:

Design           a           Bank         
 database,           including           information:          
(10) Customer       (name,       address,       phone,       and       Social     
 Security       number). Account                      (numbers,                      type                      and                      balances).
Also          record          the         
customer(s)          who          own          an          account. Draw the E /R diagram for this
database. Indicate
cardinality of a
relationship

 

ANSWER:

Post Author: admin

x

Hi!
I'm Dora!

Would you like to get a custom essay? How about receiving a customized one?

Check it out