Exam (elaborations)
BUAD 342 Exam 2 Complete Questions And Answers
- Course
- Institution
BUAD 342 Exam 2 Complete Questions And Answers
[Show more]
Content preview
BUAD 342 Exam 2 Complete QuestionsAnd Answers
File-Oriented Processing CORRECT ANSWERS Mandate a 1-to-1 relationship between
programs and data files
Data-Oriented Processing CORRECT ANSWERS Create a single data repository to
support numerous applications; a data pool is created and a variety of programs access
needed data from the shared data pool
Database Management System (DBMS) CORRECT ANSWERS The resource available
to define and manage data structures in an information system
Relational Database CORRECT ANSWERS Based on the theory of relational math (set
theory). Organize & store data in 2-dimensional tables consisting of rows and columns
Primary Key CORRECT ANSWERS Unique identifier in one of the table fields
Foreign Key CORRECT ANSWERS An attribute that appears as a non-primary key in
one entity (table) and as a primary key attribute in another entity (table)
Compound Key CORRECT ANSWERS A unique combination of attribute types used to
identify a single instance of an entity
Data Query Commands CORRECT ANSWERS Help users ask questions about the
data
Forms Generators CORRECT ANSWERS Used to design the format & look of desired
screens and forms
Report Generators CORRECT ANSWERS Used to define the format and look of
desired output
QBE (Query by Example) CORRECT ANSWERS Grid or replica of an empty record is
displayed and the user types search criteria in the applicable columns
SQL (Structured Query Language) CORRECT ANSWERS Actual programming
language you can use to directly interact with data, or you can embed SQL commands
in programs that access and process data
Record Layout CORRECT ANSWERS Details the record structure, including record
field names, width of each field, and type of data stored in each field (numeric,
alphanumeric, date)
, Data Dictionary CORRECT ANSWERS Database documentation at the data item (field)
level
User Interface CORRECT ANSWERS The input/output screens, queries, reports and
document formats
Data CORRECT ANSWERS Raw facts
Information CORRECT ANSWERS the product of data that has been processed and to
give it meaning
Knowledge CORRECT ANSWERS When info is processed to yield additional
understanding
Knowledge Management CORRECT ANSWERS When organizations systematically
gather, share, organize and analyze their knowledge
Data Mining CORRECT ANSWERS One method used in knowledge management. It
involves sorting through data to identify patterns and establish relationships
Data Warehouse CORRECT ANSWERS A central repository for all or significant parts
of the data that an enterprise's various business systems collect
OLAP (Online Analytical Processing) CORRECT ANSWERS A category of software
tools that provide analysis of data stored in a database and is often used in data mining
Attribute (column) CORRECT ANSWERS Columns typically include attributes identified
during the conceptual data modeling phase and become fields when the database is
physically built
Record (row) CORRECT ANSWERS A group of attributes or fields to describe a single
instance of an entity
Table CORRECT ANSWERS A collection of records or instances which include details
of interest for a given entity
Data Item CORRECT ANSWERS The data contained in each field of a record in a table
Data Mart CORRECT ANSWERS The repositories that houses the data analyzed with
data mining tools
Entity CORRECT ANSWERS Each record or attribute
Fields CORRECT ANSWERS Each event represents one record
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ElevatedExcellence. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72042 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now