Database Answers US Navy Battleship (Click for large picture)

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Monitoring Naval Officers   
Back to the Data Model.
The Area being Modelled is :-
Monitoring Naval Officers

Question: Sirs, I am creating a website that will be used by junior Naval Officers to 
select mentors from a list of senior Naval Officers. 

The seniors will have probably about 10 jobs (orders) that they have held from 2-3 in duration. 

I want to create a database that will allow the juniors to search the jobs that seniors have 
held that match their desires. 

I am thinking of 10 tables, with the table 1 being the base senior officer info (name, rank,...) 
and the tables 2-10 to list the orders that each of the seniors have held. 

Table 2-10 would essentially be the same fields over and over again just going backward from most 
recent to the oldest. 

How do I set up the keys to make this work ?

I have a proposed schema that I can send along. 

Thanks. any help would be appreciated, and I will upload any information after this is done to help 
you website. 

Spencer


© DataBase Answers Ltd. 2010
About Us Contact Us