Chapter 4: Relational Databases Overview

A primary key is the attribute, or combination of attributes, that uniquely identifies a specific row in a table.

A foreign key is an attribute in one table that is also a primary key in another table and is used to link the two tables.

Update anomaly, Insert anomaly, Delete anomaly.

<p>Having a set of related tables helps in reducing redundancy and inefficiency in the database.</p> Signup and view all the answers

<p>Primary key must be single valued and not null; Foreign key must correspond to a primary key value in another table.</p> Signup and view all the answers

<p>Normalization helps in organizing data into multiple related tables to reduce redundancy and anomalies.</p> Signup and view all the answers

<p>A related group of records</p> Signup and view all the answers

<p>Analyzing large amounts of data for strategic decision making</p> Signup and view all the answers

<p>Data is integrated, Data sharing, Minimize data redundancy and inconsistencies, Data is independent of the programs that use the data, Data is easily accessed for reporting and cross-functional analysis</p> Signup and view all the answers

<p>External level</p> Signup and view all the answers

<p>How the data is actually physically stored in the system</p> Signup and view all the answers

<p>Users’ needs and the conceptual level of the entire database as well as the physical view</p> Signup and view all the answers

<p>An organization-wide view of the entire database.</p> Signup and view all the answers

<p>To grant permissions for creating, reading, updating, and deleting data.</p> Signup and view all the answers

<p>It serves as a 'blueprint' of the database structure.</p> Signup and view all the answers

<p>DDL builds the data dictionary, creates the database, and specifies security constraints.</p> Signup and view all the answers

<p>DML changes database content by updating, inserting, or deleting data elements.</p> Signup and view all the answers

<p>DQL enables users to retrieve, sort, order, and display data.</p> Signup and view all the answers

<p>Semantic data modeling</p> Signup and view all the answers

<p>By querying the data</p> Signup and view all the answers

<p>Volume, Velocity, Variety, Veracity</p> Signup and view all the answers

<p>By providing real-time dynamic reports</p> Signup and view all the answers

<p>Massive amounts of data captured, stored, and analyzed by companies</p> Signup and view all the answers

<p>A mental attitude or way of thinking</p> Signup and view all the answers

<p>A way of thinking that centers on the correct use of data and analysis for decision making.</p> Signup and view all the answers

<p>Specific, Measurable, Achievable, Relevant, Timely</p> Signup and view all the answers

<p>Extract, Transform, Load</p> Signup and view all the answers

<p>It is often the most time-consuming part of the analytics mindset process.</p> Signup and view all the answers

<p>Understand data needs and the data available, Perform the data extraction</p> Signup and view all the answers

<p>They can be fully automated so that the extracting, transforming, and loading data is done entirely by a computer program.</p> Signup and view all the answers