Unit 6: Data (C182)

Which data management tool deals with analyzing specific categories of historical information and making decisions based on that information?

Data and business intelligence

In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?

Knowledge

The parameter after _______ identifies the table name in a selection operation

FROM

Which SQL clause is used to inform the database management system (DBMS) which tables should be interrogated by the query?

FROM

What is a tree-like structure of records in a database referred to as?

Hierarchical database structure

What are the 2 major layer of a typical database?

1. application layer 2. database management layer

What is a foreign key?

A primary key found on another table within a relational database

Database research

Act of analyzing and converting data into information that can be used in decision making

What is the expected output for the following SQL query? SELECT * FROM Patient WHERE LastName = 'Moore';

All records from the Patient table where the patient's last name is "Moore"

Which field must contain a unique value in order for a relational database table to function?

Primary Key

Which classification for documents is used when the unauthorized disclosure, alteration, or destruction of data would result in little or no risk?

Public

The name, address, and account balance of each individual patient in Mei's office is known as a:

Record

What are the 2 component of a database table (datasheet)?

Records (rows that contain data) & Fields (columns that contain a single piece of data about a records i.e. name, age, position)

The _______ statement identifies the record that are being requested, and the _________ means everything from the table in a selection operation.

SELECT; asterisk (*)

Which data type is used to represent product order code that comprises alphanumeric characters?

String (Character String)

What does the DBMS do?

The DBMS is used as a tool in the application layer of a database to alter or retrieve information

What is the role of drivers in facilitating communication between applications and databases?

They allow the application to interact with the database.

What is the database administrator's role in security?

To institute protocols to protect the databases from external threats

The next keyword, ________, is the condition the query is requesting is a selection operation.

WHERE

What is a Object-Oriented Database (OO Database)?

a database that stores complex data and relationships between data directly without using inter-table relations. It is a collection of object, each with two components: data and instructions

What is a join operation?

combines two tables, but records are only appended when a matching criterion is met

What is the application layer of a database?

communicates with the end user and can be fairly complex; does not directly manipulate the data, but it uses the database management system (DBMS) as a tool to obtain the results

Distributed Database

consists of data residing on different machines

What is the product operation?

creates a result table that includes all of the attributes from the two tables; each row of the second table is added to each row of the first table

Key-value database (also known as stores)

each item in the database is stored as an attribute name (or key) together with its value

Wide-column stores

optimized for queries on large data sets and store columns of data together instead or rows

Cloud Databases

optimized to work in a cloud environment. Practical benefits include the ability to increase resources to accommodate for demands on the system, to be highly available even in the case of local or regional outages, and to support SaaS (software as a service) cloud deployments.

Document-format databases

pair each key with a complex data structure known as a document

NoSQL Databases

short for not only SQL, can accommodate a wide variety of data models including key-value, document, columnar, and graph formats. Different from relational because the tables are carefully designed before the database is built

Data Lake

system of data stored in raw format which includes structured data like tables and unstructured data like audio and video recordings

What is a selection operation?

takes row from one table to create a new table; the selection criterion is tested against each row, and when a condition is met, that row is included in the result table

What is a database model?

the conceptual view of a database

Graph stores

used to store information about networks of data

What are the categories of a majority of the responsibilities for the DBA?

-Database security -Database tuning -High availability -Business continuity -Backup and Recovery -Reporting -Designing and developing database application

Which of the following systems are examples of database applications in Mei's medical office? (Select all that apply.)

-Equipment inventory system -Accounting system -Patient scheduling system -Billing system

Which factors should Mei consider when choosing a file organization system? (Select all that apply.)

-Security -Data retrieval speed -Scalability

What is a Relational Database?

A database model that contains one or more tables joined together in logical way. Each record has a unique identifier known as a primary key which helps create the relationship among tables

What is a Flat-File Database?

A database model that stores data in plain text files with each line of text file holding one record. This model only has one table

What is a Hierarchical Database?

A database model where data is organized in a tree like structure with a parent having one or more records

Which data type uses a constructor that accepts no parameters?

Boolean

What type of data is the following: True, False ?

Boolean Values

What type of data is the following: abc, def456, erf78!@?

Character String

Armando is a freelance graphic designer. He has decided to create a database of the artwork he has done throughout the years. Each of his pieces of art is sorted using an assigned name and number. Which data type will be required in order to create his database?

Character string

What type of data is the following: F, !, # ?

Characters

Which database can increase resources to accommodate for demands on the system while maintaining high availability even in the case of local or regional outages?

Cloud database

What is a union operation?

Combines distinct field from multiple tables that have the same set of attributes and data types.

What is the collection of names, addresses, and account balances of all the patients of Mei's office more technically known as?

Database

What is the DBA?

Database Administration

What is the DBMS?

Database Management System

What are the three main categories of databases?

Flat file, relational, hierarchal

What are the 4 most common database models?

Flat-File Database, Hierarchical Database, Relational Database, Object-oriented (OO) databases

What type of data is the following: 9.5, 45.5, 1.7 ?

Floating point numbers

What type of data is the following: 4, 34, 394850 ?

Intergers

Mei's database administration function includes:

Managing user access to resources

Why is it important to ensure that data support business goals?

To aid in making strategic decisions