infoman

In Module 1, which term is defined as organized collection of logically related data?

• Data

• Information

• Database

• DBMS

Which limitation of file processing is explicitly mentioned as a cause of inconsistencies across systems?

• Program-data independence

• Data redundancy

• Better decision support

• Ease of data access

According to the SDLC phases listed, which phase includes programming, testing, training, installation, and documentation?

• Planning

• Physical Design

• Implementation

• Maintenance

In the Three-Schema Architecture, which schema represents the logical structure of the entire database?

• External schema

• Conceptual schema

• Internal schema

• Physical schema

Which identifier type is described as a potential identifier that satisfies uniqueness and non-null requirements?

• Primary Key

• Foreign Key

• Candidate Key

• Composite Key

What is the cardinality constraint defined as in the relationships section?

• A link between entities

• Number of instances that can/must participate

• A collection of entities with shared properties

• Specific link between entity instances

When is an associative entity created according to the notes?

• When two entities are unary

• When a relationship has attributes or needs a unique identifier

• When an entity has a multivalued attribute

• When supertypes inherit attributes

In Module 3, what is the attribute called that determines subtype membership?

• Subtype Key

• Subtype Discriminator

• Attribute Inheritance

• Supertype Identifier

In the relational model, what is a relation defined as?

• A hierarchical tree of nodes

• A named, two-dimensional table of data

• An unstructured collection of documents

• A graph of connected entities

Which property is required for all relations according to the properties listed?

• Every attribute value may be multivalued

• Order of rows and columns determines meaning

• Every row must be unique

• Attributes can share the same name