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...
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
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 Jessypeace. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.49. You're not tied to anything after your purchase.
