Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes every weekday Monday through Friday.
This page was generated by The HPR Robot at


hpr0014 :: Databases 101 Part 2

Part 2 of Database 101 with Stankdawg

<< First, < Previous, , Latest >>

Hosted by StankDawg on 2008-01-18 is flagged as Explicit and is released under a CC-BY-NC-SA license.
RDBMS, table, normalisation, field, record, key, primary key. (Be the first).
The show is available on the Internet Archive at: https://archive.org/details/hpr0014

Listen in ogg, spx, or mp3 format. Play now:

Duration: 00:26:09

Databases.

This series will attempt to discuss various different aspects of Database design and operation.

RDBMS - Relational Database Management System

Relational Model: when there are relationships between items of data such as products, customers and orders

A database contains two-dimensional tables which are similar in concept to spreadsheets. Each table contains columns and rows like a spreadsheet, but these are called fields and records in database terminology

Data is stored in tables but is broken down into the most efficient form such that there is no duplication. This process is called normalisation.

Fields have data types associated with them, such as numeric fields for storing numbers or text fields for storing text.

Tables have keys to simplify searching. Primary keys are used to make records in a table unique.

Shownotes by: Dave Morriss, 2015-08-14


Comments

Subscribe to the comments RSS feed.

Leave Comment

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Title:
Comment:
Anti Spam Question: What does the letter P in HPR stand for?
Are you a spammer?
What is the HOST_ID for the host of this show?
What does HPR mean to you?