@cmalanda

Create table Prestamos ( ID_Deudor INTEGER primary key, Nombre_deudor char (100), Monto int, Fecha text, Producto varchar (100)); insert into Prestamos (ID_Deudor, Nombre_deudor, Monto, Fecha, Producto) values (1, 'Jose', '100'

PRAGMA foreign_keys = ON; DROP TABLE IF EXISTS sales; DROP TABLE IF EXISTS categories; CREATE TABLE categories ( category TEXT PRIMARY KEY NOT NULL ); CREATE TABLE sales ( sale_id INTEGER PRIMARY KEY, category TEXT NOT NULL REFERENCES categories(cat

Create table alumnos( id_alumnos int primary key, Nombre varchar(50), Apellido varchar(100), Curso varchar(10) ); insert into alumnos(id_alumnos,Nombre,Apellido,Curso) values (1,"Jorge","Sanchez","2B"); insert into alumnos values (2,"Luciana","Gime

CREATE TABLE Libros( id_libros int primary key, titulo varchar (100), autor varchar (100), genero varchar (50), anio int); insert into Libros (id_libros, titulo, autor, genero, anio) values (1, "El Principito", "Antoine de Saint

CREATE TABLE IF NOT EXISTS accounts ( id INT PRIMARY KEY, owner VARCHAR(30), balance DECIMAL(10,2), CONSTRAINT chk_balance CHECK (balance >= 0) ) ENGINE=InnoDB; INSERT INTO accounts (id, owner, balance) VALUES (1, 'Alice', 1000.00),

-- create table dept -- CREATE TABLE Dept ( NumD INT PRIMARY KEY NOT NULL, NomD VARCHAR(30), Lieu VARCHAR(30) ); -- create table Emp -- CREATE TABLE Emp (

#include<iostream> using namespace std; int main(){

-- Create the Books table CREATE TABLE Books ( ISBN VARCHAR(20) PRIMARY KEY, Title VARCHAR(150) NOT NULL, Author VARCHAR(100) NOT NULL, Genre VARCHAR(60), Quantity INT NOT NULL CHECK (Quantity >= 0) ); -- Create the Members tabl

-- 1. Crear los usuarios CREATE USER 'harry'@'%' IDENTIFIED BY 'potter123'; CREATE USER 'hermoinie'@'%' IDENTIFIED BY 'granger456'; CREATE USER 'ronald'@'%' IDENTIFIED BY 'weasly789'; CREATE USER 'sirius'@'%' IDENTIFIED BY 'black987'; CREATE USER 't

CREATE TABLE Productos ( Producto_ID INTEGER PRIMARY KEY, Nombre TEXT, Categoria TEXT, Precio DECIMAL(10,2), Stock INTEGER ); INSERT INTO Productos VALUES (1, 'Lápiz', 'Escritura', 8, 40); INSERT INTO Productos VALUES (2, 'Borra

import matplotlib.pyplot as plt import numpy as np # 1. Definizione dei dati aggiornati (Valori in Mld Smc) # L'anno 2025 fa riferimento alle stime consolidate di chiusura years = ['2023', '2024', '2025*'] gasdotti = np.array([45.1, 44.4, 40.4]) gn

-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M'); INSERT INTO students VALUES (2, 'Joanna', 'F'); insert into stude

-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M'); INSERT INTO students VALUES (2, 'Joanna', 'F'); -- fetch some val

-- ===================================================================== -- EXERCICE 2 - Faire évoluer une structure (cabinet médical) -- ===================================================================== CREATE TABLE Patient ( id_patient

# Création de la table robots CREATE TABLE robots (nom VARCHAR(6) PRIMARY KEY, labo VARCHAR(6), pays VARCHAR(8), cat INT) ; # Création de la table inscriptions

CREATE TABLE Patient ( id_patient INT PRIMARY KEY, nom VARCHAR(30) NOT NULL, prenom VARCHAR(30) NOT NULL, date_naissance DATE ); INSERT INTO Patient (id_patient, nom, prenom, date_naissance) VAL

CREATE TABLE Etudiant ( ld_etudiant INT PRIMARY KEY, nom VARCHAR (50 ) NOT NULL, prenom VARCHAR (50) NOT NULL, moyenne DECIMAL (4,2) CHECK moyenne BETWEEN 0 AND 20) ); INSERT INFO Etudiant(id_etudiant, nom, prenom, moyenne) VALUES (90, 'LAMBERT',

PRAGMA foreign_keys = ON; DROP TABLE IF EXISTS sales; DROP TABLE IF EXISTS categories; CREATE TABLE categories ( category TEXT PRIMARY KEY NOT NULL ); CREATE TABLE sales ( sale_id INTEGER PRIMARY KEY, category TEXT NOT NULL REFERENCES catego

CREATE TABLE Students ( student_id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, grade VARCHAR(10) NOT NULL ); CREATE TABLE Subjects ( subject_id INT AUTO_INCREMENT PRIMARY KEY,

-- ========== DDL: CREATE ========== CREATE TABLE Donor ( donor_id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(50) NOT NULL, email VARCHAR(60) UNIQUE NOT NULL, city VARCHAR(30), donor_type VARCHAR(15) NOT NULL, CHECK (don