Tablas y Queries de Company

Tablas y Queries de Company - Sheet1 Page 1 /* Parte 1:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sheet1 Page 1 /* Parte 1: Creacin de tablas Employee y Department con insercin de 3 registros */ create table employee (fname varchar(30) not null, minit char (1) not null, lname varchar(30) not null, ssn char(9) not null, bda create table department(dname varchar(30) not null, dnumber int not null, mgrssn char(9) not null, mgrstartdate datetime not n insert into department(dname, dnumber, mgrssn, mgrstartdate) values('Computer Science', 01, 9034, 23-07-2008) insert into department(dname, dnumber, mgrssn, mgrstartdate) values('Human Resources', 02, 4943, 19-06-2009) insert into department(dname, dnumber, mgrssn, mgrstartdate) values('Electronic Engineers', 03, 03, 30-01-2009) insert into employee (fname, minit, lname, ssn, bdate, eaddress, sex, salary, superssn, dno) insert into employee (fname, minit, lname, ssn, bdate, eaddress, sex, salary, superssn, dno ) insert into employee (fname, minit, lname, ssn, bdate, eaddress, sex, salary, superssn, dno ) values ('Ricardo', 'Mauricio', 'Viteri Buendia', 798362, 23-05-1987, 'Negrete 15, Guayaquil, Ecuador', 'M', 40000, 79836291827...
View Full Document

This note was uploaded on 10/29/2009 for the course TECNOLOGí TC1009 taught by Professor Lorenagonzález during the Spring '09 term at ITESM.

Page1 / 2

Tablas y Queries de Company - Sheet1 Page 1 /* Parte 1:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online