Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Introduction to Database > Unit 11 : Extended Entity Relationship Model > Flashcards

Unit 11 : Extended Entity Relationship Model Flashcards

1
Q

What is the common characteristics for data model?

A
  1. Conceptual simplicity without compromising the semantic completeness of the database
  2. Represent the real world as closely as possible
  3. Representation of real-world transformations must comply with consistency and integrity characteristics of any data model
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is data abstraction?

A
  1. Ways of classifying data models
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the process of data abstraction?

A
  1. Many processes begin at high level of abstraction and proceed to an ever increasing level of detail
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Who defined a framework for data modeling based on the degrees of data abstraction?

A
  1. American National Standards Institute ( ANSI )
  2. Standards Planning and Requirements Committe ( SPARC )
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

List out the framework for data modeling based on degrees of data abstraction ( 3 )

A
  1. External
  2. Conceptual
  3. Internal
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Who view the external model of the data environment?

A
  1. End Users
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does the external model requires?

A
  1. The modeler subdivide set of requirements and constraints who functional modules that can be examined within the framework of their external models
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the advantages of the external model? ( 4 )

A
  1. Easy to identify specific data required to support each business unit’s operations
  2. Facilitates designer’s job by providing feedback about the model’s adequacy
  3. Creation of external models helps to ensure security constraints in the database design
  4. Simplifies application program development
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What does the conceptual model represent?

A
  1. The global view of the entire database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the representation of data in the conceptual model?

A
  1. Representation of data as viewed by the entire organization
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the conceptual model mainly focued on?

A
  1. The basis for indentification and high-level description for main data objects, avoiding details
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the most widely used conceptual model?

A
  1. Entity Relationship Model
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does the conceptual model provides?

A
  1. A relatively easily understood macro level view of data environment
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How does the conceptual model is independent of both software and hardware? ( 3 )

A
  1. Does not depend on the DBMS software used to implement the model
  2. Does not depend on the hardware used in the implementation of the model
  3. Changes in either hardware or DBMS software have no effect on the database design at the conceptual level
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What models is more technical than the conceptual model?

A
  1. The internal model
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How does the Internal Model represents the diagram?

A
  1. Representation of the database as “seen” by DBMS
  • Represents the database from the perspective of DBMS
  • Maps the conceptual model to the DBMS
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What depicts a specific representation of an internal model?

A
  1. Internal Schema
18
Q

What model operates at lowest level of abstration? ( Mention the name and what it describe )

A
  1. The Physical Model
  2. Describing the way data are saved on storage media such as disks or tapes
19
Q

Is the physical model dependent on both software and hardware?

A
  1. Yes
  • It takes into account the particular requirements and limitations of the devices, such as storage capacities, access speeds, and memory.
20
Q

What is the requirement for database designers to implement database design at the physical model?

A
  1. Requires that database designers have a detailed knowledge of the hardware and software used to implement database design
21
Q

What is Extended Entity Relationship model?

A
  1. The result of adding more semantic constructs to original entity relationship model
  • It is called EERD
22
Q

List out the key concepts in EER (

A
  1. Supertypes and Subtype Relationship
  2. Specialization and Generalization
  3. Inheritance
23
Q

What type ( super / sub ) contains common characteristics?

A
  1. Supertype
24
Q

What type ( super / sub ) contains unique characteristics of each entity subtype?

A
  1. Subtypes
25
Q

What type ( super / sub ) is a generic entity type that is related to one or more entity subtypes?

A
  1. Supertype
26
Q

What does specialization hierarchy depicts?

A
  1. Arrangement of higher-level entity supertypes ( parent entities ) and lower-level entity subtypes ( child entities )
27
Q

How are relationships sometimes described in a specialization hierarchy?

A
  1. “IS-A” relationship
28
Q

Can a subtype exist independently of its supertype?

A
  1. No, a subtype can exist only within context of supertype and every subtype can have only one supertype to which it is directly related
29
Q

Can specialization hierarchies have multiple levels?

A
  1. Yes, they can have many levels of supertype/subtype relationships.
30
Q

What is attribute inheritance in specialization hierarchies?

A
  1. Attribute inheritance means that subtypes automatically inherit attributes from their supertype
31
Q

What is a subtype discriminator?

A
  1. The attribute in supertype entity that determines to which entity subtype each supertype occurrence is related
32
Q

What is the default comparison condition for subtype discriminator ?

A
  1. Equality Comparison
33
Q

What subtypes ( disjoint , overlapping ) is also known as non-overlapping subtypes?

A
  1. Disjoint Subtypes
34
Q

What is a disjoint subtypes?

A
  1. Subtypes that contain unique subset of supertype entity set
35
Q

What is a overlapping subtypes?

A
  1. Subtypes that contain nonunique subsets of supertype entity set
36
Q

What does completeness contratint specifies?

A
  1. Specifies whether each entity supertype occurrence must also be member of at least one subtype
  • Which can be partial or total
37
Q

What does specialization do?

A
  1. It provides the top down process of identifying lower-level, more specific entity subtypes from higher-level entity supertype
  • It is based on grouping unique characteristics and relationships of the subtypes
38
Q

What does generalization do?

A
  1. Provides botton-up process of identifying higher-level, more generic entity supertype from lower-level entity subtypes
  • It is based on grouping common characteristics and relationships of the subtypes
39
Q

What does inheritance enables?

A
  1. Enables entity subtype to inherit attributes and relationships of supertype
40
Q

Do all entity subtypes inherit their primary key attribute from their supertype?

A
  1. Yes, all entity subtypes inherit their primary key attribute from their supertype, ensuring uniqueness across the hierarchy.
41
Q

How is the relationship between a supertype and its subtype(s) depicted at the implementation level?

A
  1. At the implementation level, the supertype and its subtype(s) maintain a 1:1 relationship in the specialization hierarchy.

Introduction to Database (13 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions