Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Travel Agents (Specialists) 
Back to the Data Model

SOUR - Statement of User REquirements
A fast-growing business that offers the Tourist something a little bit different. 
Through its website and attendance at various events, thecompany promotes the 
following services and products:
· Guided tours of famous historical sites, buildings and battlefields – across the world
· Customized expert lectures from world-renowned historians for private functions
· Genealogical research and family tree services – either face-to-face or remotely
· Historical documents and books location service – from across the world
· Historical book sales – from its own on-line book store
· History magazine subscriptions – issued quarterly in hardcopy and e-copy format
· Hands-on training workshops and courses – in historical and archaeological skills
The company needs a  database to run the company.
For each aspect of the business you must identify and capture the relevant data – such as
speaker details, customer details, lecture/visit dates and locations, book details, workshop
details etc. etc.
The above is simply an outline of the company and you will need to make your own
assumptions and interpret or even extend the scenario as you go. Use your imagination as
you see fit but you must clearly document all assumptions and extensions.
I’ve made a start.  
The first attachment is the ERD 0, I was asked to add sub-typing and relationship names, 
which I did in task 1.  
A suggestion to sub-type location, but I’m not sure what to do with that.  
task 2 is the more detailed version to build the final database from.
Business Rules and Comments
1. If the same Location appears many times in 
'Document Locations', we could consider
having a separate Locations table.
2. If you click on the beautiful picture in the top right-hand corner
it will take you to a web site displaying
"Washington, D.C. Neighborhoods for Travel Agents (Specialists)"


© DataBase Answers Ltd. 2016
About Us Contact Us