WGU C170 COMPILATION BUNDLE

elf-study activity Flashcards Learn Test Match 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? A One-to-one B One-to-many C One-to-one binary D Many-to-many D ...

Domain In data modeling, the construct used to organize and describe an attribute's set of possible values. Primary key (PK) An identifier composed of one or more attributes that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier. A minimal superkey. ...

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

Create Database Syntax CREATE DATABASE db_name; Simple SFW query syntax SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Outside Modality: Inside or outside? Inside What commands are used with data definition? create, alter, dro...

Key they are used to ensure that each row in a table is uniquely identifiable. They are also used to establish relationships among tables and to ensure the integrity of the data. A key consists of one or more attributes that determine other attributes. For example, an invoice number identifies all ...

Add New Row INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row DELETE FROM table_name WHERE condition; Inner Join SELECT column_name(s) ...

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? Many-to-many Refer to Diagram #2 Which kind of relationship is displayed in this entity-relationship diagram? Many-to-many u...

Access plan 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 An alternative name for a column or table in a SQL statement. ALTER...

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? One-to-one One-to-many Many-to-many One-to-one binary Many-to-many Which two examples are attributes? Choose 2 answers ...

If integer values are relatively small, what should be used instead of INT? SMALLINT What is the SQL command that allows a user to list the contents of a table? SELECT What is the process the DBMS uses to verify that only registered users access the database? Authentication W...

A database model is a conceptual framework for database software The relational model is a database model based on mathematical principles, with three parts: 1. A data structure that prescribes how data is organized. 2. Operations that manipulate data structures. 3. Rules that govern val...

The order of the rows and columns is important to the DBMS. True or False False PRODUCT yields all possible pairs of rows from two tables, also known as the _______ product. Cartesian According to Codd's ______ rule of relation database, "Application programs and ad hoc faciliti...

AREA In DB2, a named section of permanent storage space that is reserved to store the database. associative entity See composite entity. bridge entity See composite entity. candidate key A minimal superkey; that is, a key that does not contain a subset of attributes that is ...

CREATE TABLE syntax DDL CREATE TABLE tableName ( colName dataType constraint INDEX indexName (colName) PRIMARY KEY (colName, colName) or colName dataType PRIMARY KEY FOREIGN KEY (colName, colName) REFERENCES tableName (colName) ); CREATE INDEX syntax DDL CREATE [UNIQUE] INDEX inde...