June 8th Database Activities

Databases Reprise

In this section we are going to reprise our work on databases.

Look at the table below:

The table below contains details of animals at a zoo and the enclosure they live in.

Zoo

ID	Name	Breed	Gender	Date_Of_Birth	Enclosure	Capacity	Headkeeper
C009	Terry	Lion	Male	30/6/1982	Big Cats	12	J Milner
A002	Maria	Chimpanzee	Female	12/3/2012	Ape House	50	S Larkin
A019	Sam	Gibbon	Female	10/6/2002	Ape House	50	S Larkin
C015	Toni	Tiger	Female	18/6/2009	Big Cats	12	J Milner
B033		Red deer	Female	6/7/2007	Deer Park	200	A Hunt
A007	Charlie	Chimpanzee	Male	19/7/2011	Ape House	50	S Larkin

Re-organise the data into two linked tables called Animal and Enclosure.

Animal

Enclosure

HOMEWORK

The table below is called PlayList and it lists some of the songs on five albums of children’s songs.

PlayList

Album_Title	Artist	Released	Genre	Track_No	Song_Title	Time
In The Night Garden – A Musical Journey	Andrew Davenport	2007	Children’s music	3	Hello Igglepiggle!	0:38
In The Night Garden – A Musical Journey	Andrew Davenport	2007	Children’s music	12	Catch Makka Pakka’s Og-pog!	7:32
In The Night Garden – A Musical Journey	Andrew Davenport	2007	Children’s music	16	The Pinky Ponk	1:09
Heads, Shoulders, Knees & Toes	The C.R.S. Players	2004	Children’s music	1	Hokey Cokey	2:28
Heads, Shoulders, Knees & Toes	The C.R.S. Players	2004	Children’s music	12	Ten Green Bottles	2:33
50 Nursery Rhyme Songs	Countdown Kids	2009	Children’s music	1	Old MacDonald Had a farm	2:03
50 Nursery Rhyme Songs	Countdown Kids	2009	Children’s music	3	This Little Pig	1:13
50 Nursery Rhyme Songs	Countdown Kids	2009	Children’s music	12	Six Little Ducks	1:02
CBeebies the Album	Various Artists	2012	Children’s music	5	My Name is	1:21
CBeebies the Album	Various Artists	2012	Children’s music	12	Everything’s Rosie Theme Tune	0:43
CBeebies the Album	Various Artists	2012	Children’s music	21	Summer Song	1:54
Children’s Party Time	Kid’s Players	1995	Children’s music	12	The Birdie Song	2:23

·           Reorganise the data in the table above into two linked tables called Album and Song.

·           Describe how the relationship between the two tables (Album and Song) is created.

·           Give the number of fields and records in the Album table and in the Song table.