Database Management Systems midterm review (All Accurately solved)

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