WGU C170 EXAM PACKAGE DEAL GRADED A+

Access plan - Answer A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias - Answer An alternative name for a column or table in a SQL statement. ...

Associative Entity - Answer All relationships for the (...) entity should be many. Attribute - Answer An (...) is a property or characteristic of an entity. Binary relationship - Answer A (...) is a relationship between two entity types. Cardinality - Answer (...) represents the maximum number of...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? - Answer Many-to-many Which two examples are attributes? - Answer An employee number; A meeting code Which delete rule sets column value...

domain - Answer In data modeling, the construct used to organize and describe an attribute's set of possible values superkey - Answer An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key - Answer A minimal superkey; th...