|
|
| Line 1: |
Line 1: |
| − | [[Category:Data Design]]
| |
| | | | |
| − |
| |
| − | ==Primary Keys==
| |
| − | The candidate key selected as being most important for identifying a body of information (an entity, object or record).
| |
| − |
| |
| − | ==Normalization==
| |
| − | [http://en.wikipedia.org/wiki/Database_normalization Normal Forms]
| |
| − |
| |
| − | '''First Normal'''
| |
| − | :Form eliminates repeating groups by putting each into a separate table and connecting them with a one-to-many relationship.
| |
| − | :
| |
| − |
| |
| − | [[Data Relationships]]
| |
| − |
| |
| − | Not Following First Normal Form Repeating Groups
| |
| − |
| |
| − | Blog1
| |
| − | {| class="wikitable" cellpadding="5" cellspacing="0"
| |
| − | !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
| |
| − | {| class="wikitable" cellpadding="5" cellspacing="0"
| |
| − | ! 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
| |
| − | {| class="wikitable" cellpadding="5" cellspacing="0"
| |
| − | !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'''
| |
| − | {| class="wikitable" cellpadding="5" cellspacing="0"
| |
| − | !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'''
| |
| − | {| class="wikitable" cellpadding="5" cellspacing="0"
| |
| − | !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'''
| |
| − | {| class="wikitable" cellpadding="5" cellspacing="0"
| |
| − | !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
| |
