WGU C170 Data Management – Applications

Document Content and Description Below

WGU C170 Data Management – Applications domain Answer- In data modeling, the construct used to organize and describe an attribute's set of possible values superkey Answer- An attribute or attribu... tes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key Answer- A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey entity integrity Answer- The property of a relational table that guarantees each entity has a unique value in a primary key and that the key has no null values referential integrity Answer- A condition by which a dependent table's foreign key must have either a null entry or a matching entry in the related table data dictionary Answer- A DBMS component that stores metadata. It contains the data definition & their characteristics and relationships; may also include data external to the DBMS system catalog Answer- A detailed system data dictionary that describes all objects in a database homonym Answer- The use of the same name to label different attributes, much like similar-sounding words with different meanings synonym Answer- The use of different names to identify the same object, such as an entity, an attribute, or a relationship. These should generally be avoided. not null and unique Answer- Any candidate key must have these two constraints enforced cardinality Answer- Term for how many instances of one object are related to instances of another object (maximum)modality Answer- Term for whether an instance of a specific entity is optional or mandatory in a relationship (minimum) connectivity Answer- Term for the classification of the relationship between entities. Classifications include 1:1, 1:M, and M:N CREATE SCHEMA AUTHORIZATION Answer- SQL command to create a database schema DEFAULT Answer- SQL option to define a default value for a column (when no value is given) CHECK Answer- SQL command to validate data in an attribute, used during table column creation CREATE TABLE AS Answer- SQL command to create a new table based on a query in the user's database schema HAVING Answer- SQL option that restricts a selection of grouped rows based on a condition EXISTS Answer- SQL option that checks whether a subquery returns any rows DECIMAL Answer- SQL data type like the NUMBER specification, but the storage length is a minimum specification [Show More]

Last updated: 2 years ago

Preview 1 out of 6 pages

Buy Now

Instant download

We Accept:

Buy this document to get the full access instantly

Instant Download Access after purchase

Buy Now

Instant download

We Accept:

Report Copyright Violation

Also available in bundle (1)

Data Management Applications C170, project with complete solution C170 PROJECT with Complete Solution SQL study guide with complete solution WGU C170 Data Management – Applications WGU Data Management - Applications - C170 OA GSA1 WGU Course C170 - Data Management (Applications) with complete solution guide WGU C170 Terms With Complete Solution Data Management Applications C170 with complete solution WGU C170 - PRE-ASSESSMENT LATEST 2021 GRADED A+ C170 - Data Management Applications V4.0 - Quiz 3 – WGU WGU C170 Objective Assessment – Edward M Burke

Data Management Applications C170, project with complete solution C170 PROJECT with Complete Solution SQL study guide with complete solution WGU C170 Data Management – Applications WGU Dat...

By Professor Lynne 2 years ago

$11