Flatfile database:
A databse held as a single table. It is structured with a row for every record.
Relational database:
A database that uses more than one table. Tables are linked together by common data items, such as ID number, known as keys.
The database I am using in this blog post is here:
Finding a specific region; e.g. South East:
Finding a number greater than a given value; e.g. greater than £10:
Finding a number less than a given value; e.g. less than £10:
Finding all values except a particular value; e.g. all activities outside Wales:
The number of records that satisfy the criteria Entry Cost<£8.50 were 358:
Below are the names of all of the attractions in East Anglia:
| Name |
|---|
| Audley End House and Gardens |
| Blickling Hall |
| Kentwell Hall |
| Sandringham Estate |
| The Cressing Temple Barns |
| Adventure Island |
| Bedford Museum |
| Verulamium Museum |
| Strikers Ten Pin Bowling |
| Holkham Hall |
| Hatfield House |
| Ascott House and Gardens |
| Cambridge Museum of Technology |
| Royston Cave |
| Hertfordshire Sports Village |
| Splash Sheringham |
| Colchester Leisure World |
| Go Ape |
| Sea Life Centre Great Yarmouth |
| Wooside Animal Farm and Leisure Park |
| Deben Swimming Pool |
| Extreeme Adventure |
| Oasis Beach Pool |
| Colchester Zoo |
| Paradise Wildlife Park |
| Africa Alive! |
| Amazona Zoo |
| Banham Zoo |
| Bedford Butterfly Park |
| English School of Falconry |
| Hunstanton Sea Life Sanctuary |
| Linton Zoo |
| Mole Hall Wildlife Park |
| Pensthorpe Nature Reserve |
| Sealife Adventure |
| Sheringham Park |
| The Raptor Foundation |
| Whipsnade Zoo |
| Grimes Graves |
| Muckleburgh Collection |
| Norwich Castle |
| Bewilderwood |
| Dinosaur Adventure |
| Hoo Hill Maze |
| Manning's Amusement Park |
| Pleasurewood Hills |
| Regal Movieplex |
| Walton Pier |
| Colchester Castle Museum |
| Imperial War Museum |
| Merrivale Model Village |
| Museum of East Anglian Life |
| Nelson Museum and Tour |
| Sedgewick Museum of Earth Sciences |
| Yesterday's World |
| Bassingbourn Snowsports Centre |
| Wells Beach Leisure |
| Aqua Splash |
| Bressingham Steam Experience |
| Wells Harbour Railway |
| Mississippi Paddle Boat |
Below are the attractions which satisfy the criteria Entry Cost>5 and Region="South East":
| Name |
|---|
| Hever Castle |
| Guildford Spectrum |
| Worthing Aquarena |
| Thorpe Park |
| Windsor Castle |
| Adventure Farm |
| Amazon World |
| Ashdown Forest Llama Park |
| Beale Park |
| Bird World |
| Blackgang Chine |
| Butterfly & Fountain World |
| Cotswold Wildlife Park and Gardens |
| Drusillas Park |
| Earnley Butterfly Park |
| Howlett's Wild Animal Park |
| Isle of Wight Zoo |
| Port Lymphne Wild Animal Park |
| Surrey Hills Llamas Trek |
| The British Wildlife Centre |
| Wildwood |
| Oxford Castle Unlocked |
| Spinnaker Tower |
| Chessington World of Adventures |
| Lego Land |
| Paultons Family Theme Park |
| Robin Hill Country Adventure Park |
| Tree Jumpers Sky Park |
| Amberley Working Museum |
| Dickens World |
| Milestones-Living History Museum |
| The Look Out Discovery Centre |
| The Museum of Kent Life |
| Hampton Court Palace |
| Blenheim Palace |
| Bucks Railway Centre |
| Leeds Castle |
| Gulliver's Land |
| Canterbury Tales |
| The Ice Bowl |
Amazon database:
In the book section of Amazon's database, the fields include:
- the title - gives the name of the book.
- the price - lets the potential customer know whether or not it is in their price range.
- the author - gives the credit to the writer of the book.
- the publisher - gives the credit to the publisher of the book.
- image(s) - gives the potential customer an idea as to what the book looks like/includes.
- customer review(s) - lets the potential customer discover what other customers thought of the book before they purchase it.
- search terms - lets the potential customer search for other products using keywords.
- product details - gives the potential customer an idea of what they are considering purchasing.
- product description - gives the potential customer an idea of what the product includes.
No comments:
Post a Comment