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