untitled1.sql

there is a data base

CREATE DATABASE Calculatoare
GO
USE Calculatoare
GO 
ALTER TABLE [dbo].[laptop_uri] DROP CONSTRAINT FK_laptop_uri_produse
GO

ALTER TABLE [dbo].[pc_uri] DROP CONSTRAINT FK_pc_uri_produse
GO

ALTER TABLE [dbo].[imprimante] DROP CONSTRAINT FK_imprimante_produse
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[laptop_uri]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[laptop_uri]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[pc_uri]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pc_uri]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[produse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[produse]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[imprimante]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[imprimante]
GO

CREATE TABLE [dbo].[laptop_uri] (
	[cod] [int] NOT NULL ,
	[model] [varchar] (4) NOT NULL ,
	[viteza] [decimal](3, 0) NOT NULL ,
	[ram] [decimal](3, 0) NOT NULL ,
	[hd] [decimal](2, 0) NOT NULL ,
	[pret] [float] NOT NULL ,
	[ecran] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pc_uri] (
	[cod] [int] NOT NULL ,
	[model] [varchar] (4) NOT NULL ,
	[viteza] [decimal](3, 0) NOT NULL ,
	[ram] [decimal](3, 0) NOT NULL ,
	[hd] [decimal](2, 0) NOT NULL ,
	[cd] [varchar] (3) NOT NULL ,
	[pret] [float] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[produse] (
	[producator] [char] (1) NOT NULL ,
	[model] [varchar] (4) NOT NULL ,
	[tip] [varchar] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[imprimante] (
	[cod] [int] NOT NULL ,
	[model] [varchar] (4) NOT NULL ,
	[color] [char] (2) NOT NULL ,
	[tip] [varchar] (6) NOT NULL ,
	[pret] [float] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[laptop_uri] WITH NOCHECK ADD 
	CONSTRAINT [PK_laptop_uri] PRIMARY KEY  NONCLUSTERED 
	(
		[cod]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[pc_uri] WITH NOCHECK ADD 
	CONSTRAINT [PK_pc_uri] PRIMARY KEY  NONCLUSTERED 
	(
		[cod]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[produse] WITH NOCHECK ADD 
	CONSTRAINT [PK_produse] PRIMARY KEY  NONCLUSTERED 
	(
		[model]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[imprimante] WITH NOCHECK ADD 
	CONSTRAINT [PK_imprimante] PRIMARY KEY  NONCLUSTERED 
	(
		[cod]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[laptop_uri] ADD 
	CONSTRAINT [FK_laptop_uri_produse] FOREIGN KEY 
	(
		[model]
	) REFERENCES [dbo].[produse] (
		[model]
	)
GO

ALTER TABLE [dbo].[pc_uri] ADD 
	CONSTRAINT [FK_pc_uri_produse] FOREIGN KEY 
	(
		[model]
	) REFERENCES [dbo].[produse] (
		[model]
	)
GO

ALTER TABLE [dbo].[imprimante] ADD 
	CONSTRAINT [FK_imprimante_produse] FOREIGN KEY 
	(
		[model]
	) REFERENCES [dbo].[produse] (
		[model]
	)
GO
----produse------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 
insert into produse values('B','1121','PC')
insert into produse values('A','1232','PC')
insert into produse values('A','1233','PC')
insert into produse values('E','1260','PC')
insert into produse values('A','1276','Imprimante')
insert into produse values('D','1288','Imprimante')
insert into produse values('A','1298','Laptop_uri')
insert into produse values('C','1321','Laptop_uri')
insert into produse values('A','1401','Imprimante')
insert into produse values('A','1408','Imprimante')
insert into produse values('D','1433','Imprimante')
insert into produse values('E','1434','Imprimante')
insert into produse values('B','1750','Laptop_uri')
insert into produse values('A','1752','Laptop_uri')
insert into produse values('E','2111','PC')
insert into produse values('E','2112','PC')
go

                                                                                                                                                                                                                                                                 
----pc_uri------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 
insert into pc_uri values(1,'1232',500,64,5,'12x',600)
insert into pc_uri values(2,'1121',750,128,14,'40x',850)
insert into pc_uri values(3,'1233',500,64,5,'12x',600)
insert into pc_uri values(4,'1121',600,128,14,'40x',850)
insert into pc_uri values(5,'1121',600,128,8,'40x',850)
insert into pc_uri values(6,'1233',750,128,20,'50x',950)
insert into pc_uri values(7,'1232',500,32,10,'12x',400)
insert into pc_uri values(8,'1232',450,64,8,'24x',350)
insert into pc_uri values(9,'1232',450,32,10,'24x',350)
insert into pc_uri values(10,'1260',500,32,10,'12x',350)
insert into pc_uri values(11,'1233',900,128,40,'40x',980)

go

                                                                                                                                                                                                                                                                 
----laptop_uri------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 
insert into laptop_uri values(1,'1298',350,32,4,700,11)
insert into laptop_uri values(2,'1321',500,64,8,970,12)
insert into laptop_uri values(3,'1750',750,128,12,1200,14)
insert into laptop_uri values(4,'1298',600,64,10,1050,15)
insert into laptop_uri values(5,'1752',750,128,10,1150,14)
insert into laptop_uri values(6,'1298',450,64,10,950,12)

go

                                                                                                                                                                                                                                                                 
----imprimante------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 
insert into imprimante values(1,'1276','nu','Laser',400)
insert into imprimante values(2,'1433','da','Jet',270)
insert into imprimante values(3,'1434','da','Jet',290)
insert into imprimante values(4,'1401','nu','Matrix',150)
insert into imprimante values(5,'1408','nu','Matrix',270)
insert into imprimante values(6,'1288','nu','Laser',400)

go