Design of Database Systems- Test 1 T/F Questions
When systems are automatically generated and maintained, quality is diminished.
FALSE
With the traditional file processing approach, each application shares data files, thus enabling much data sharing.
FALSE
The user interface includes languages, menus, and other facilities by which users interact with various system components.
TRUE
"Name" would be an ideal identifier.
FALSE
A business rule is a statement of how a policy is enforced or conducted.
FALSE
Data names do not have to be unique.
FALSE
Unplanned duplicate data files are the rule rather than the exception in file processing systems.
TRUE
Enforcement of business rules can be automated through the use of software tools that can interpret the rules and enforce them.
TRUE
File processing systems have been replaced by database systems in most critical business applications today.
TRUE
Information is processed data.
TRUE
In an E-R diagram, strong entities are represented by double-walled rectangles.
FALSE
A person is an example of an entity.
TRUE
A constraint is a rule in a database system that can be violated by users.
FALSE
A user view is how the user sees the data when it is produced.
FALSE
A well-structured database establishes the entities between relationships in order to derive the desired information.
FALSE
An entity type on which a strong entity is dependent is called a covariant entity.
FALSE
An example of a term would be the following sentence: "A student registers for a course."
FALSE
Business rules are formulated from a collection of business ramblings.
FALSE
Data redundancy is used to establish relationships between data but is never used to improve database performance.
FALSE
Databases were developed as the first application of computers to data processing.
FALSE
Most systems developers believe that data modeling is the least important part of the systems development process.
FALSE
Organizational commitment to a database project is not necessary for its success
FALSE
Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.
FALSE
Personal databases are designed to support a small group of individuals working together on a project.
FALSE
Reduced program maintenance is an advantage of file processing systems.
FALSE
Repositories are always used in file processing systems.
FALSE
Some examples of attributes are: eye_color, weight, student_id, STUDENT
FALSE
The data that you are interested in capturing about an entity is called an instance.
FALSE
The intent of a business rule is to break down business structure.
FALSE
The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.
FALSE
The purpose of data modeling is to document business rules about processes.
FALSE
The term legacy system refers to a newly installed database management system.
FALSE
A business rule is a statement that defines or constrains some aspect of the business.
TRUE
A business rule should be internally consistent.
TRUE
A data model is a graphical system used to capture the nature and relationships among data.
TRUE
A fact is an association between two or more terms.
TRUE
A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.
TRUE
A modern database management system automates more of the backup and recovery tasks than a file system.
TRUE
A relational database establishes the relationships between entities by means of a common field.
TRUE
A single occurrence of an entity is called an entity instance.
TRUE
An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
TRUE
An entity type name should always be a singular noun
TRUE
Cost and complexity are just two of the disadvantages of database processing.
TRUE
Data modeling is about documenting rules and policies of an organization that govern data.
TRUE
Data names should always relate to business characteristics.
TRUE
Data, rather than processes, are the most complex aspects of many modern information systems.
TRUE
Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.
TRUE
In an E-R diagram, an associative entity is represented by a rounded rectangle.
TRUE
Many of the disadvantages of file processing systems can also be limitations of databases.
TRUE
One of the roles of a database analyst is to identify and understand rules that govern data.
TRUE
One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer.
TRUE
Redundancy increases the risk of inconsistent data.
TRUE
Separation of metadata from application programs that use the data is called data independence
TRUE
The E-R model is used to construct a conceptual model.
TRUE
The data repository assists database administrators in enforcing standards.
TRUE
The failure to implement a strong database administrative function is the most common source of database failures in organizations.
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