A Gentle Introduction to

SQL

Edinburgh Buses

This database consists of two tables: stops and routesgoogleEsta base de datos consiste en dos tablas: paradas y rutas

stopsgoogleparadas

This is a list of areas served by buses. The detail does not really include each actual bus stop - just areas within Edinburgh and whole towns near Edinburgh.googleÉsta es una lista de las áreas servidas por los autobúses. El detalle realmente no incluye cada parada real del autobús - áreas justas dentro de Edimburgo y de ciudades enteras cerca de Edimburgo.

FieldTypeNotes
idINTEGERArbitrary value
nameCHAR(30)The name of an area served by at least one bus

routegoogleruta

A route is the path through town taken by a bus.googleUna ruta es la trayectoria a través de la ciudad tomada por un autobús.

FieldTypeNotes
numCHAR(5)The number of the bus - as it appears on the front of the vehicle. Oddly these numbers often include letters
companyCHAR(3)Several bus companies operate in Edinburgh. The main one is Lothian Region Transport - LRT
posINTEGERThis indicates the order of the stop within the route. Some routes may revisit a stop. Most buses go in both directions.
stopINTEGERThis references the stops table

As different companies use numbers arbitrarily the num and the company are both required to identify a route.googlePues diversas compañías utilizan números arbitrariamente el numérico y requieren a la compañía ambas identificar una ruta.


Footnotes