A Menina De La

Trabalho em grupo de 4 alunos visando fixação de conhecimento sobre JOIN e avaliação parcial da disciplina BADA.

Escreva as respostas abaixo de cada questão

Utilizando o SQL Server, construa o seguinte banco de dados e insira os registros nas tabelas, conforme Diagrama abaixo:

create database bada

use bada

create table categoria(

id_cat int primary key,

descricao varchar(50)

)

create table automovel(

id_car int primary key,

placa varchar(7),

id_cat int constraint f_k_id_cat references categoria(id_cat)

)

Popule as tabelas utilizando a Query abaixo:

insert into categoria values(1, 'passeio')

insert into categoria values(2, 'onibus')

insert into categoria values(3, 'utilitário')

insert into categoria values(4, 'moto')

insert into categoria values(5, 'reboque')

insert into categoria values(6, 'tração')

insert into automovel values (1, 'sf90345', 2)

insert into automovel values (2, 'jgk9034', 1)

insert into automovel (id_car, placa) values (3, 'sjn8954')

insert into automovel values (4, 'ksm0980', 6)

insert into automovel values (5, 'ksm8902', 1)

insert into automovel values (6, 'kfn9034', 6)

insert into automovel (id_car, placa) values (7, 'osl0293')

insert into automovel values (8, 'jfn7584', 1)

insert into automovel values (9, 'ksm8956', 1)

insert into automovel values (10, 'oel9561', 6)

insert into automovel values (11, 'lsk8945', 5)

insert into automovel (id_car, placa) values (12, 'kfi0361')

insert into automovel (id_car, placa) values (13, 'kvu6730')

insert into automovel values (14, 'oks8567', 6)

insert into automovel values (15, 'qws3468', 6)

insert into automovel values (16, 'mfh8945', 1)

insert into automovel (id_car, placa) values (17, 'jfn6798')

insert into automovel values (18, 'kfi9205', 6)

insert into automovel values (19, 'odc1290', 1)

insert into automovel values (20, 'nvj8650', 2)

insert into automovel (id_car, placa) values (21, 'mfk8945')

insert into automovel values (22, 'fdt0945', 1)

insert into automovel values (23, 'mfg7640', 1)

insert into automovel values (24, 'mcd8945', 6)

insert into automovel values (25, 'urf8934', 1)

insert into automovel values (26, 'mjf0345', 1)

insert into automovel (id_car, placa) values (27, 'bng0456')

insert into automovel values (28, 'yrf7845', 2)

insert into automovel values (29, 'wer4562', 3)

insert into automovel values (30, 'njg0934', 1)

insert into automovel values (31, 'ler1056', 6)

insert into automovel (id_car, placa) values (32, 'kid4502')

insert into automovel values (33, 'mdf0845', 6)

insert into automovel values (34, 'mjf9841', 3)

insert into automovel (id_car, placa) values (35, 'ijr7230')

insert into automovel values (36, 'okf5632', 5)

insert into automovel values (37, 'lim9034', 5)

insert into automovel (id_car, placa) values (38, 'fju9034')

insert into automovel values (39, 'fjv9031', 2)

insert into automovel values (40, 'vbh2345', 6)

insert into automovel values (41, 'jfv7401', 3)

insert into automovel values (42, 'kde8934', 6)