ict200 test 2

__________ is data about data.

• XML Database

• Metadata

• Data Processing (DP)

Transactional database __________.

• Stores historical data and business metrics

• Supports a company’s day-to-day operations

• Optimized for decision support

Which of the following is NOT an advantage of the DBMS?

• Improved data access

• Better data integration

• Augmented extensive programming

Which of the following are types of data anomalies?

• Update, Insertion, and Decision anomalies

• Update, Insertion, and Deletion anomalies

• Update and Decision anomalies

Which of the following is FALSE about the basic building blocks of a data model?

• Attribute is the characteristic of an entity

• Constraint is a restriction placed on the data

• Another term for Entity is Tuple

Which statement is TRUE about business rules?

• Business rules are complex and hard to understand

• Business rules describe characteristics of the data for the database designer

• Business rules are written in simple words and easy to understand

The Network Model Database ___________.

• Is simple and easy to implement

• Is more complex compared to the hierarchical model

• Represents a relational database

Which is TRUE regarding the Entity Relationship Model?

• An entity instance is represented by the row in a table

• Cardinality determines the type of relationship

• Chen notation is the only notation used in ER Model

Which of the following is TRUE regarding Homonyms in a database?

• Different names to describe the same attribute

• Same attribute occurs in different tables with different names

• Example: Auto and Car have the same meaning

Which is TRUE regarding relationships in an ERD?

• 1:M relationships are the ideal model in relational databases

• M:N relationships can be directly implemented in a relational model

• 1:1 relationships cannot be implemented in relational models