-
Michael G Garner commented on the post, Extra Point to The Final Exam, on the site DATA ANALYTICS 1 year, 1 month ago
I’m here.
-
Michael G Garner commented on the post, W6 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
Alter is part of a DDL statement that modifies or changes. “Alter Database” modifies a database, and “Alter Table” modifies a table. Insert is part of a DML statement. “Insert Into” adds or inserts data into a […]
-
Michael G Garner commented on the post, W5 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
SQL may be split into two parts, Data Manipulation Language (DML) and Data Definition Language (DDL). DML consists of data queery and update commands, while DDL permits data base tables to be created or deleted. […]
-
Michael G Garner commented on the post, W4 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
When an Entity Relationship Diagram (ERD) is used to create a Structured Queery Language (SQL), it is called forward engineering. Forward engineering creates new processes and models. When SQL is used to create an […]
-
Michael G Garner commented on the post, W3 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
To resolve the many to many relationship problem, a new entity table must be created. The new table should be named by combining the other two table names. Each of the primary keys for the other entity tables will […]
-
Michael G Garner commented on the post, W2 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
2. A primary key is a charactersistic that uniquely identifies an entity. Primary keys are an important part of organizing the data within an ERD. Primary keys may not repeat. A foriegn key is a charateristic of […]
-
Michael G Garner commented on the post, W1 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
DQ1. Transactional data are real time, raw facts and organized data that assist in managing the operations of an organization. Transactional data is stored/organized in a transactional database for easy retrieval […]
CONNECT