CS 5200 Databases Key Terms || with Errorless Solutions
100%.
RDBMS correct answers Relational Database Management System
Core functions of RDBMS correct answers Database design and application development
Data Analysis
Concurrency and Robustness
Efficiency and Scalability
ERP correct answers Enterprise Resource Planning
MRP correct answers Management Resource Planning
KB correct answers 1024 bytes
MB correct answers 1024 KB
GB correct answers 1024 MB
TB correct answers 1024 GB
data independence correct answers application programs should not, ideally, be exposed to
details of data representation and storage. The DBMS provides an abstract view of the data that
hides such details
efficient data access correct answers A DBMS utilizes a variety of sophisticated techniques to
store and retrieve data efficiently. This feature is especially important if the data is stored on
external storage devices
data integrity and security correct answers If data is always accessed through the DBMS, the
DBMS can enforce integrity constraints. Also, it can enforce access controls that govern what
data is visible to different classes of users.
data administration correct answers When several users share the data, centralizing the
administration of data can offer significant improvements. Experienced professionals who
understand the nature of the data being managed, and how different groups of users use it, can be
responsible for organizing the data representation to minimize redundancy and for fine-tuning
the storage of the data to make retrieval efficient
Concurrent Access and Crash Recovery correct answers A DBMS schedules concurrent accesses
to the data in such a manner that users can think of the data as being accessed by only one user at
a time. Further, the DBMS protects users from the effects of system failures
, Reduced Application Development Time correct answers Clearly, the DBMS supports important
functions that are common to many applications accessing data in the DBMS. This, in
conjunction with the high-level interface to the data, facilitates quick application developments.
DBMS applications are also likely to be more robust than similar stand-alone applications
because many important tasks are handled by the DBMS (and do not have to be debugged and
tested in the application).
data model correct answers a collection of high-level data description constructs that hide many
low-level storage details
relational data model correct answers represents conceptual and external level schemas as if data
are stored in tables
semantic data model correct answers A more abstract, high-level data model that makes it easier
for a user to come up with a good initial description of the data in an enterprise.
relation correct answers central data description construct in relational database model
schema correct answers description of data in terms of a data model
SQL correct answers Structured Query Language
field correct answers attribute or column in database
integrity constraints correct answers conditions that the records in a relation must satisfy
levels of abstraction in DBMS correct answers conceptual,physical,external
DDL correct answers Data Definition Language
used to define the external and conceptual schemas
conceptual schema correct answers describes the stored data in terms of the data model of the
DBMS
levels of abstraction in a DBMS correct answers
Conceptual Database Design correct answers The process of constructing a model of the data
used in an enterprise, independent of all physical considerations.
physical schema correct answers Specifies additional storage details. Summarizes how the
relations described in the conceptual schema are actually stored on secondary storage devices
such as disks and tapes.
Indexes correct answers auxiliary data structures in database
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 FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.69. You're not tied to anything after your purchase.
