create table M_VENDEDORES (
ID_VENDEDOR number (10,0) not null,
NOME varchar2 (100) not null,
CPF number (11,0) not null,
ENDERECO varchar2 (100) not null,
NUMERO varchar2 (10) not null,
CEP number (11,0) not null,
constraint PK_VENDEDOR PRIMARY KEY (ID_VENDEDOR),
constraint UK_CPF unique (CPF)
);

create table M_VENDAS (
ID_VENDEDOR number (10,0) not null,
MES varchar2 (100) not null,
VENDAS number (10) not null,
constraint FK_ID_VENDEDORES foreign key (ID_VENDEDOR)
references M_VENDEDORES (ID_VENDEDOR)
);

create table M_FORNECEDORES (
ID_FORNECEDOR number (10,0) not null,
NOME varchar2 (100) not null,
CNPJ number (14) not null,
constraint PK_FORNECEDOR PRIMARY KEY (ID_FORNECEDOR)
);

create table M_ESTOQUE (
ID_FORNECEDOR number (10,0) not null,
ID_ITEM number (10,0) not null,
NOME varchar2 (100) not null,
MODELO varchar2 (100) not null,
TAMANHO varchar2 (10) not null,
MARCA varchar2 (100) not null,
ESTOQUE number (100) not null,
constraint PK_ITEM PRIMARY KEY (ID_ITEM),
constraint FK_ID_FORNECEDOR foreign key (ID_FORNECEDOR)
references M_FORNECEDORES (ID_FORNECEDOR)
);