West Coast Ingres Users Group Canada,(re-post)

West Coast Ingres Users Group Canada,(re-post)

Post by Kelwant Ba » Fri, 04 Nov 1994 02:29:48



                        West Coast Ingres Users Group (Canada)
                       =======================================

                        Wednesday November 9th, 1994   12:45
Location
==========
        Westin Bayshore
        1601 West Georgia
        Vancouver, B.C.

Registration
============
        Kapil Lohia
        Vice Chairperson, WCIUG
        Phone 604.654.4151
        Fax   604.654.4667

             AGENDA
            ========

12:45                     Registration

1:00                       IUG Introduction

1:10                       Introduction to Computer Associates
                              Hayley Tabor,
                              Vice President of Sales, Western Canada, CA

1:30                       CA-INGRES statement of direction
                              Steve Vandor
                              International Strategic Services Group. CA

3:00                       Break / Light Refreshments

3:20                       SQR Report Writer
                              Mark Firmin
                              M.I.T.I.

4:20                       Impressions of INGRES World 94 in Chicago
                              Kapil Lohia    
                              Arrakis Consulting

__________________________________________________________________________________
Kelwant Bahi,  Co-Chairperson
West Coast Ingres Users Group

phone 604.278.3411

 
 
 

1. SQL Travel Timetables repost [post post post apology etc]

Anyone got any experience in setting up a timetable on SQL Server.
Essentially, I want to answer the question..........

SHOW [TIMETABLE] FOR [ROUTE] BETWEEN [STATION A] AND [STATION B] BETWEEN
[TIME A] AND [TIME B]

A timetable will have a Route, Stations and Journeys.
So there MAY be a Routes table(RouteID & RouteName),

a Stations table containing a stID, RouteID, stationName, order  [select
stationName from stations where RouteID=XXX and stID > A and stID <= B order
by order] = Route between station A and station B

A journey could be thought of as a vehicle that starts at a particular time
and travels through stations on a route  so
there may be several journeys in a day [ie  a column in a timetable]. note
that for a particular station in a route, there may not be a journey entry
=> vehicle doesnt stop there. So a Journey table might contain
jID, stID, RouteID, departTime [select departTime from journeys where stID
in (see above statement or similar) and departTime > time A and departTime
<= time B.

Am I oversimplifying the problem or making it too complex, or am I on the
wrong track alltogether. Any help on setting up the table structure would be
appreciated.

It has been suggested that I look at some books by Joe Celko.  I now have
them and am beginning to peruse. (a bit cryptic in places but the Puzzles
and answers book may have something similar but disguised). Any comments.

Paul L.

2. Why has replication stopped distributing?

3. Travel Timetables repost [post post post apology etc]

4. cursor

5. Toronto (Canada) Delphi Users Group Meeting June 13th

6. READ DEACTIVATE

7. pick user group in Canada?

8. Searching a database for a particular product

9. pick user group in canada

10. USER GROUP IN CANADA

11. JAVA DELIVERY TECHNOLOGISTS/INSTRUCTORS- East, Central and West Coast

12. Program Manager for MSN Internet Access Support Operations-WEST COAST,WA