WGU - Intro to IT - D322 Sections/8 Study Guide

WGU - Intro to IT - D322 Sections 4/6/8 Study Guide Leave the first rating Students also studied Terms in this set (215) Save D685 102 terms jlashonda2002 Preview D322 - Introduction to IT - Final Exa...129 terms Chris_Brantley9 Preview Networks and Security Foundations ...124 terms BussypoppingPreview Introdu 70 terms quiq Why is it important to ensure that data support business goals?To provide opportunities for communication To ensure raw data is captured To establish needs of users To aid in making strategic decisions To aid in making strategic decisions In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?Data Information Knowledge Wisdom Knowledge Which field must contain a unique value in order for a relational database table to function?Record number ID number Primary key Name Primary key What are the three main categories of databases?Relation, join, project Flat file, relational, hierarchal Spreadsheet, simple, complex Table, query, report Flat file, relational, hierarchal

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

WHERE FROM HERE

SELECT

FROM Which is true of databases and the applications that interact with them?The database can support at most one application.The database determines the application classes.Applications store data in their own files.Applications are interdependent of the database.Applications are interdependent of the database.What is the collection of names, addresses, and account balances of all the patients of Mei's office more technically known as?File Key field Database Record Database What are the name, address, and account balance of each individual patient in Mei's office known as?Key field Record Database File Record What is a tree-like structure of records in a database referred to as?Hierarchical database structure Flat file Field Relational database structure Hierarchical database structure Which of the following systems are examples of database applications in Mei's medical office?Select all that apply.Patient scheduling system Billing system Equipment inventory system Accounting system All of the above

Which factors should Mei consider when choosing a file organization system?Choose 3 answers.Data retrieval speed Hierarchy Scalability Security Data retrieval speed Scalability Security

Mei's database administration function includes:

managing user access to resources.application programming.data access planning.All of the above managing user access to resources.Databasea collection of organized data that allows access, retrieval, and use of data Database systemsintegrate the information stored and maintained by an organization Database Management System (DBMS)Converts large amounts of data into a usable format to help users make business decisions How are databases are configured/organized?Sorted according to different paradigms and store various types of data. They organize the data so that database applications can use allowable operations to manipulate and transform it.the most common database models.Flat-file, relational, hierarchical, and object-oriented Flat file databasedatabase model that stores data in a plain text file. Each line of the text file holds one record. Fields are separated by delimiters like spaces or commas. Because a

flat database uses a simple structure, it cannot contain multiple tables. (ex:

Microsoft Excel) Hierarchical DatabasesOne of the oldest database models. Data is organized in a tree structure, much like an organizational chart. There is one parent for each record, with optional nodes, forming sub-trees called segments. Access to the data is predictable and restricted to the paths in the trees.Database administrationAn important function in any organization that is dependent on one or more databases, refers to the whole set of activities that ensure all databases are highly available, secure, and scalable.

multidimensional systemsallowing information to be accessed from various views through internal linking between entries.one-dimensional systemspresent information from a single point of view and do not interact with other files.Database researchThe act of analyzing and converting data into information that can be used in decision-making.Interaction between the World Wide Web and Database systems

• Web servers search a database, organize the results in a web page, and send

that page to the client.two major layers of a database applicationan application layer and a database management layer.Application LayerThis layer communicates with the end user but does not directly manipulate the data, it only takes requests from the user and sends these requests to another layer to be processed.Database management layerThis layer directly manipulates the data only after receiving the requests through the application layer.database tablealso known as a datasheet, is composed of records and fields that hold data.Where is data stored?is stored in records, the records are represented as rows in a table with related information.DataIn computing, data is information that has been translated into a form that is efficient for movement or processing, and converted into binary digital form.Raw datadata collected in its original, most basic digital format.InformationData converted into a meaningful and useful context.Data typeSpecify the type of data that you work with in a program, it defines the size of memory needed to store data and the kinds of operations that can be performed on the data Data Type ExamplesIntegers Floating Numbers Characters Character Strings Boolean Values Integers (data type)aka int, Stores in whole numbers, that can be positive, negative, or zero.

(...,-3,-2,-1,0,1,2,3,...)

floating numbersaka float, Stores numbers with decimals (3.12434, 5.99994999, etc.) Characters (data type)aka char, Represented as a letter or special key (F,#, !,P)