Database Articles
- Non-Identifying vs. Identifying Relationships
- Diagrams and explanations showing the difference between non-identifying (dashed line) and identifying (solid line) relationships in relational database design.
- Unnormalized Database Designs
- Compares various relational database designs in first, second, and third normal form.
- Normalized Database Designs
- Contains various relational database designs normalized to third normal form.
- Student Housing Type
- A question and answer about the database design of housing type for students.
- MySQL auto_increment
- Tips for working with MySQL auto_incrment
- Entering Data with MySQL Workbench
- Tips for entering data into a database using the MySQL Workbench.
- Sample Data
- A small database complete with functions used for inserting sample data into another database.
- Templates for Basic SQL Queries
- Six templates for basic SQL queries that include filters, sorting, inner joins, scalar functions, aggregate functions, and grouping.
- Example SQL Queries
- Six example SQL queries from simple to intermediate
- Fisher-Yates Shuffle for MySQL
- A SLOW but working implementation of the Fisher-Yates shuffle algorithm for shuffling in place the values in a column of a single table.