The document describes a game of dominoes that teaches about database normalization. Students are divided into groups, dealt dominoes that represent database terms and definitions, and take turns laying down matching dominoes until one player plays all their dominoes.
The document describes a game of dominoes that teaches about database normalization. Students are divided into groups, dealt dominoes that represent database terms and definitions, and take turns laying down matching dominoes until one player plays all their dominoes.
The document describes a game of dominoes that teaches about database normalization. Students are divided into groups, dealt dominoes that represent database terms and definitions, and take turns laying down matching dominoes until one player plays all their dominoes.
The document describes a game of dominoes that teaches about database normalization. Students are divided into groups, dealt dominoes that represent database terms and definitions, and take turns laying down matching dominoes until one player plays all their dominoes.
This activity is based upon the game of dominoes. You will need to first print this document and cut out each of the dominoes provided in this document.
A single field used as
Field the unique identifier for a record
A domino Divide your learners into groups of two players and give them a full set of dominoes. Ask the groups to choose a dealer who shuffles and mixes up the dominoes with the dominoes face down so that neither player can see what each domino has written on it. The dealer then shares the dominoes out (still face down) so that each player has ten dominoes. The remaining dominoes should be left face down in a pile on the table. Learners are then ready to play the game. The rules of dominoes are as follows: 1. The non-dealing player is first to lay a domino. They can choose any domino the wish from their set of dominoes. They place the domino on the middle of the table. 2. The other player then lays a domino from their set of dominoes. They have to choose a domino that matches either end of the domino on the table. Therefore, if one end of the domino has a definition on it, it must be matched with the appropriate term. Alternatively, if one end of the domino has a term on it, the player must match it with the appropriate definition. 3. Players continue to lay down matching dominoes at either end of the line of dominoes as it grows. 4. If a player cannot find a matching domino in their set of dominoes, they must pick up a domino from the pile of dominoes on the table and play passes to their opponent. 5. If a player places an incorrect match on the table they have to remove the domino and also pick another domino up from the pile on the table. Play passes to their opponent. 6. The winner is the first player to successfully match their set of dominoes on the table so that they have no more dominoes in their set. You can play dominoes in larger groups by giving the players a larger set of dominoes (two or three sets for example) to play with and still sharing out ten dominoes each, leaving the rest in the pile on the table.
Cambridge International AS & A Level Information Technology 9626
Multiple fields that are used together repeating fields and all the fields in the to create a unique identifier for a database are atomic. The database has record little structure.
A database that has atomic fields and has
had all repeating entries removed. Related fields are separated into different tables. Any fields that are not directly related to Unnormalised each other are further separated into tables Database that only contain fields that are directly related.
Database in 1NF A database that has repeating fields
and data, with little structure
Database in 1NF A collection of data about a person or item in a database
Cambridge International AS & A Level Information Technology 9626
repeating fields and all the fields in the Data in a field that cannot be broken down database are atomic. The database has any further little structure.
Database in 2NF A category of data in a database
Database in 2NF A collection of data about a person or item in a database
Cambridge International AS & A Level Information Technology 9626
removed and all data is atomic. Fields that A collection of data about a person or item are related are separated into different in a database tables, dependent on the primary key of the table.
A database that has atomic fields, and has
had all repeating entries removed. Related fields are separated into different tables.
Record Any fields that are not directly related to
each other are further separated into tables that only contain fields that are directly related.
A database that has had repeating entries
removed and all data is atomic. Fields that are related are separated into different Record tables, dependent on the primary key of the table.
Atomic data Record
Cambridge International AS & A Level Information Technology 9626
