True or false: Most databases that you will ever have access to are based on a language called “Structured Query Language”?
True! It’s also abbreviated as SQL
DBMS?
Database management system
Does SQL pay attention to capitalization or white space (between words or lines)?
No.
What is conventional to capitalize on SQL?
Statements such as: WHERE, SELECT, FROM. And functions (such as SUM, AVG, and MAX) because it makes it more readable for humans, just not necessarily the computer.
What’s true regarding information quality?
While more information quality is better, its optimal to act to a certain level of “poor quality” if achieving higher quality information would cost more than the additional quality is worth.
What’s true about attributes?
Attributes describe the different characteristics of the things we collect information about.
What’s the most likely key for an associative table?
One that connects two different tables (using their primary keys as foreign keys)
What’s an entity?
It’s a table! And an attribute is a column of the table. It contained characteristics of the table’s information.
What’s the different between a primary and a foreign key?
A primary key is a unique identifier on a row of the table. A foreign key is a primary key of one table that shows up on another table.
What’s a composite key?
A primary key that consists of two or more attributes (columns) that together uniquely identify a record within a table.
What’s an artificial key?
It’s a system-generated primary key, such as an “Auto-Increment” ID, that has no business meaning and exists solely to uniquely identify a row.
What’s a Semantic Key?
A primary key derived from existing data that carries actual meaning.
In ERD, what does Cardinality represent?
The nature of the relationship between tables
What is the purpose of an associative table in a database?
To establish unique instances for many-to-many relationships
Which of the following best describes a composite key?
A unique identifier made from multiple columns
