Relational Database Fundamentals
Quizzes Solved 100% Correct
What can be said about the two relations shown in the exhibit? - ANSWER They
are both strong entities.
In a data model, details about the kinds of operations that are permitted on the data are
described by which type of information? - ANSWER Manipulative information
What is a parent key? - ANSWER The primary key referenced by a foreign key
Every column in a relation must have what? - ANSWER A defined domain
In a relational database, rows, columns and tuples are stored in: - ANSWER a relation.
What is a thin client? - ANSWER A client that relies on the server to perform the bulk
of the data-processing operations
The number of tuples in a relation determines which characteristic of the relation? -
ANSWER Its cardinality
What is a fat client? - ANSWER A client that performs the bulk of the data-
processing operations
What does a set of permissible values for one or more attributes in a relational
database referred to as? - ANSWER Domain
, The number of attributes in a relation determines which characteristic of the relation? -
ANSWER Its degree
What is an advantage of three-tier client-server systems over two-tier client-server
systems? - ANSWER The centralized application logic makes maintaining the
application easier.
The process of organizing and refining relations within a relational database is known
as what? - ANSWER Normalization
According to E.F. Codd, which three pieces of information are needed to retrieve a
value? - ANSWER The name of the table, the name of the column, and the primary key
of the row
Which of the following is true of columns in a relation? - ANSWER Columns must have
a name that is unique within its relation.
In terms of database relationships, what determines the degree of a relationship? -
ANSWER The number of entities involved in the relationship
What is a column in a table that is the primary key of another table known as? -
ANSWER Foreign key
Which of the following is an example of an entity constraint? - ANSWER A rule stating
that no part of the primary key can be null
Which of the following processes may reduce the duplication of data items within
a database, yet increase the number of tables within it? - ANSWER Normalizing
How are the tables that make up the data dictionary updated? - ANSWER They are
updated automatically by the DBMS as the system is used.
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 KenAli. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.