WGU - Introduction to IT - D322 Section 6 Review

WGU - Introduction to IT - D322 Section 6 Review Leave the first rating Students also studied Terms in this set (73) Western Governors UniversityD 322 Save WGU C182 Introduction to IT 255 terms rwdixon1993Preview

WGU D322

Teacher 489 terms iamvictor_udeh Preview Introduction to IT - D322/ Pre-asses...70 terms quique218Preview Intro to 55 terms ann 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

• Database systems are the underlying technology that supports much of the

World Wide Web.

• Websites interface between clients and databases, responding to client

requests.

• 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.