· 7 years ago · Feb 14, 2019, 09:46 PM
1DROP DATABASE IF EXISTS empresa;
2CREATE DATABASE empresa;
3USE empresa;
4
5-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
6--
7-- Host: localhost Database: empresa
8-- ------------------------------------------------------
9-- Server version 5.7.21
10
11/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
12/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
13/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
14/*!40101 SET NAMES utf8 */;
15/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
16/*!40103 SET TIME_ZONE='+00:00' */;
17/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22--
23-- Table structure for table `departamento`
24--
25
26DROP TABLE IF EXISTS `departamento`;
27/*!40101 SET @saved_cs_client = @@character_set_client */;
28/*!40101 SET character_set_client = utf8 */;
29CREATE TABLE `departamento` (
30 `id_departamento` smallint(5) unsigned NOT NULL,
31 `nome` varchar(30) NOT NULL,
32 `id_funcionario_gerente` mediumint(8) unsigned NOT NULL,
33 PRIMARY KEY (`id_departamento`),
34 KEY `fk_departamento_gerente_idx` (`id_funcionario_gerente`),
35 CONSTRAINT `fk_departamento_gerente` FOREIGN KEY (`id_funcionario_gerente`) REFERENCES `funcionario` (`id_funcionario`) ON UPDATE CASCADE
36) ENGINE=InnoDB DEFAULT CHARSET=utf8;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `departamento`
41--
42
43LOCK TABLES `departamento` WRITE;
44/*!40000 ALTER TABLE `departamento` DISABLE KEYS */;
45INSERT INTO `departamento` VALUES (1,'Recursos Humanos',2),(2,'Produção',59),(3,'Contabilidade',77),(4,'Administrativo',98),(5,'Diretoria',27);
46/*!40000 ALTER TABLE `departamento` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `funcionario`
51--
52
53DROP TABLE IF EXISTS `funcionario`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `funcionario` (
57 `id_funcionario` mediumint(8) unsigned NOT NULL,
58 `cpf` char(11) NOT NULL,
59 `nome` varchar(30) NOT NULL,
60 `nome_meio` varchar(30) DEFAULT NULL,
61 `sobrenome` varchar(30) NOT NULL,
62 `data_nascimento` date NOT NULL,
63 `salario` decimal(11,2) NOT NULL,
64 `id_funcionario_supervisor` mediumint(8) unsigned NOT NULL,
65 `id_departamento` smallint(5) unsigned NOT NULL,
66 PRIMARY KEY (`id_funcionario`),
67 KEY `fk_funcionario_departamento_idx` (`id_departamento`),
68 KEY `fk_funcionario_supervisor_idx` (`id_funcionario_supervisor`),
69 CONSTRAINT `fk_funcionario_departamento` FOREIGN KEY (`id_departamento`) REFERENCES `departamento` (`id_departamento`) ON UPDATE CASCADE,
70 CONSTRAINT `fk_funcionario_supervisor` FOREIGN KEY (`id_funcionario_supervisor`) REFERENCES `funcionario` (`id_funcionario`) ON UPDATE CASCADE
71) ENGINE=InnoDB DEFAULT CHARSET=utf8;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Dumping data for table `funcionario`
76--
77
78LOCK TABLES `funcionario` WRITE;
79/*!40000 ALTER TABLE `funcionario` DISABLE KEYS */;
80INSERT INTO `funcionario` VALUES (1,'65335394524','Sylvester','Travis','Peck','1956-11-07',3398.52,6,1),(2,'77880579233','Guinevere','Blanchard','Munoz','1964-12-28',3849.30,6,2),(3,'50800260818','Coby','Williamson','Stanton','1980-12-22',2867.97,7,5),(4,'25551522109','Russell','Sherman','Mcneil','1974-02-24',6511.72,6,1),(5,'34359127945','Patrick',NULL,'Bush','1964-09-27',6366.05,6,4),(6,'81776262943','Orson','Callahan','Juarez','1970-12-22',1782.55,7,1),(7,'14094209795','Xena','Michael','Robertson','1978-10-12',7810.99,5,1),(8,'27822242718','Gregory','Washington','Rivers','1986-03-11',4911.20,5,3),(9,'56749003835','Vanna','Alexander','Atkins','1971-05-23',6007.22,8,4),(10,'39583033861','Gareth',NULL,'Decker','1994-09-04',4306.04,5,3),(11,'22495394489','Freya','Barber','Hines','1980-10-07',2896.53,6,5),(12,'17725025075','Rhonda','Cotton','Figueroa','1958-11-28',5489.73,7,5),(13,'34879868808','Hanae','Roberts','Barrett','1988-12-10',5614.08,6,4),(14,'33350366809','Linda','Harrell','Flynn','1968-10-17',7652.30,6,3),(15,'15400324223','Sara',NULL,'George','1993-02-15',2950.15,5,4),(16,'52121632835','Shana','Roberson','Giles','1989-12-04',6873.66,5,3),(17,'63123841997','Orlando','Drake','Serrano','1956-08-25',2317.61,8,3),(18,'60326998101','Nita',NULL,'Ramirez','1971-02-01',1842.88,6,3),(19,'69475170100','Daquan','Ferrell','Bartlett','1963-02-03',8131.12,7,2),(20,'24781368507','Kimberley','Grant','Martinez','1980-02-26',7807.92,8,4),(21,'15314126842','Bert','Carter','Figueroa','1959-09-13',8203.26,5,2),(22,'79870282817','Dara','Larson','Kent','1959-08-05',5714.94,7,3),(23,'57047070066','Madonna','Dorsey','Kirby','1992-08-23',6148.28,8,4),(24,'73265158550','Cailin','Cantu','Wilder','1988-05-15',3330.24,6,5),(25,'17773469868','Catherine',NULL,'Mitchell','1963-08-26',2531.27,8,5),(26,'66462995939','Grant','Frye','Hall','1983-10-30',2351.86,8,1),(27,'11288151889','Tate','Ball','Wright','1980-02-11',3377.28,7,5),(28,'94565092730','Vaughan',NULL,'Harrell','1957-05-20',1983.26,8,3),(29,'40180395046','Wesley','Curtis','Blackwell','1958-07-03',8213.98,7,1),(30,'65865022482','Lacy','Fields','Casey','1998-10-18',8957.85,5,5),(31,'78400981302','Kimberly',NULL,'Mccoy','1980-08-13',3619.56,5,5),(32,'88611730395','Blake','Hyde','Fleming','1962-11-22',1955.95,5,4),(33,'69686038502','Flynn','Randall','Cantu','1979-12-21',4142.14,7,4),(34,'35437071613','Mona','Soto','Bender','1974-03-27',8362.30,6,1),(35,'22157674655','Blake',NULL,'Hurley','1977-08-19',5875.81,6,4),(36,'38144548899','Melanie',NULL,'Key','1995-07-15',6398.07,8,4),(37,'69301471321','Chancellor','Mason','Jacobson','1991-09-25',2552.08,6,3),(38,'84887647504','Alexander','Frank','Bruce','1974-12-07',4574.27,7,3),(39,'14407116919','Yael','Patrick','Jacobs','1971-03-27',8916.77,6,4),(40,'52861950670','Tarik',NULL,'Shaw','1976-04-03',4772.93,7,3),(41,'45114192904','Martena','Johnson','Barker','1962-04-22',7840.26,8,5),(42,'92169083365','Lacota','Deleon','Armstrong','1970-02-16',6936.43,7,2),(43,'32595614178','Pearl','Lambert','Townsend','1992-06-20',2363.54,6,3),(44,'39574075531','Oscar','Pugh','Buchanan','1986-04-14',3305.02,6,1),(45,'52637711953','Eden','Orr','Crawford','1990-06-20',5208.05,8,1),(46,'27736913122','Chantale','Shepherd','Reeves','1971-03-14',1875.63,5,2),(47,'30689114456','Silas','Vincent','Meyers','1962-02-22',4258.85,8,1),(48,'89100441626','Bruno','Cervantes','Holloway','1962-12-29',3831.67,7,4),(49,'21633789150','Bradley','Blake','Strong','1964-05-09',3118.05,6,1),(50,'97135124355','Cadman','Burris','Hays','1970-05-02',5269.51,7,4),(51,'76468805844','Leslie','Lindsey','Head','1963-05-03',3627.20,5,3),(52,'93391985239','Cara','Dominguez','Beck','1965-03-18',2282.22,7,3),(53,'33746588768','Jacqueline','Espinoza','Valentine','1957-12-06',3894.90,6,3),(54,'70532233847','Paul','Meyer','Bender','1971-12-31',7094.89,6,4),(55,'47849755775','Kasimir','Camacho','Horne','1997-05-12',8004.67,7,4),(56,'44589842276','Cairo','Castro','Whitley','1994-09-19',8119.34,8,3),(57,'81350716162','Walter','Mcgowan','Holman','1983-11-27',6488.60,6,1),(58,'82895011496','Lee','Norris','Powell','1981-07-18',6850.66,5,1),(59,'90534366087','Helen','Hubbard','Hoover','1983-04-22',7492.88,5,3),(60,'52706005258','Leila','Vazquez','Maxwell','1960-05-21',3841.46,6,3),(61,'38304621726','Dominic','Barr','Holder','1981-06-23',3185.96,5,1),(62,'75082076837','Avye','Burke','Johnson','1983-01-20',8247.50,8,3),(63,'39225787752','Ciaran','Lawson','Fletcher','1964-12-02',1605.95,8,3),(64,'86869399994','Asher','Foreman','Schmidt','1972-03-05',2805.27,5,2),(65,'30538723576','Bryar','Leblanc','Harrison','1994-06-23',3745.37,5,5),(66,'24510394698','Conan','Compton','Mitchell','1982-09-30',5921.64,8,1),(67,'76836771228','Hyatt','Deleon','Prince','1999-09-17',8934.85,6,1),(68,'39604396000','Quail','Blackwell','Mills','1998-05-29',3648.99,6,5),(69,'32652136435','Blythe','Dalton','Nelson','1995-01-26',7891.18,8,2),(70,'92932801983','Leilani','Savage','Spears','1980-07-28',1566.29,5,4),(71,'20787340029','Sybill','Lindsey','Mack','1973-09-14',5580.97,7,4),(72,'97017145529','Kalia','Everett','Stanton','1957-01-07',4116.52,5,2),(73,'46909266834','Daniel','Roach','Snider','1983-03-12',6340.83,7,1),(74,'87031642057','Lucas','Brown','Cochran','1986-03-03',7410.83,7,4),(75,'42645907940','Brennan','Rosa','Morgan','1969-11-03',4806.31,7,3),(76,'11810103927','Alec','Harvey','Wiggins','1999-08-26',2598.03,5,5),(77,'45860463794','Sandra','Moreno','Simpson','1961-04-24',4239.63,8,1),(78,'14760951490','Sybill','Woodard','Dixon','1986-10-07',1611.56,7,1),(79,'36944726150','Lionel','Reilly','Jacobson','1970-01-17',6829.80,5,4),(80,'98135849171','Joel','Russo','Mcintyre','1991-04-01',7360.40,7,5),(81,'83375072189','Kenneth','Evans','Wade','1965-09-11',7522.97,6,4),(82,'65070266649','Lacy','Hurst','Mcclure','1974-03-21',6038.89,5,3),(83,'17162225022','Odessa','Ramsey','Walton','1975-04-05',2432.13,7,2),(84,'32414611594','Kimberly','Holt','Soto','1968-05-06',5386.54,5,1),(85,'78052360564','Ivy','Rivas','Pruitt','1984-06-02',6884.13,6,4),(86,'54278435392','Travis','Strickland','Nash','1957-06-08',5796.50,5,4),(87,'67775820402','Hilel','Talley','Velasquez','1967-09-29',5750.61,5,1),(88,'23063413177','Shafira','Herman','Reynolds','1974-01-22',2247.60,8,2),(89,'37582961014','Hope','West','Ratliff','1980-03-29',3150.16,8,4),(90,'40617213191','Keane','Hopkins','Glass','1968-06-06',6212.59,7,3),(91,'47509760243','Drake','Stuart','Franklin','1972-09-08',2321.69,5,4),(92,'62448455310','Charles','Bartlett','Cash','1974-08-02',4676.12,7,2),(93,'84431926450','Reece','Castro','Wilson','1976-06-25',6759.90,6,1),(94,'50278183817','Basil','Mullins','Freeman','1989-10-13',8862.78,6,3),(95,'93531990754','Sybil','Mitchell','Solis','1982-07-26',5611.65,7,2),(96,'95242361020','Amanda','York','Kidd','1964-07-21',6909.60,7,4),(97,'89727666187','Darius','Sutton','Solis','1962-11-12',8404.64,6,5),(98,'93679911767','Maxwell','Cameron','Gonzalez','1982-05-26',3474.94,8,2),(99,'53611981620','Jesse','Richards','Macdonald','1998-05-28',8504.54,7,3),(100,'87758520949','Kelly','Reilly','Mays','1992-05-22',5096.60,5,3);
81/*!40000 ALTER TABLE `funcionario` ENABLE KEYS */;
82UNLOCK TABLES;
83
84--
85-- Table structure for table `projeto`
86--
87
88DROP TABLE IF EXISTS `projeto`;
89/*!40101 SET @saved_cs_client = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `projeto` (
92 `id_projeto` mediumint(8) unsigned NOT NULL,
93 `nome` varchar(30) NOT NULL,
94 `id_departamento` smallint(5) unsigned NOT NULL,
95 PRIMARY KEY (`id_projeto`),
96 KEY `fk_projeto_departamento_idx` (`id_departamento`),
97 CONSTRAINT `fk_projeto_departamento` FOREIGN KEY (`id_departamento`) REFERENCES `departamento` (`id_departamento`) ON UPDATE CASCADE
98) ENGINE=InnoDB DEFAULT CHARSET=utf8;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `projeto`
103--
104
105LOCK TABLES `projeto` WRITE;
106/*!40000 ALTER TABLE `projeto` DISABLE KEYS */;
107INSERT INTO `projeto` VALUES (1,'Eckville',3),(2,'Fraser-Fort George',2),(3,'Casacalenda',3),(4,'Luttre',3),(5,'Marsciano',3),(6,'Bhiwani',5),(7,'Bregenz',1),(8,'Hulst',5),(9,'Jamioulx',3),(10,'Carluke',3),(11,'Ortacesus',5),(12,'Shaftesbury',3),(13,'Dublin',1),(14,'Combarbalá',3),(15,'Zwijndrecht',4),(16,'Jaipur',1),(17,'San Gregorio nelle Alpi',1),(18,'Folkestone',3),(19,'Kilsyth',3),(20,'San Lazzaro di Savena',1),(21,'Retiro',5),(22,'Nanton',2),(23,'Coltauco',1),(24,'Kirkintilloch',1),(25,'Frankston',1);
108/*!40000 ALTER TABLE `projeto` ENABLE KEYS */;
109UNLOCK TABLES;
110
111--
112-- Table structure for table `projeto_funcionario`
113--
114
115DROP TABLE IF EXISTS `projeto_funcionario`;
116/*!40101 SET @saved_cs_client = @@character_set_client */;
117/*!40101 SET character_set_client = utf8 */;
118CREATE TABLE `projeto_funcionario` (
119 `id_projeto` mediumint(8) unsigned NOT NULL,
120 `id_funcionario` mediumint(8) unsigned NOT NULL,
121 `horas` decimal(7,2) unsigned NOT NULL,
122 PRIMARY KEY (`id_projeto`,`id_funcionario`),
123 KEY `fk_projeto_funcionario_funcionario_idx` (`id_funcionario`),
124 KEY `fk_projeto_funcionario_projeto_idx` (`id_projeto`),
125 CONSTRAINT `fk_projeto_funcionario_funcionario` FOREIGN KEY (`id_funcionario`) REFERENCES `funcionario` (`id_funcionario`) ON UPDATE CASCADE,
126 CONSTRAINT `fk_projeto_funcionario_projeto` FOREIGN KEY (`id_projeto`) REFERENCES `projeto` (`id_projeto`) ON UPDATE CASCADE
127) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `projeto_funcionario`
132--
133
134LOCK TABLES `projeto_funcionario` WRITE;
135/*!40000 ALTER TABLE `projeto_funcionario` DISABLE KEYS */;
136INSERT INTO `projeto_funcionario` VALUES (1,6,8.58),(1,47,4.35),(1,62,9.89),(1,99,4.45),(1,100,2.92),(2,15,8.71),(2,17,11.17),(2,55,1.76),(2,91,15.48),(3,1,16.10),(3,29,2.39),(3,43,15.65),(3,45,11.85),(3,51,18.06),(3,54,5.04),(3,76,8.95),(4,3,17.50),(4,9,17.16),(4,10,10.67),(4,25,4.24),(4,26,2.79),(4,27,14.38),(4,51,4.41),(4,53,10.32),(4,57,13.16),(4,63,17.27),(4,93,0.36),(4,96,13.54),(5,65,7.82),(5,70,9.87),(5,74,0.77),(5,83,10.52),(5,94,8.41),(5,100,16.22),(6,54,2.32),(6,56,11.28),(6,90,4.32),(7,8,12.21),(7,32,9.84),(7,84,9.51),(7,86,8.32),(8,3,16.42),(8,11,15.83),(8,22,2.12),(8,43,14.84),(8,62,12.18),(8,90,6.14),(8,94,10.54),(8,99,3.55),(9,35,7.41),(9,94,11.45),(9,98,2.38),(10,79,10.19),(10,85,2.15),(10,92,15.55),(10,94,16.23),(11,5,16.40),(11,12,19.74),(11,21,10.24),(11,28,5.00),(11,51,13.45),(11,53,5.01),(11,89,0.32),(12,18,18.66),(12,25,3.69),(12,65,5.56),(13,38,12.02),(13,40,2.81),(13,68,8.53),(13,79,14.26),(13,80,14.35),(14,6,11.13),(14,11,5.31),(14,19,8.14),(14,31,14.15),(14,45,17.90),(14,70,13.45),(14,84,12.06),(14,92,8.27),(14,95,11.87),(15,2,10.58),(15,3,5.12),(15,10,5.41),(15,13,18.86),(15,30,19.04),(15,80,14.88),(15,81,3.77),(15,93,17.19),(15,96,16.77),(16,9,7.31),(16,73,15.27),(16,83,19.81),(16,86,6.10),(16,89,15.90),(16,91,15.65),(16,94,6.21),(16,96,4.48),(17,10,8.69),(17,33,18.07),(17,49,10.45),(17,52,14.94),(17,59,12.53),(17,74,3.47),(17,92,17.05),(18,26,4.65),(18,29,6.12),(18,65,19.15),(18,76,18.66),(18,91,5.85),(18,95,9.42),(20,11,12.11),(20,56,15.25),(20,84,3.56),(20,87,17.64),(21,5,18.28),(21,17,2.33),(21,29,1.02),(21,31,1.32),(21,38,8.24),(21,40,19.34),(21,41,18.72),(21,42,19.29),(21,53,11.89),(22,15,9.60),(22,19,6.32),(22,25,7.24),(23,6,9.00),(23,13,5.57),(23,25,6.43),(23,39,7.08),(23,40,17.88),(23,44,10.98),(23,76,14.82),(23,78,5.33),(23,82,19.83),(23,83,3.47),(23,99,17.88),(24,34,1.80),(24,35,15.00),(24,48,12.82),(24,61,3.90),(24,62,9.67),(24,79,17.45),(24,81,9.40),(24,83,12.71),(24,100,18.04),(25,34,18.65),(25,47,11.55),(25,55,1.85),(25,92,8.05);
137/*!40000 ALTER TABLE `projeto_funcionario` ENABLE KEYS */;
138UNLOCK TABLES;
139/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
140
141/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
142/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
143/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
144/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
145/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
146/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
147/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
148
149-- Dump completed on 2018-03-21 11:03:35
150
151
152-- QUESTÃO 1 --
153DROP TABLE IF EXISTS pessoa;
154
155CREATE TABLE pessoa( id_pessoa MEDIUMINT(8) UNSIGNED NOT NULL PRIMARY KEY,
156cpf CHAR(11) NOT NULL, nome VARCHAR(30), nome_meio VARCHAR(30),
157sobrenome VARCHAR(30), data_nascimento DATE)
158
159SELECT * FROM pessoa;
160
161-- QUESTÃO 2 --
162
163INSERT INTO pessoa (id_pessoa, cpf, nome, nome_meio, sobrenome, data_nascimento)
164SELECT id_funcionario, cpf, nome, nome_meio, sobrenome, data_nascimento FROM funcionario;
165
166-- QUESTÃO 3 --
167
168ALTER TABLE funcionario
169drop column cpf;
170ALTER TABLE funcionario
171drop column nome;
172ALTER TABLE funcionario
173drop column nome_meio;
174ALTER TABLE funcionario
175drop column sobrenome;
176ALTER TABLE funcionario
177drop column data_nascimento;
178
179SELECT * FROM funcionario;
180
181-- QUESTÃO 4 --
182
183ALTER TABLE funcionario
184ADD CONSTRAINT fk_funcionario_pessoa
185FOREIGN KEY (id_funcionario)
186REFERENCES pessoa (id_pessoa);
187
188-- QUESTÃO 5 --
189
190DROP TABLE IF EXISTS cliente;
191CREATE TABLE cliente( id_cliente MEDIUMINT(8) NOT NULL PRIMARY KEY,
192data_hora_cadastro DATETIME,
193FOREIGN KEY (id_cliente)
194REFERENCES pessoa (id_pessoa));
195
196SELECT * FROM cliente;
197
198-- QUESTÃO 6 --
199
200-- FUNCIONA
201
202
203-- EXERCÃCIO 2 --
204
205ALTER TABLE departamento RENAME TO setor;
206
207-- EXERCÃCIO 3 --
208
209ALTER TABLE cliente
210ADD COLUMN ativo BIT NOT NULL AFTER data_hora_cadastro;
211
212-- EXERCÃCIO 4 --
213
214ALTER TABLE pessoa
215ADD COLUMN sexo enum('F', 'M') AFTER data_nascimento;
216
217-- EXERCÃCIO 5 --
218
219-- Change:
220
221-- Pode ser utilizado para renomear uma coluna e alterar suas definições,
222-- como o tipo de dados de uma coluna.
223
224-- Modify:
225
226-- Pode ser utilizado para alterar as definições de uma coluna, mas não o seu nome.
227
228
229-- EXERCÃCIO 6 --
230
231ALTER TABLE pessoa
232MODIFY COLUMN nome VARCHAR(45);
233
234-- EXERCÃCIO 7 --
235
236ALTER TABLE funcionario
237MODIFY COLUMN salario DECIMAL(11,2);
238
239-- EXERCÃCIO 8 --
240
241ALTER TABLE projeto
242CHANGE COLUMN id_departamento id_setor SMALLINT;
243ALTER TABLE setor
244CHANGE COLUMN id_departamento id_setor SMALLINT;
245
246-- EXERCÃCIO 9 --
247
248ALTER TABLE setor
249DROP COLUMN id_funcionario_gerente;
250
251-- EXERCÃCIO 10 --
252
253ALTER TABLE pessoa
254MODIFY COLUMN cpf VARCHAR(11) PRIMARY KEY;