100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
BUAD 342 Exam 2 Complete Questions And Answers $10.99   Add to cart

Exam (elaborations)

BUAD 342 Exam 2 Complete Questions And Answers

 3 views  0 purchase
  • Course
  • BUAD 342
  • Institution
  • BUAD 342

BUAD 342 Exam 2 Complete Questions And Answers

Preview 2 out of 5  pages

  • October 28, 2024
  • 5
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • BUAD 342
  • BUAD 342
avatar-seller
ElevatedExcellence
BUAD 342 Exam 2 Complete Questions
And 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

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

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

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)

79373 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$10.99
  • (0)
  Add to cart