Skip to content

Instantly share code, notes, and snippets.

@civera2

civera2/Consultas-Caso 6 Tarjeta Sube

Created May 13, 2019 04:48
Show Gist options
  • Save civera2/9611bc3f3fab45cc030bdb4ad4f4b217 to your computer and use it in GitHub Desktop.
Save civera2/9611bc3f3fab45cc030bdb4ad4f4b217 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Consultas-Caso 6 Tarjeta Sube
1.Personas (todos los datos) que solamente han tomado la línea 26A de la provincia de San Juan.
B=ρE (πcuit,codlinea (πcuit (σ prov='San Juan' Emp)⨝(σcodlinea='26A' Lin)))
C=ρTA (π num (V⨝ (V.empresa≠E.cuit and V.codlinea=E.codlinea) or ( V.empresa=E.cuit and V.codlinea≠E.codlinea) or (V.empresa≠E.cuit) B))
HH = (π num V-C)⨝Tar
HH
Otra solución
TNSJ=ρ NSJ ( πnum ( σprov≠'San Juan' (V⨝V.empresa=Emp.cuit Emp)))
TSJ= πnum (V ⨝ V.empresa=Emp.cuit and codlinea≠'26A' and prov='San Juan' Emp)
(πnum V-(TNSJ∪TSJ))⨝ Tar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment