@cmalanda

-- Tabla DEPARTAMENTO CREATE TABLE DEPARTAMENTO ( id_Depto INT PRIMARY KEY, Nombre_Depto VARCHAR(50) NOT NULL ); -- Tabla EMPLEADO CREATE TABLE EMPLEADO ( id_Empleado INT PRIMARY KEY, Nombre VARCHAR(50) NOT NULL,

# 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

#include <stdio.h> int main() { printf("Hello world!\n"); return 0; }

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

/*Autore: Cognome Nome*/ .header on .mode column -- CREAZIONE TABELLE CREATE TABLE aziende ( cod_azienda INTEGER PRIMARY KEY, denominazione TEXT NOT NULL, -- max 20 indirizzo TEXT, -- max 30

-- TEAM NAME (GROUP 1) -- MEMBERS: -- Dizon, Harry Leonerr T. -- Punzalan, Gian Kirby N. -- Salazar, Frederick Jr. E. SELECT '============================================'; SELECT '================ TEAM REPORTS =============='; SELECT '===========

-- create a table CREATE TABLE cliente ( documento INTEGER PRIMARY KEY, nombre varchar(50) NOT NULL, localidad varchar(100) NOT NULL ); CREATE TABLE producto ( codigo INTEGER PRIMARY KEY, descripcion varchar(50),

-- 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 Fabricantes ( code INTEGER PRIMARY KEY, name TEXT NOT NULL, price TEXT NOT NULL ); -- create a table CREATE TABLE Articulos ( code INTEGER PRIMARY KEY,

--create a table CREATE TABLE Fabricantes ( code INTEGER PRIMARY KEY, name TEXT NOT NULL, price TEXT NOT NULL ); -- create a table CREATE TABLE Articulos ( code INTEGER PRIMARY KEY,

-- create a table CREATE TABLE producto ( id integer PRIMARY KEY, nombre varchar(50) NOT NULL, marca varchar(50) NOT NULL, precio numeric(10,2) NOT NULL, stock integer NOT NULL, categoria varchar(50), fechaIn date );

-- 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

-- 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

-- 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

-- create a table CREATE TABLE estudiantes ( est_idEstudiante INTEGER PRIMARY KEY, est_Nombre TEXT NOT NULL, est_Apellido TEXT NOT NULL, est_genero TEXT NOT NULL ); -- insert some values insert into estudiantes values (1,'Noura','vendeuse',

Create table employee (fname varchar(10), minit char, lname varchar(10), ssn int, bdate char(10), address varchar(25), sex char, salary float, superssn int, dno int); insert into employee values ('John', 'B', 'Smith', 123456789, '1965-01-09', '731

#include <stdio.h> int main(void) { int c; while ((c= getchar ()) !='#') { printf("hgfjkdls") }

#include <stdio.h> #include <string.h> #define MAX_PROC 10 //最多模拟10个进程，可按需改大 //进程状态枚举 typedef enum { READY, RUNNING, FINISHED

CREATE TABLE cliente ( NUMcli INT not null, NOMcli char(30)not null, DIRcli char(30), Email char(30) DEFAULT('desconocido'), saldo_30 decimal (10,2), saldo_tot decimal (10,2), PRIMARY KEY (NUMcli)

--exo1 quest1-- CREATE TABLE Adherent ( id_adherent VARCHAR (30) PRIMARY KEY, nom VARCHAR(30), prenom VARCHAR (30), email VARCHAR (30) NOT NULL UNIQUE, date_inscription DATE ); --exo1 quest2--