Information Management Midterms

What is the relational model based on?

• Graph theory and boolean logic

• Predicate logic and set theory

• Probability and statistics

• Algebra and geometry

Who introduced the relational model in 1970?

• Edgar Dijkstra

• E. F. Codd

• Alan Turing

• Charles Babbage

What does predicate logic provide?

• A framework to verify assertions as true or false

• A way to organize data into tables

• A method for programming databases

• A tool to convert data into different formats

Which of the following is an example of predicate logic?

• A table consisting of rows and columns

• A student with a student ID of 324452 is named Mark Reyes

• The sum of two sets is always greater than their intersection

• A domain defines the type of values a column can hold

What does set theory deal with?

• The study of database queries

• The arrangement of tuples in a table

• Sets or groups of things used for data manipulation

• The format of attributes in a column

Which of the following is an example of set theory in the relational model?

• A relation consists of multiple tuples

• Set A contains 15, 23, and 52, while Set B contains 41, 52, 70, and 12. It can be concluded that A and B share a common value, 52.

• A tuple represents an entity in a database

• The sum of all tuples in a column must be equal

How many components does the relational model have?

• 2

• 3

• 4

• 5

Which of the following is NOT a component of the relational model?

• A logical data structure represented by relations

• A set of integrity rules to enforce consistency

• A primary key constraint

• A set of operations that defines how data is manipulated

What does a table (relation) represent in the relational model?

• A two-dimensional structure composed of rows and columns

• A mathematical function used in databases

• A storage system for unstructured data

• A method of data compression

What does each row (tuple) represent in a table?

• A column name

• An entire database

• Data about an entity

• A storage unit