taller software

use master
go
create database apurimacc
on primary(
name='apurimacc_data',
filename='D:\sql\apurimacc_data.Mdf',
size=4Mb,
maxsize=10Mb,
filegrowth=1Mb
)


log on(name='apurimacc_log',
filename='D:\sql\apurimacc_data.Ldf',
size=8Mb,
maxsize=9Mb,
filegrowth=2Mb
)
go
--creando tablas
use apurimacc
go
create table cilentes(
nomcl char (3) not null,
domcli varchar (30)null,
dnicli varchar (30) null
)
use apurimacc
go
create table compras(
nomcom char (3) not null,
coscom varchar (30) null,
valocom varchar (30) null
)
use apurimacc
go
create tableproducto(
nompro char(3)not null,
precpro varchar (30) null,
marpro varchar (30) null
)
use apurimacc
go
create table codigo(
codcli char (3) not null,
numcod varchar (30) null,
segcod varchar(30) null
)




Algunas cosas mas importantes
use master
go
create database antabambaperu
on primary(
name='antabambaperu_data',
filename='D:\sql\antabambaperu_data.Mdf',
size=3Mb,maxsize=6Mb,
filegrowth=1Mb
)
log on(
name='antabambaperu_log',
filename='D:\sql\antabambaperu_data.Ldf',
size=4Mb,
maxsize=8Mb,
filegrowth=2Mb
)
go

use antabambaperu
go
create tabletipocliente(
tpocienteID char (3) not null,
ingre_descrip varchar (30)null
)
use antabambaperu
go
create table clientes(
clienteID char (3) not null,
clien_descrip varchar (30)null
)
useantabambaperu
go
create table facturas(
facturaID char (3) not null,
fechaImport varchar (30)null
)
use antabambaperu
go
create table Items(
productoID char (3) not null,
cantidadprecio varchar (30)null)
use antabambaperu
go
create table productos(
produc_descrip varchar (30)null,
)
use antabambaperu
go
create table tipoproducto(
tipoproductoID char (3)not null,
produc_fami_descripvarchar (30)null
)

use antabambaperu
go
create table calculo(
codigo int not null,
descripcion varchar (10) null,
pre_unitario decimal (9)not null,
cantidad smallint not null,
total as...