Exam (elaborations)
DBMS Exam 1: Questions With Proper Answers (100%)
- Course
- Institution
DBMS Exam 1: Questions With Proper Answers (100%)
[Show more]
Content preview
DBMS Exam 1: Questions With Proper Answers (100%)1) What is redundancy? What problems are associated with redundancy?
Right Ans - Redundancy is the duplication of data or the storing of the same
data in more than one place. Redundancy wastes space b/c you're storing the
same data in multiple places. The extra space results in larger spreadsheets
that require more space in memory and on disk that take longer to save and
open. It also makes changes more cumbersome, and it makes things
inconsistent, for example, when you enter the same name three different ways
(ex: johnsons vs johnson's, or johnsons').
3) What is an entity? An attribute? Right Ans - An entity is a person, place,
object, event, or idea for which you want to store and process data. (each
entity has its own table). An attribute is a characteristic or property on an
entity. Attributes=> Also known as fields or columns in many database
systems.
4) What is a relationship? A one-to-many relationship? Right Ans - A
relationship is an association between entities. (ex: the RepNum relationships
between the Rep and Customer tables in Premiere Products). One-to-many
relationships occur when each record in TableA may have many linked
records in TableB but each record in TableB may have only one corresponding
record in TableA.
5) What is a database? Right Ans - A database is a structure that can store
information about multiple types of entities, the attributes of those entities,
and the relationships between the entities.
8) What is a DBMS? Right Ans - A Database Management System is a
program, or collection of programs, through which users interact with a
database. The actual manipulation of the underlying database is handled by
the DBMS (ex: Microsoft Access).
11) How is it possible to get more information from the same amount of data
by using a database approach as opposed to a nondatabase approach?
Right Ans - The primary goal of a computer system is to turn data (recorded
facts) into information (the knowledge gained by processing those facts.) In a
non-database, file-oriented environment, data often is partitioned into several
disjointed systems, with each system having its own collection of files. Any
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 LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76747 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now