Question

By definition, if we say that a piece of information is accurate we mean that:

It is worth its cost to collect

It is based on correct and complete data and processed correctly as expected

It supports its purpose without any extra

It was produced in time for its intended use

It is on the subject and appropriate for the context

Cardinality as discussed in class identifies:

The number of tables in a schema

The primary and foreign key fields in a collection of data

The type of data stored in a field, text, numbers, dates, etc.

Whether a table lists objects or transactions

The number of items in one table that correspond, over time, to one item in a related table

Which of the following operational problems is NOT something an organization could address using a Referential Integrity constraint in a database:

An invoice is recorded as having been generated by an unidentified employee

A student is identified as being registered in a non-existent course

Before building a database, a developer must construct a logical representation of the database which is called a(n) ________.

Data model

Algorithm

All of the following are benefits of the database approach except

Cross-functional analysis and reporting

Data integration and sharing

Minimal data redundancy

Decentralized management of data

Pseudocode

Flowchart

An employee is listed with an unrecognized job classification

An incorrect date of birth has been saved for a student

Answer 1

Ans 1. It is based on correct and complete data and processed correctly as expected

Accurate - Correct in all details especially of information, measurements, or predictions.

Ans 2. The number of items in one table that correspond, over time, to one item in a related table

Cardinality - The number of elements in a set or other grouping, as a property of that grouping.

Ans 3. A student is identified as being registered in a non-existent course

The referential integrity constraint states that the customer ID (CustID) in the Order table must match a valid CustID in the Customer table. Most relational databases have declarative referential integrity.

Ans 4. Data Model

A data model is an abstract model that organizes elements of data and standardizes how they relate to one another and to the properties of real-world entities.

Ans 5. Decentralized management of data

In the database approach, there is a central repository of data that not only helps in avoiding the wastage of storage space but also helps in controlling the redundancy by data integration. It helps in avoiding the duplication of data by following techniques like normalization and key concepts.