|
Relational Database Design
Boot Camp
Objectives:
Training Day 1 (TD1): Introduction to Relational Database Design
At the end of this lesson, you will be able to:
- Define a relation (table)
- Define a column (attribute or field)
- Define a row (record or tuple)
- Define a primary key
- Define a foreign key
Training Day 2 (TD2): First Normal Form
At the end of this lesson, you will be able to:
- Define an anomoly.
- Define normal forms.
- Define the first normal form.
- Explain why you shouldn't store multiple values or multiple types in the same column.
- Explain the effects on queries and reports when multiple values and multiple types are stored in the same column.
- Explain how to prevent these effects.
Training Day 3 (TD3): Second Normal Form
Training Day 4 (TD4): Third Normal Form
 Top
Jarhead Jargon (Or Glossary Of The Marine's Language)
- ALICE pack: standard field pack; acronym for All-purpose Lightweight Individual Carrying Equipment.
- ASAP: As Soon As Possible; As Soon As Practicable. (Pronounced "ay sap." Don't spell it out loud, or people will think you're a rock.)
- black cadillacs: combat boots.
- bravo-zulu: well done, from the U.S. Navy's Allied Signals Book (ATP 1).
- "Deuce" gear: 782 gear (named after the DD Form 782 used when issuing gear to each Marine). Includes ALICE pack, web belt, canteens, poncho, sleeping bag, et cetera.
- double time: run; 36-inch steps at a pace of 180 steps per minute.
- fire team: smallest tactical unit, consisting of four Marines, which offers maximum control, maneuverability and fire power.
- Jarhead: a nickname for a Marine, from the description that a Marine's head (on top of the high collar when in uniform) looks like a Mason jar.
- Lake Bandini: affectionate name given by Marines who live or work nearby, or use the waste water treatment plant at Twentynine Palms, California, for the three-mile run on their semi-annual PFT course.
- Leatherneck: a nickname for a Marine, from the days when Marines' uniforms included a high collar made of leather to protect the Marine's neck from the slash of a sword.
- LPC's: "leather personnel carriers," or combat boots.
- Marine: the name Marine is always initially capitalized, because it is a title and therefore a proper noun, not a common noun. For example, there are many presidents (common noun) in the world, but only one President of the United States (title, i.e., proper noun). Every Marine has earned the title "Marine" by graduating from Marine Corps Boot Camp or Marine Corps Officer Candidate School and participating in the Emblem Ceremony. The sailors and soldiers of the world have noble occupations, but not titles. When sailors and soldiers graduate from their respective boot camps or officer candidate schools, they become either sailors or soldiers, i.e., their occupations.
- Mess Duty: one month special duty assignment helping cooks prepare meals in the Galley (or Mess Hall) for all Marines and sailors aboard the base, and then cleaning up afterwards. Usually allows for a one hour break between lunch and dinner, but otherwise, it's non-stop, sweaty, filthy work from 0400 till 1900 hours or so -- every day, including weekends and holidays.
- most ricky tick: in a hurry; "with a purpose"; move fast.
- PFT: Physical Fitness Test required of Marines to prove stamina, endurance, and strength.
- pogie bait: candy (used to lure admin pogues, or administrative clerks, away from their chairs in their offices -- otherwise, they'd never get up to get any exercise).
- rock: endowed with the brains of a rock.
- scuttlebutt: gossip or rumor; not to be believed; a drinking fountain.
- S-4: supply department of the organization.
- squared away: clean and neat; a good Marine.
- The Word: confirmed info.
You can read about your favorite expert contributors.
Copyright © 2005 - 2006 Q-Built Solutions. All rights reserved.
Top
Disclaimer: This information is not part of an official curriculum of the U.S. Marine Corps or any military service. The information contained in this article is solely the work of the author and is intended to provide readers with instructions on how to build a relational database with the proper techniques to avoid common problems that plague poor database design.
Visitors since 26 Nov. '05:
|
