MIS 380 SDSU MIDTERM EXAM QUESTIONS WITH CORRECT ANSWERS LATEST UPDATE 2026
Data - Answers evidence; information gathered from observations Raw
information - Answers Data converted into a meaningful and useful context
Metadata - Answers Data that describe the properties of other data are:
Entity - Answers A person, place, thing, transaction, or event about which information is stored
database system advantages - Answers better data quality, program data independence, reduced
maintenance
data warehouse derives its data from - Answers various operational data sources
disadvantages of file processing - Answers high maintenance, stored in individual files
attributes - Answers A person's name, birthday, and social security number are all examples of:
composite attribute - Answers An attribute that can be further subdivided to yield additional
attributes. For example, a phone number such as 615-898-2368 may be divided into an area code
(615), an exchange number (898), and a four-digit code (2368). Compare to simple attribute.
E-R Model - Answers used to construct a conceptual model.
derived attribute - Answers An attribute whose values can be calculated from related attribute values.
binary relationship - Answers The relationship between the instances of two entity types
Subtypes should be used when: - Answers there are attributes that apply to some but not all instances
of an entity type.
The process of defining one or more subtypes of a supertype and forming relationships is called: -
Answers specialization.
Total Specialization - Answers Specifies that each entity instance of the supertype must be a member
of some subtype in the relationship.
Disjoint Rule - Answers specifies that an entity can be a member of only one subtype at a time.
Overlap Rule - Answers Specifies that an entity instance can simultaneously be a member of two (or
more) subtypes.
Partial functional dependency - Answers A functional dependency in which one or more nonkey
attributes are functionally dependent on part (but not all) of the primary key.
Functional Dependency - Answers constraint between two attributes
Properties of Relations - Answers no two rows in a relation are identical
referential integrity constraint - Answers A rule that states that each foreign key value must match a
primary key value in the other relation is called the:
Normalzing - Answers decompose relations with anomalies to produce smaller, well structured
relations
Composite Key - Answers A primary key that consists of more than one attribute.
Normalization - Answers minimize data redundancy, simplify & make it easier to maintain data
Data - Answers evidence; information gathered from observations Raw
information - Answers Data converted into a meaningful and useful context
Metadata - Answers Data that describe the properties of other data are:
Entity - Answers A person, place, thing, transaction, or event about which information is stored
database system advantages - Answers better data quality, program data independence, reduced
maintenance
data warehouse derives its data from - Answers various operational data sources
disadvantages of file processing - Answers high maintenance, stored in individual files
attributes - Answers A person's name, birthday, and social security number are all examples of:
composite attribute - Answers An attribute that can be further subdivided to yield additional
attributes. For example, a phone number such as 615-898-2368 may be divided into an area code
(615), an exchange number (898), and a four-digit code (2368). Compare to simple attribute.
E-R Model - Answers used to construct a conceptual model.
derived attribute - Answers An attribute whose values can be calculated from related attribute values.
binary relationship - Answers The relationship between the instances of two entity types
Subtypes should be used when: - Answers there are attributes that apply to some but not all instances
of an entity type.
The process of defining one or more subtypes of a supertype and forming relationships is called: -
Answers specialization.
Total Specialization - Answers Specifies that each entity instance of the supertype must be a member
of some subtype in the relationship.
Disjoint Rule - Answers specifies that an entity can be a member of only one subtype at a time.
Overlap Rule - Answers Specifies that an entity instance can simultaneously be a member of two (or
more) subtypes.
Partial functional dependency - Answers A functional dependency in which one or more nonkey
attributes are functionally dependent on part (but not all) of the primary key.
Functional Dependency - Answers constraint between two attributes
Properties of Relations - Answers no two rows in a relation are identical
referential integrity constraint - Answers A rule that states that each foreign key value must match a
primary key value in the other relation is called the:
Normalzing - Answers decompose relations with anomalies to produce smaller, well structured
relations
Composite Key - Answers A primary key that consists of more than one attribute.
Normalization - Answers minimize data redundancy, simplify & make it easier to maintain data
