Database Management Systems midterm review (All
Accurately solved)
Redundancy wastes space because you are storing different types of data in the same place.
correct answers false
When you need to change data, redundancy makes your changes more cumbersome and time-
consuming. correct answers true
An entity is also defined as an attribute. correct answers false
An attribute is a characteristic or property of an entity. correct answers true
An attribute is known as a column in relational databases. correct answers true
An entity is an information category. correct answers true
Relationship is the association between entities. correct answers true
The relationship between different entities (in different tables) is handled by their common
columns. correct answers true
Software packages, called database management systems, can do the job of manipulating
databases for you. correct answers true
Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly,
rather than having to access it through the DBMS correct answers false
To create forms to use with a database you must write a program. correct answers false
Sharing data is one advantage of database processing. correct answers true
An advantage of using the database approach to processing is that it facilitates consistency.
correct answers true
A DBA can assign passwords to prevent unauthorized users from accessing the data. correct
answers true
There is a greater impact of failure in a nondatabase, file-oriented system. correct answers false
In a one to many relationship between two entities, each occurrence of the first entity is related to
many occurrences of the second entity and each occurrence of the second entity is related to only
one occurrence of the first entity. correct answers true
, A program, or collection of programs, through which users interact with a database is known as a
DBMS. correct answers true
In an E-R diagram, rectangles represent entities. correct answers true
In an E-R diagram, lines represent relationships between connected entities. correct answers true
In an E-R diagram, the dot at the end of a line indicates the "many" part of the one-to-many
relationship between two entities. correct answers true
A person or a group of people in charge of a database within an organization is often called the
DBA (database administration). correct answers true
The problem of inconsistency in data is a direct result of redundancy. correct answers true
Eliminating redundancy not only saves space but also makes the process of updating data much
simpler. correct answers true
A good DBMS has many features that allow users to gain access to data in a database without
having to do any programming. correct answers true
A database will not only hold information about multiple types of entities, but also information
about the relationships among these multiple entities. correct answers true
A database file requires a large amount of disk space and internal memory. correct answers true
Comparing with structured data, unstructured data doesn't have a pre-defined data model. correct
answers true
The data in data warehouses cannot be changed once entered. correct answers true
Metadata is data about data. correct answers true
A enterprise-level database model is more detailed than a project-level database model. correct
answers false
Storing the same data in more than one place is called ____. correct answers redundancy
A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.
correct answers entity
A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet
or an accounting ledger. correct answers data file
A visual way to represent a database is with a(n) ____. correct answers entity-relationship
diagram
Accurately solved)
Redundancy wastes space because you are storing different types of data in the same place.
correct answers false
When you need to change data, redundancy makes your changes more cumbersome and time-
consuming. correct answers true
An entity is also defined as an attribute. correct answers false
An attribute is a characteristic or property of an entity. correct answers true
An attribute is known as a column in relational databases. correct answers true
An entity is an information category. correct answers true
Relationship is the association between entities. correct answers true
The relationship between different entities (in different tables) is handled by their common
columns. correct answers true
Software packages, called database management systems, can do the job of manipulating
databases for you. correct answers true
Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly,
rather than having to access it through the DBMS correct answers false
To create forms to use with a database you must write a program. correct answers false
Sharing data is one advantage of database processing. correct answers true
An advantage of using the database approach to processing is that it facilitates consistency.
correct answers true
A DBA can assign passwords to prevent unauthorized users from accessing the data. correct
answers true
There is a greater impact of failure in a nondatabase, file-oriented system. correct answers false
In a one to many relationship between two entities, each occurrence of the first entity is related to
many occurrences of the second entity and each occurrence of the second entity is related to only
one occurrence of the first entity. correct answers true
, A program, or collection of programs, through which users interact with a database is known as a
DBMS. correct answers true
In an E-R diagram, rectangles represent entities. correct answers true
In an E-R diagram, lines represent relationships between connected entities. correct answers true
In an E-R diagram, the dot at the end of a line indicates the "many" part of the one-to-many
relationship between two entities. correct answers true
A person or a group of people in charge of a database within an organization is often called the
DBA (database administration). correct answers true
The problem of inconsistency in data is a direct result of redundancy. correct answers true
Eliminating redundancy not only saves space but also makes the process of updating data much
simpler. correct answers true
A good DBMS has many features that allow users to gain access to data in a database without
having to do any programming. correct answers true
A database will not only hold information about multiple types of entities, but also information
about the relationships among these multiple entities. correct answers true
A database file requires a large amount of disk space and internal memory. correct answers true
Comparing with structured data, unstructured data doesn't have a pre-defined data model. correct
answers true
The data in data warehouses cannot be changed once entered. correct answers true
Metadata is data about data. correct answers true
A enterprise-level database model is more detailed than a project-level database model. correct
answers false
Storing the same data in more than one place is called ____. correct answers redundancy
A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.
correct answers entity
A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet
or an accounting ledger. correct answers data file
A visual way to represent a database is with a(n) ____. correct answers entity-relationship
diagram
