civera2

group:Recursos Humanos

regions = {
	region_id:number, region_name:string      
	1               , 'Europe'                
	2               , 'Americas'              
	3               , 'Asia'                  
	4               , 'Middle East and Africa'
}

civera2

group: Recursos_humanos
Dep = { Codd,Nom,Localidad
	10, 'Administration', 1700
	20, 'Marketing', 1800
	}

civera2

group: banco example
description[[ the data for this dataset was generated using <http://www.generatedata.com/>

* the relation _Customers_ contains basic information about the customers of the bank. 
* the relation _Accounts_ contains the basic information of a single account. Note that a customer can have any number of accounts.
* the relation _PremiumCustomers_ contains the customer-ids of all customers with a total balance over 1000
]]


Customers = { cid	firstname	lastname

civera2

group: HR
description[[ the data for this dataset was generated using <http://www.generatedata.com/>

* the relation _Customers_ contains basic information about the customers of the bank. 
* the relation _Accounts_ contains the basic information of a single account. Note that a customer can have any number of accounts.
* the relation _PremiumCustomers_ contains the customer-ids of all customers with a total balance over 1000
]]

CREATE TABLE regions (
	region_id INT (11) NOT NULL,

civera2

CREATE SCHEMA hr;

civera2

CREATE TABLE regions (
	region_id INT NOT NULL,
	region_name VARCHAR(25),
	PRIMARY KEY (region_id)
	);
INSERT INTO regions
VALUES (
	1,
	'Europe'
	);

civera2

CREATE TABLE regions (
	region_id INT NOT NULL,
	region_name VARCHAR(25),
	PRIMARY KEY (region_id)
	);
INSERT INTO regions
VALUES (
	1,
	'Europe'
	);