DD Class6
esse quam videri
Contents
Primary Keys
The candidate key selected as being most important for identifying a body of information (an entity, object or record).
Normalization
First Normal
- Form eliminates repeating groups by putting each into a separate table and connecting them with a one-to-many relationship.
Not Following First Normal Form Repeating Groups
Blog1
| BlogID | BlogText | recCreationDate | Mood |
|---|---|---|---|
| 1 | Blog1 | 03/30/03 | Happy |
| 2 | Blog2 | 03/30/03 | Happy |
| 3 | Blog3 | 03/30/03 | Sad |
| 4 | Blog4 | 03/30/03 | Happy |
| 5 | Blog4 | 03/30/03 | Mad |
Tables that Follow First normal form
Blog2
| BlogID | BlogText | recCreationDate | MoodID |
|---|---|---|---|
| 1 | Blog1 | 03/30/03 | 1 |
| 2 | Blog2 | 03/30/03 | 1 |
| 3 | Blog3 | 03/30/03 | 2 |
| 4 | Blog4 | 03/30/03 | 1 |
| 5 | Blog4 | 03/30/03 | 3 |
Mood
| MoodID | MoodName |
|---|---|
| 1 | Happy |
| 2 | Sad |
| 3 | Mad |
| 4 | Afraid |
1NF also
- Removes multiple column with the same type of data
Books Not Normal
Books
| Author | Title_01 | Pages_01 | Title_02 | Pages_02 | Title_03 | Pages_03 |
|---|---|---|---|---|---|---|
| Michael Allen Dymmoch | The Man Who Understood Cats | 256 | White Tiger | 320 | ||
| Joseph Cancellaro | Exploring Sound Design for Interactive Media | 272 |
In Class Build Blogs Table and Normalize Books Table
http://en.wikipedia.org/wiki/First_normal_form
ERD
http://en.wikipedia.org/wiki/Entity-relationship_model
tools
- http://staruml.sourceforge.net/en/ free and open source
- http://www.visual-paradigm.com/product/vpuml/ proprietary free community edition
Home Work
Normalize these tables. Make a UML Drawing for both tables.
Games
| GameTitle | GameGenre | DeveloperName | Platform(s) | Year | DeveloperWebsite | GameWebsite |
|---|---|---|---|---|---|---|
| Quake1 | FPS | id | Dos | 1996 | http://www.idsoftware.com/ | http://www.idsoftware.com/games/quake/quake/ |
| Diablo | RPG | Blizzard | Windows 95 | 1996 | http://www.blizzard.com/ | http://www.blizzard.com/diablo/ |
| SimCity | Sim | Interplay | Dos | 1993 | http://www.interplay.com/ | http://www.maxis.com/ |
Cheeses
| CheeseName | CheeseDescription | RegionName | Consistency | MilkType |
|---|---|---|---|---|
| Argentinian Reggianito | The vast grazing pastures of Argentina revealed themselves to be ideal for immigrant Italians.. | Hard | Argentina | Goats Milk |
| Feta | Feta is made in a traditional manner by a small family dairy in central Greece... | Crumbly | Greek | Mix of Milks |
| Cheddar | The most widely purchased and eaten cheese in the world. Cheddar cheeses were originally made in England, however today they are manufactured in many countries all over the world. | Semi-Hard | England | Cows Milk |
Build a blog interface to the blog tables we built in class. The blog interface requires
- An insert blog page. Don't worry about user names or authentications this is a very public blog more like a message board.
- A blogroll display page. Be careful which control you use to display the data.
Extra Credit is an edit or delete page.
READ BDD Chapter 4 again Chapter 5
READ BAD Chapter 8
