MIS 3300 Questions with Correct Answers
data dictionary Correct Answer-stores definitions, such as data types for
fields, default values, and validation rules for data in each field.
data hierarchy Correct Answer-the structure and organization of data,
which involves fields, records, and files.
data mart Correct Answer-usually a smaller version of a data warehouse,
used by a single department or function.
data model Correct Answer-determines how data is created, represented,
organized, and maintained. It usually contains data structure, operations,
and integrity rules.
data warehouse Correct Answer-a collection of data from a variety of
sources used to support decision-making applications and generate
business intelligence.
data-driven Web site Correct Answer-acts as an interface to a database,
retrieving data for users and allowing users to enter data in the database.
Data-mining analysis Correct Answer-used to discover patterns and
relationships.
database Correct Answer-a collection of related data that is stored in a
central location or in multiple locations.
, database administrator (DBA) Correct Answer-found in large
organizations, design and set up databases, establish security measures,
develop recovery procedures, evaluate database performance, and add
and fine-tune database functions.
database management system (DBMS) Correct Answer-software for
creating, storing, maintaining, and accessing database files. A DBMS
makes using databases more efficient.
distributed database management system (DDBMS) Correct Answer-
stores data on multiple servers throughout an organization.
Extraction, transformation, and loading (ETL) Correct Answer-the
processes used in a data warehouse. It includes extracting data from
outside sources, transforming it to fit operational needs, and loading it
into the end target (database or data warehouse)
foreign key Correct Answer-a field in a relational table that matches the
primary key column of another table. It can be used to cross-reference
tables.
fragmentation Correct Answer-addresses how tables are divided among
multiple locations. There are three variations: horizontal, vertical, and
mixed
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 cracker. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.99. You're not tied to anything after your purchase.