Transcript Database design

CS27510
Database Design
An example
• This site is not my preferred but it is high
up in Google
• It has lots of features
• http://www.campingfrance.com/UK
Home Page
• Homepage
–
–
–
–
–
–
Search
Navigation
Map/text links to French Regions
About us
Contact us
Introduce look and feel of site
• Database Tables
Region Pages
•
•
•
•
•
•
•
•
Map of region
Campsite marked on map
Attractions
Regional Information
Airports
Affiliates -Rotating and Contextual
Adsense
Banner Ads – Rotating and Contextual
• Database Tables
Campsite Pages
•
•
•
•
•
Name
Address with postcode
GPS coordinates
Web address, email and phone
Site facilities
–
–
–
–
–
Electricity
Pool
Restaurant
Beach
And many others
• Prices
• Booking method
• Nearby attraction (may be peripheral
to main data section)
• Database tables
Website Administration
• Password controlled
– Change all text, pics
and video
– All dropdowns editable
etc
– Introduce HTML editor
to speed things up
– E.g. tinyMCE
• Database tables
Campsite Administration
• Both campsite owner
•
and web owner can
change data
Use simple forms
• Database Tables
Revenue
• Banner ads
– Need ad rotators
– Pay per click, pay per
impression (1000)
– Look up size standards
for ads
• Affiliate ads
– More targeted type of
advert
– Could look to visitor
like normal banner ads
• Database tables