Banco de Dados - Clinica

create database db_clinica;

use db_clinica;

create table tb_medico (

CRM int not null,

Nome_med varchar(30),

primary key (CRM));

insert tb_medico values

(101010, "Diego"),

(101011, "Diogo"),

(101012, "José Maria"),

(101013, "Mariena");

create table tb_paciente (

ID int auto_increment not null,

Nome_pac varchar(30),

endereço varchar(50),

primary key(ID));

insert tb_paciente values

(null, "Ana Dora", "Rua A"),

(null, "Ana Maria", "Rua B"),

(null, "Ana Virginia", "Rua C"),

(null, "Francisco", "Rua D"),

(null, "Jessica", "Rua E"),

(null, "Thalisson", "Rua F");

create table tb_consulta (

CRM int not null,

ID int not null,

Data_cons date,

foreign key (CRM) references tb_medico (CRM),

foreign key (ID) references tb_paciente (ID));

insert tb_consulta values

(101013, 2, "2018-06-10"),

(101013, 1, "2018-06-10"),

(101011, 3, "2018-06-11"),

(101012, 4, "2018-06-12"),

(101012, 5, "2018-06-13"),

(101012, 6, "2018-06-14");

create table tb_exame (

Cod_exame int not null auto_increment,

descrição varchar (80),

primary key (Cod_exame));

insert tb_exame values

(null, "Raio-x"),

(null, "Densitometria Óssea"),

(null, "Urina"),

(null, "Sangue");

create table tb_solicita (

CRM int not null,

ID int not null,

Cod_exame int not null,