WGU C170 data management – applications Learning checks Exam Questions with complete Answers 2024/2025
5 views 0 purchase
Course
WGU 170
Institution
WGU 170
WGU C170 data management – applications Learning checks Exam Questions with complete Answers 2024/2025
Tables structural rules - no duplicate column names - correct answer duplicate column names are not allowed in one table. However, the same column name can appear in different tables.
Tabl...
WGU C170 data management – applications
Learning checks Exam Questions with
complete Answers 2024/2025
Tables structural rules - no duplicate column names - correct answer duplicate column
names are not allowed in one table. However, the same column name can appear in
different tables.
Tables structural rules - no duplicate rows - correct answer no two rows may have
identical values in all columns.
Data independence - relational databases - correct answer rows and columns of a
table have no inherent order.
Primary keys rules - values must be unique within the column - correct answer this rule
ensures that each value identifies at most one row.
Primary keys rules - values may not be null - correct answer this rule ensures that
each value identifies at least one row.
Composite primary keys rules - column values, when grouped together, must be unique
- correct answer ex: the combination (2538, 1) is unique within (id, number)
Composite primary keys rules - columns may - correct answer not contain null
Composite primary keys rules - composite primary keys - correct answer must be
minimal
A foreign key - correct answer is a column, or group of columns, that refer to a primary
key
Data types of foreign and primary key must be the same.
, Foreign keys rules - foreign key values may be repeated - correct answer ex: sales
and marketing have the same manager.
Foreign keys rules - foreign key values may be null - correct answer ex: technical
support currently has no manager.
Foreign keys rules - non-null foreign key values - correct answer must match some
primary key value.
Referential integrity - correct answer requires that all foreign key values must either be
fully null or match some primary key value.
Referential integrity can be violated in four ways: - correct answer 1. A primary key is
updated.
2. A foreign key is updated.
3. A row containing a primary key is deleted.
4. A row containing a foreign key is inserted.
Databases can automatically correct referential integrity violations with any of four
actions, which are specified in SQL when creating a table with a foreign key: - correct
answer 1. Restrict rejects an insert, update, or delete that violates referential integrity.
2. Set null sets invalid foreign keys to null.
3. Set default sets invalid foreign keys to a default primary key value, specified in SQL.
4. Cascade propagates primary key changes to foreign keys.
Redundancy - correct answer is the repetition of related values
Redundant tables have multiple copies of the same data - correct answer
inconsistency results when updates are not applied uniformly to all copies.
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 KieranKent55. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
