Show:
Databasics
Normalization
Relationships
Commands
More Commands
100
A structure that contains different categories of information and the relationships between these categories
What is a Database?
100
A table that does not contain any repeating groups
What is first normal form (1NF)?
100
The column or collection of columns that uniquely identifies a given row in a table
What is a primary key?
100
The SQL command used to delete a row in a table
What is DELETE?
100
A file that contains one or more SQL commands
What is a script or a script file?
200
Process of determining the particular tables and columns that will comprise a database
What is database design?
200
A column that is not part of the primary key
What is a nonkey column?
200
The association between entities
What is a relationship?
200
The SQL command used to describe the layout of the table
What is CREATE TABLE?
200
The SQL command used to add rows to a table
What is is INSERT?
300
A row in a table
What is a record or a tuple?
300
A process that analyzes a database design to identify the existence of potential problems and implements ways to correct these problems
What is normalization?
300
A collection of relations
What is a relational database?
300
The SQL command used to view data in a table
What is SELECT?
300
The SQL command used to change a value in a table
What is UPDATE?
400
A characteristic or property of an entity
What is an attribute?
400
A relation in second normal form and the only determinants it contains are candidate keys.
What is Boyce-Codd normal form or third normal form?
400
A relationship in which one entity is associated with many other entities
What is one-to-many relationship?
400
The SQL command used to delete an entire table
What is DROP TABLE?
400
The clause in a CREATE TABLE command used to indicate which columns cannot contain null values
What is NOT NULL?
500
A person, place, object, event, or idea for which you want to store and process data
What is entity?
500
A table that is in first normal form and where no nonkey column is dependent on only a portion of the primary key
What is second normal form (2NF)?
500
A graphical illustration for database design that uses rectangles for entities and arrows for relationships
What is a entity-relationship (E-R) diagram?
500
The SQL command used to list all of the columns in a table and their corresponding data types
What is DESCRIBE?
500
Create a new database model in MySQL
What is CREATE SCHEMA?