100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Relational Database Fundamentals Quizzes Solved 100% Correct $12.99   Add to cart

Exam (elaborations)

Relational Database Fundamentals Quizzes Solved 100% Correct

 0 view  0 purchase
  • Course
  • Relational Databases
  • Institution
  • Relational Databases

Relational Database Fundamentals Quizzes Solved 100% Correct

Preview 2 out of 10  pages

  • October 26, 2024
  • 10
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Relational Databases
  • Relational Databases
avatar-seller
KenAli
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

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 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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

73918 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
$12.99
  • (0)
  Add to cart