100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
C170 WGU ALREADY PASSED $7.99   Add to cart

Exam (elaborations)

C170 WGU ALREADY PASSED

 2 views  0 purchase
  • Course
  • Institution

An entity is said to be X -dependent if it can exist in the database only when it is associated with another related entity occurrence. - existence A table that has all key attributes defined has no repeating groups and all its attributes are dependent on the primary key is said to be in X. - 1n...

[Show more]

Preview 2 out of 6  pages

  • November 30, 2023
  • 6
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
avatar-seller
C170 WGU ALREADY
PASSED
An entity is said to be X -dependent if it can exist in the database only when it is associated with
another related entity occurrence. - ✔✔existence



A table that has all key attributes defined has no repeating groups and all its attributes are
dependent on the primary key is said to be in X. - ✔✔1nf



A determinant is any attribute whose value determines other values within a column. - ✔✔F



X is a process that is used for changing attributes to entities. - ✔✔Normalization



Any attribute whose value determines other values within a row is known as a X. - ✔✔determinant



Data redundancy produces data anomalies - ✔✔T



Normalization is a very important database design ingredient and the highest level is always the most
desirable. - ✔✔T



A table that is in 2NF and contains no transitive dependencies is said to be in X. - ✔✔3NF



An attribute that cannot be further subdivided is said to be X. - ✔✔atomic



In the X no row may contain two or more multivalued facts about an entity. - ✔✔4NF (fourth normal
form)



When a table contains only one candidate key X are considered to be equivalent. - ✔✔3nf and bcnf

, All relational tables satisfy the X requirements. - ✔✔1NF (first normal form)



BCNF can be violated only if the table contains more than one X key. - ✔✔candidate



All relational tables satisfy the 1NF requirements. - ✔✔T



When designing a database you should X. - ✔✔make sure that the table entities are normalized
before table structures are created



Using the X command SQL indexes can be created on the basis of any selected attribute. - ✔✔CREATE
INDEX



A table can be deleted from the database by using the X statement. - ✔✔DROP TABLE



Most SQL implementations yield case-insensitive searches. - ✔✔F



To list the contents of a table you must use the DISPLAY command. - ✔✔F



The X clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT
statement. - ✔✔HAVING



A X sequence is a multilevel ordered sequence that can be created easily by listing several attributes
separated by commas after the ORDER BY clause. - ✔✔cascading order



A X also known as a nested query or an inner query is a query that is embedded (or nested) inside
another query. - ✔✔subquery



The special operator used to check whether an attribute value matches a given string pattern is X -
✔✔LIKE



A X is a logical group of database objects such as tables and indexes that are related to each other. -
✔✔schema

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 Layer. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $7.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

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