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.

Summer Half-Term Revision

Half Term Revision and Homework

1.       Revise the topic of the CPU

http://www.teach-ict.com/gcse_computing/ocr/212_computing_hardware/cpu/miniweb/index.htm

Revise Networking but in particular focus on LAN, WAN, EXTRANET, INTRANET and VPN

   

http://www.teach-ict.com/gcse_computing/ocr/215_communications_networking/networks/miniweb/index.htm

3.       You will be asked to write an algorithm/flow-chart

http://www.teach-ict.com/gcse_computing/ocr/216_programming/algorithms/miniweb/index.htm

Revise algorithms by completing the following task and posting your answer by way of a reply to this post:

Rail fares are based on the distance travelled:

 • fewer than 5 miles: £2.50

• 5–12 miles: £3.25

• more than 12 miles: £4.15

 A processor in the exit barrier calculates the fare. A discount of 10% is given for off-peak travel, i.e. after 10 am and before 5 pm on Monday to Friday or any time on Saturday and Sunday. The ID of the railway station at which a passenger starts their journey is recorded on their card when they swipe in. The processor in the exit barrier uses a data structure called ListOfStations to look up the distance travelled.

 Write an algorithm to calculate the cost of a passenger’s journey. It must read in the start of the journey from the card, calculate the fare and apply any discount. The information must then be displayed in a customer-friendly way. (8)

RDBMS

Create a detailed digital resource about RDBMS:

You should explain:

Entity relationships
Primary key
Foreign key

Data validation
Data verification

Tables
Forms
Queries
Reports

Data Redundancy