Concepts of Database Management, Ch. 1(Correctly
solved)
Problems with redundancy correct answers duplication wastes space
inconsistency
time consuming
Size limitations
Redundancy correct answers Duplication of data or the storing of the same data in more than
one place
Database correct answers Structure that can store information about:
- Multiple types of entities
- Attributes of entities
- Relationships between entities
Entity/table correct answers file
Entity correct answers "table" Person, place, object, event, or idea
Attribute/column correct answers field
Attribute correct answers "column" Characteristic or property of an entity,
May also be called a field or column
Relationship correct answers Association between entities
One-to-many relationship correct answers 0,1, or numerous values. Each occurrence of 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
Data file correct answers organized collection of data about a single entity. corresponds to a file
in a non DB file processing. File used to store data,
Computer counterpart to ordinary paper file
Entity-relationship (E-R) diagram correct answers Visual way to represent a database
Rectangles represent entities
Lines represent relationships between connected entities
- Absence of dot indicates "one" part of relationship
- Dot indicates "many" part of the relationship
Database management system correct answers Program, or collection of programs, through
which users interact with a database
DBMS systems correct answers Oracle
solved)
Problems with redundancy correct answers duplication wastes space
inconsistency
time consuming
Size limitations
Redundancy correct answers Duplication of data or the storing of the same data in more than
one place
Database correct answers Structure that can store information about:
- Multiple types of entities
- Attributes of entities
- Relationships between entities
Entity/table correct answers file
Entity correct answers "table" Person, place, object, event, or idea
Attribute/column correct answers field
Attribute correct answers "column" Characteristic or property of an entity,
May also be called a field or column
Relationship correct answers Association between entities
One-to-many relationship correct answers 0,1, or numerous values. Each occurrence of 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
Data file correct answers organized collection of data about a single entity. corresponds to a file
in a non DB file processing. File used to store data,
Computer counterpart to ordinary paper file
Entity-relationship (E-R) diagram correct answers Visual way to represent a database
Rectangles represent entities
Lines represent relationships between connected entities
- Absence of dot indicates "one" part of relationship
- Dot indicates "many" part of the relationship
Database management system correct answers Program, or collection of programs, through
which users interact with a database
DBMS systems correct answers Oracle
