CIS 3050
The SDLC phase in which database processing programs are created is the ________ phase.
Analysis
In the figure below, the primary key for "Order Line" is which type of key?
Composite
In the figure shown below, which of the following business rules would apply?
Each vendor can supply many parts to any number of warehouses, but need not supply any parts
A composite key consists of only one attribute.
False
A member of a subtype does NOT necessarily have to be a member of the supertype
False
A subtype is a generic entity that has a relationship with one or more entities at a lower level.
False
Databases were developed as the first application of computers to data processing.
False
Generalization is a top-down process.
False
Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.
False
________ is a tool even non-programmers can use to access information from a database.
Structured query language
Data is represented in the form of:
Tables
The logical representation of an organization's data is called a(n):
The logical representation of an organization's data is called a(n)
A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.
True
Data management technologies are also increasing often used as information systems, as a foundation for analytics or the systematic analysis of data to understand a real-world problem better.
True
Data names should always relate to business characteristics.
True
Data structures include data organized in the form of tables with rows and columns. true
True
Data, rather than processes, are the most complex aspects of many modern information systems.
True
The relationship between a weak entity type and its owner is an identifying relationship.
True
When choosing an identifier, choose one that will not change its value often.
True
While business rules are not redundant, a business rule can refer to another business rule.
True
In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized
Vehicle
Which of the following is true of packaged data models?
Which of the following is true of packaged data models?
A ________ defines or constrains some aspect of the business.
business rule
A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.
cardinality constraint
An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):
composite identifier.
In the SQL language, the ________ statement is used to make table definitions.
create table
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:
foreign key
The process of defining a more general entity type from a set of more specialized entity types is called:
generalization
A domain definition consists of all of the following components EXCEPT:
integrity constraints.
Metatdata typically describes all of the following EXCEPT:
location on disk.
A form of database design which maps conceptual requirements is called:
logical designs.
Business policies and rules govern all of the following EXCEPT:
managing employees.
The third step in the data modeling process with a packaged data model is:
map data to be used from package to data in current databases.
According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than:
more than 7 billion exabytes of data.
Unplanned duplicate data files are the rule rather than the exception in file processing systems.
True
In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules.
total specialization; overlap
the e-r model is used to construct a conceptual model
true
Because applications are often developed independently in file processing systems:
unplanned duplicate data files are the rule rather than the exception.
All of the following are steps to using a packaged data model EXCEPT:
utilize all business rules that come with the packaged data model.
A value that indicates the date or time of a data value is called a:
time stamp
The entity integrity rule states that:
no primary key attribute can be null.
Data modeling may be the most important part of the systems development process because:
data characteristics are important in the design of programs and other systems components.
________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.
data integrity
A graphical system used to capture the nature and relationships among data is called a(n):
data model.
The most important challenge of customizing a purchased data model is:
determining the business rules that will be established through the data model.
Using a packaged data model, projects take less time and cost because:
essential components and structures are already defined.
A good data definition will describe all of the characteristics of a data object EXCEPT:
examples.
When all multivalued attributes have been removed from a relation, it is said to be in:
first normal form
A two-dimensional table of data sometimes is called a:
relation
The process of defining one or more subtypes of a supertype and forming relationships is called:
specialization
The columns of a relation can be interchanged without changing the meaning or use of the relation.
tRUE
The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.
total specialization
Information is processed data.
True
An attribute (or attributes) that uniquely identifies each row in a relation is called a:
Primary Key
In the figure below, Name would be an ideal identifier.
SID is the identfier
In an E-R diagram, strong entities are represented by double-walled rectangles.
False
A modern database management system automates more of the backup and recovery tasks than a file system.
True
A primary key is an attribute that uniquely identifies each row in a relation.
True
The three-schema approach includes which of the following schemas?
Internal
A database is an organized collection of ________ related data.
Logically
________ are established between entities in a well-structured database so that the desired information can be retrieved.
Relationships
The intent of a business rule is to break down business structure.
False
Specialization is the reverse of generalization.
True
The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.
False
A single occurrence of an entity type is called an entity instance.
True
An entity instance of a subtype represents the same entity instance of the supertype.
True
File processing systems have been replaced by database systems in most critical business applications today.
True
Metadata are data that describe the properties of other data.
True
One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.
True
Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.
True
Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype.
True
The E-R model is used to construct a conceptual model.
True