DBMS 110 Final Exam Study Guide

What are the some of the rules of second normal form?

A database most be in first normal Each table must contain data about one type of thing relation must not contain any partial dependency

A centralized database is:

A database that runs on a single computer system

The goal of normalization is to:

Generate a set of relation schemas that allows us to store information without unnecessary redundancy

What is the role of data abstraction in a database?

Hide the complexity of storing data from the user.

What was the first relational database product?

IBM System R

Data Integrity refers to:

Maintaining the quality of the data stored in the database.

A relational database consist of a collection of:

Table

What does a database design involve?

The design of a database schema

What is a composite primary key?

A primary key consisting of two or more attributes that uniquely identifies each row

What is normalization?

A process used to reduce data redundancy in relational database

A query is:

A statement used to retrieve information for the database.

What are the some of the rules of first normal form?

A table must not contain any repeating groups of attributes A table must not contain composite or multi-valued attributes A table must have no repeating columns Each row of a table must be unique

A composite table:

A table used to link two or more entities participating in a M:N relationship

The extended version of an ER uses which of the following features:

Aggregation, Attribute inheritance, Specialization, & Generalization

Big Data can only store data that is: Structured Semi-Structured Unstructured All of the above

All of the above

Null values indicates:

An absent value that may exist but unknown or doesn't exist at all

A relationship is:

An association among one or more entities

Data security consist of:

Authentication/authorization, encryption, and masking are some of the popular means of data security, Protection of data, Only the people who should have access to the data are the only ones who can access the data, Ensure that data is accessed by its intended user & Prevention of data corruption

An Entity Relational Diagram consist of the following components used to define a database schema

Entities, attributes, relationship

What are business rules used to define?

Entities, attributes, relationships, and constraints

An Entity Diagram is used to:

Express the overall logical structure of a database graphically

A attribute refers to the heading of a column.

False

Data is organized facts.

False

Data manipulation language provides the ability to query information directly from the datafiles and alter the structure of the datafiles.

False

Data redundancy anomalies are encountered when the same data is stored in multiple database.

False

Normalization only contains three phases.

False

The earliest database system arose in 1980s

False

There are six types of data anomalies?

False

Business Rules constraints falls into two categories:

Field and Relationship

The storage manager components includes:

File manager Authorization and integrity manager Buffer manager Transaction manager

What is the initial phase of database design?

Fully characterize the data needs of the prospective database users.

When is a domain consider to be in an atomic state?

If the element of a domain is considered indivisible

Select the basic data types:

Numeric Int Varchar Char Float

Transitive functional dependency occurs when:

One or more non key attributes has a dependency on another super key attribute that was not chosen as a member of the primary key.

What are the types of relationships exist within a relational database design?

One to Many, One to One, & Many to Many

What are applications?

Programs that are used to interact with the database

An SQL query is used for:

Retrieving data from a database

Why was parallel database developed?

Save CPU time

How can a database schema be depicted?

Schema diagram

In which normal form does an attribute that is not fully dependent on the primary key is split into a separate table.

Second Normal

Which type is key consist of a set of one or more attributes that collectively identify uniquely a tuple in the relation?

Super key

As it relates to functional dependency, what does the equation "A,B --> C" represents?

The combination of values in columns A and B determines the value of column C

What is a domain constraint?

Domains that specify possible values that can be store in an attribute

The three properties of transaction management discussed in this book are:

Durability Atomicity Consistency

Normalization will:

Eliminate data redundancy

Data types are used to help enforce the domain of a column. Select the common types of datatypes.

-Boolean -Float -Integer

The set of permitted values allowed to be stored in a column is known as:

Domain

Responsibilities of Database Administrators includes:

-Defining the storage structure and access method definition -Defining the schema definition -Applying schema and physical organization modification

Examples of the Database Administrator routine maintenance activities include:

-Ensure enough free disk space is available -Backing up the database -Ensuring database performance

How is query language categorized?

-Imperative query language -Functional query language -Declarative query language

Relational algebra consist of set of operations including:

-Project -Cartesian Product -Select -Rename -Join

Relational algebra consist of a set of operation that takes one or two relations as input and produce a new relation as a result. Select the two categories which the set operations are grouped into.

-Unary -Binary

In what decade did the type of data stored in a database evolve.

2000

What is Infrastructure as a Service (IaaS)?

A cloud server model that allows an enterprise to rent computing facilities.

What is Platform as a Service (PaaS)?

A cloud server model that not only provides computing infrastructure but also deploys and manages platform

An instance can be defined as:

A collection of information stored in the database at a particular moment

A database management system (DBMS) is

A collection of interrelated data and set of programs used to access data

Who does the database designer have to interact with to understand the needs of the application?

Domain experts and Users

Each attribute has a set of permitted values known as:

Domain or value set

Which type of key represents a minimal subset of super key?

Candidate Key

What are the two states in which backups can be taken

Consistent and inconsistent

What language would you use to specify the storage structure of a database schema?

DDL

Which language has commands that specify integrity constraints?

DDL

Which data analysis phase considers the processes and data that may be incomplete, contain duplicates, or contain errors? Group of answer choices Data Analysis Data Processing Data Cleaning Communications Data Processing

Data Cleaning

Select the two types of server architecture.

Data server & Transaction server

Cloud Service Modules includes:

Database as a service Infrastructure as a service Software as a service Platform as a service

What does the management of data involve?

Defining structures for storage of information and providing mechanism for manipulating data.

A drop table command:

Deletes that table from the schema

Normalization is for:

Designing relational database schemas

Functional dependency can:

Determine the value of the dependent attribute

What are the type of participation available in an entity set relationship?

Total & Partial

A database model is a set of entities and relationships that exist in the real world.

True

A query language is a language in which a user can request information from the database.

True

A single-user system has: True or False

True

A transaction is a collection of operations that performs a single logical function in a database application.

True

A tuple is simply a sequence of values.

True

A variety of new data-intensive applications and the need for rapid development lead to NoSQL database.

True

An attribute takes a null value when an entity does not have a value for it

True

An attribute that contains the firstname, lastname, and middle name would be considered as having multiple values.

True

An entity has a set of properties known as attributes.

True

An entity is a thing or object in the real world that is distinguishable from other object.

True

An entity/table consists of a set of related attributes/columns that is used to organize data for the purpose of providing meaningful information to the end users.

True

Data can be used to transform raw facts into information, and information can be used to acquire knowledge.

True

Data manipulation language is a language that enables users to access or manipulate data.

True

Data redundancy leads to repetition of data hence extra space is required and anomalies are encountered.

True

Distributed Database system stores databases on nodes located at geographically separated sites. True or False

True

Does each DBMS has its own architecture for handling transaction log files?

True

ERD Notation represents a complete set of work flow shapes & symbols used in the graphical representation of data.

True

In first normal form each field should contain a single (atomic) item

True

Information processing drives the growth of computers.

True

It is good practice have the foreign key reference an existing primary key in the table being referenced.

True

There are two ways in which computers are used: single user system and multi-user system. True or False

True

When designing database schemas we must ensure that we avoid redundancy and incompleteness.

True

You should identify the PK in first normal form

True

A single-user system has:

Typically only one processor, A single user, and One or two disks

An entity whose existence is dependent on another entity is known as:

Weak entity

When does a relationship exist between entities?

When an attribute of one entity refers to an attribute in another entity

Functional Dependency occurs:

nctional Dependency occurs: Group of answer choices When a non-key attributes exhibits a dependency on one or more super key attributes.

A float data type represents a floating number with precision of at least n digits.

true

A where clause allows us to select only those rows from the entities listed in the from clause, that satisfies a specified predicate.

true