What is the property by which subtype entities possess the values of all attributes of a supertype?

Home

Subjects

Expert solutions

Create

Log in

Sign up

Upgrade to remove ads

Only ₩37,125/year

  • Flashcards

  • Learn

  • Test

  • Match

  • Flashcards

  • Learn

  • Test

  • Match

Terms in this set (7)

c. attribute inheritance

1.
The property by which subtype entities possess the values of all attributes of a supertype is called:

a. hierarchy reception

b. class management

c. attribute inheritance

d. generalization

a. there are attributes that apply to some but not all instances of an entity type

2.
Subtypes should be used when:

a. there are attributes that apply to some but not all instances of an entity type

b. supertypes related to objects outside the business

c. the instance of a subtype do not participate in a relationship that is unique to that subtype

d. a recursive relationship is needed

a. specialization

3.
The process of defining one or more subtypes of a supertype and forming relationships is called:

a. specialization

b. generalization

c. creating discord

d. selecting classes

c. total specialization

4.
The following figure is an example of:

a. partial specialization

b. completeness

c. total specialization

d. disjointness

c. partial specialization

5.
The ____ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

a. semi-specialization

b. total specialization

c. partial specialization

d. disjointedness

e. zero

a. logical specifications

6.
A form of database specification which maps conceptual requirements is called:

a. logical specifications

b. response specifications

c. security specifications

d. physical specifications

c. foreign key

7.
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

a. link attribute

b. link key

c. foreign key

d. foreign attribute

Sets with similar terms

CHAP 3

24 terms

amazain10

Chapter 3 Review Questions

25 terms

kpalm24

Database Management Ch. 3

41 terms

Andie_Swift

AIS Exam#3

14 terms

rsolorio15

Sets found in the same folder

Chap 3 Quiz

15 terms

Mason_Williams233

Database Chapter 4 MIS 380

35 terms

gina_lynn_roc

Database Chapter 3

31 terms

danielle_sims2

Chapter 8 Quiz STUDY

45 terms

R04666

Other sets by this creator

Database Foundations: Core Concepts Chapter 1

17 terms

R04666

Spark (FINAL)

8 terms

R04666

Hadoop

23 terms

R04666

Spark Transformation, Spark Action, Spark DataFram…

24 terms

R04666

Verified questions

COMPUTER SCIENCE

For an if statement to conditionally execute a group of statements, the statements must be enclosed in a set of ________.

Verified answer

COMPUTER SCIENCE

Why is rotational latency usually not considered in disk scheduling? How would you modify SSTF, SCAN, and C-SCAN to include latency optimization?

Verified answer

COMPUTER SCIENCE

True or false? Void functions do not return any value when they are called.

Verified answer

COMPUTER SCIENCE

The slab-allocation algorithm uses a separate cache for each different object type. Assuming there is one cache per object type, explain why this scheme doesn’t scale well with multiple CPUs. What could be done to address this scalability issue?

Verified answer

Other Quizlet sets

EXAM 2

14 terms

babybeezzPLUS

Test Questions Reviewed in Class

41 terms

warzecha14

AJ 100 CHPT. 3

16 terms

malik_branche

Endo Exam 2: Minnigh Notes

40 terms

jpn115

Related questions

QUESTION

Which data type can you use to store a date value without storing a time value?

3 answers

QUESTION

Cross-Database Permissions Chains allow permission chaining between databases using the?

2 answers

QUESTION

It is possible to set up restrictions which allow records to be deleted, but not added using a form.

3 answers

QUESTION

False, because data that is externally fed runs on a job. (Think OKTA nightly feed)

2 answers

What is supertype and subtype entities?

A supertype is a generic entity type that has a relationship with one or more subtypes. A subtype is a sub-grouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroups.

Is the process of defining one or more subtypes from a given supertype?

Generalization: The process of defining a more general entity type from a set of more specialized entity types. BOTTOM-UP..
Specialization: The process of defining one or more subtypes of the supertype and forming supertype/subtype relationships. TOP-DOWN..

What rule specifies that an entity can be a member of only one subtype at a time?

Disjoint rule. Specifies that if an entity instance (of the supertype) is a member of one subtype, it cannot simultaneously be a member of two (or more) subtypes. Overlap rule. Specifies that an entity instance can simultaneously be a member of two (or more) subtypes.

What is an entity subtype?

An entity subtype is a collection of entities of the same entity type to which a narrower definition and additional predicates apply. That is to say, entity types can be sub-typed, if there are entities of that type which have unique definitions, attributes, or relationships.

Toplist

Neuester Beitrag

Stichworte