{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Tablas y Queries de Company

Tablas y Queries de Company - Parte 1 Creacin de tablas...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 /* Parte 1: Creación de tablas Employee y Department con inserción 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 /* Parte 2: Queries hechos en clase */ /* 1. Ingreso total de ventas */
Background image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}