Skip to content

Instantly share code, notes, and snippets.

group: Control 2 SQL
description[[ Dataset para Control 2
Tiendas(tid PRIMARY KEY, capacidad, minpersonal)
Productos(pid PRIMARY KEY, nombre, precio, tipo)
Vende(tid,pid) PRIMARY KEY(tid,pid)
Usuarios(uid PRIMARY KEY, nombre, calle, comuna, region)
Compras(cid PRIMARY KEY, uid, tid)
Contenido_Compra(cid,pid,cantidad) PRIMARY KEY (cid,pid)
@jmndoza
jmndoza / gist:1607d8c2b0bf739c4256186783d467e1
Last active March 29, 2022 23:55
Control 1 BDD 2022-1
group: Control 1 Algebra Relacional
description[[ Dataset para Control 1
(1)
πnombre (σedad<25∨nacionalidad='Chile' Personal)
(2)
πpersonalId (TrabajaEn⨝Navegaciones⨝ σnombre='Lagos del Sur' Navieras)
(3)
group: Guia 1 Algebra Relacional
description[[ Dataset para Guia 1 ]]
Jugador = { nick nombre
Y-Solowarm Becki
Tresom Thebault
Daltfresh Mirella
Namfix Charmaine
Trippledex Sigismund
Toughjoyfax Angus
@jmndoza
jmndoza / basic_bind9_configuration.md
Created September 20, 2021 01:21
Create your own DNS server with bind9

Bind9 Basic Domain Configuration

Example Domain: mydomain.com

Install Bind9

foo@bar:~$ apt-get install bind9
foo@bar:~$ cd /etc/bind
@jmndoza
jmndoza / gist:827be2e97ceb4ad0830d9e7dc6b6b04e
Last active August 23, 2020 23:14
BD Control 1 2020-2
group: Tours
description[[ Dataset Control 1 2020-2 ]]
Tours = { tid nombre duracion precio
1 'Quinta' 4 15000
2 'Quinta lujo' 5 25000
3 'Chile premium' 48 109999
4 'Vinos del Mar' 12 58000
}
@jmndoza
jmndoza / mac-setup-redis.md
Created July 17, 2020 12:02 — forked from tomysmile/mac-setup-redis.md
Brew install Redis on Mac

type below:

brew update
brew install redis

To have launchd start redis now and restart at login:

brew services start redis
@jmndoza
jmndoza / api.js
Created May 3, 2020 00:23 — forked from mariocesar/api.js
Axios single configured instance
import axios from "axios";
const singleton = Symbol();
const singletonEnforcer = Symbol();
function readCookie(name) {
const match = document.cookie.match(new RegExp('(^|;\\s*)(' + name + ')=([^;]*)'));
return (match ? decodeURIComponent(match[3]) : null);
}
group: Visitas
description[[ visitas antes de las 18hrs:
σ hora<'18:00:00' (Visitas)
]]
Visitas = { id:number hora:string fecha:date
1 '16:01:00' 2020-03-20
@jmndoza
jmndoza / gist:6de6266bb2fea2b082a58c884d0069c6
Last active March 20, 2020 06:41
Dataset Guía Álgebra Relacional
group: Actores y Peliculas
description[[ Dataset para Guía Álgebra Relacional
Ejemplos:
(1) σ edad>40 (Actores)
(2) σ director='Hermanos Russo' ∧ genero='Drama' (Peliculas)
(3) π nombre_personaje (Actuo_en)