# removed
Database Answers Header Fishing Boat in Fog, Alaska
Physical Data Model for City Licences
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

A Physical Data Model is shown on this page, and a Conceptual Model is also available.

Here is the SQL to produce Total Licences by Area and Year ...
SELECT Areas.AreaName,Persons.YearNumber,COUNT(*)
FROM  Areas,City,Community,Licences,Persons
WHERE Area.AreaCode = Community.AreaCode
AND   Community.CommunityCode=City.CommunityCode
AND   City.CityCode = Persons.CityCode
AND   Persons.PersonID = Licences.PersonID
AND   Persons.YearNumber = Licences.YearNumber
GROUP BY AreaName,YearNumber;
Physical Data Model for City Communities

Barry Williams
Principal Consultant
Database Answers

[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

© IceBreaker WebDesigns 2001