SERVICIO NACIONAL DE APRENDIZAJE
SENA
Script Bases de Datos del Proyecto GA6-220501096-AA2-EV03
KEVIN ANDRES ARIAS GARCIA
PROGRAMA
TÉCNOLOGO ANALISIS Y DESARROLLO DE SOFTWARE 3134623
FICHA - 3134623
INSTRUCTORA
ELIZABETH GELVES
BOGOTA
03diciembre 2025
-- MySQL Script generated by MySQL Workbench
-- Thu Dec 11 20:56:17 2025
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE,
SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN
_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUB
STITUTION';
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
- -----------------------------------------------------
-- Table `sakila`.`Persona`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sakila`.`Persona` (
`cedula` VARCHAR(20) NULL DEFAULT NULL,
`nombre` VARCHAR(100) NOT NULL,
`apellido` VARCHAR(100) NOT NULL,
PRIMARY KEY (`cedula`));
-- -----------------------------------------------------
-- Table `sakila`.`Vehiculo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sakila`.`Vehiculo` (
`placa` VARCHAR(10) NULL DEFAULT NULL,
`marca` VARCHAR(50) NULL DEFAULT NULL,
`tipo` VARCHAR(50) NULL DEFAULT NULL,
`color` VARCHAR(50) NULL DEFAULT NULL,
`cedula_dueno` VARCHAR(20) NOT NULL,
PRIMARY KEY (`placa`),
INDEX (`cedula_dueno` ASC) VISIBLE,
CONSTRAINT ``
FOREIGN KEY (`cedula_dueno`)
REFERENCES `sakila`.`Persona` (`cedula`));
-- -----------------------------------------------------
-- Table `sakila`.`Entrada`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sakila`.`Entrada` (
`id` INT NULL DEFAULT NULL AUTO_INCREMENT,
`puesto` VARCHAR(20) NULL DEFAULT NULL,
`piso` VARCHAR(20) NULL DEFAULT NULL,
`fecha_entrada` DATETIME NOT NULL,
`cedula` VARCHAR(20) NOT NULL,
`placa` VARCHAR(10) NOT NULL,
PRIMARY KEY (`id`),
INDEX (`cedula` ASC) VISIBLE,
INDEX (`placa` ASC) VISIBLE,
CONSTRAINT ``
FOREIGN KEY (`cedula`)
REFERENCES `sakila`.`Persona` (`cedula`),
CONSTRAINT ``
FOREIGN KEY (`placa`)
REFERENCES `sakila`.`Vehiculo` (`placa`));
-- -----------------------------------------------------
-- Table `sakila`.`Salida`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sakila`.`Salida` (
`id` INT NULL DEFAULT NULL AUTO_INCREMENT,
`cedula` VARCHAR(20) NOT NULL,
`placa` VARCHAR(10) NOT NULL,
`fecha_entrada` DATETIME NOT NULL,
`fecha_salida` DATETIME NOT NULL,
`pago` DECIMAL(10,2) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX (`cedula` ASC) VISIBLE,
INDEX (`placa` ASC) VISIBLE,
CONSTRAINT ``
FOREIGN KEY (`cedula`)
REFERENCES `sakila`.`Persona` (`cedula`),
CONSTRAINT ``
FOREIGN KEY (`placa`)
REFERENCES `sakila`.`Vehiculo` (`placa`));
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;