CREATE TABLE [dbo].[Albergo](
  [Codalb] [int] NOT NULL,
  [Descrizione] [varchar](250) NULL,
  [CodComune] [int] NOT NULL,
 CONSTRAINT [PK_Albergo] PRIMARY KEY CLUSTERED 
(
  [Codalb] ASC,
  [CodComune] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO ALBERGO(CODALB,DESCRIZIONE,CODCOMUNE)VALUES(1,'ALBERGO1',59032)

CREATE TABLE [dbo].[Notifiche](
  [id] [int] IDENTITY(1,1) NOT NULL,
  [codalbergo] [int] NOT NULL,
  [codcomune] [int] NOT NULL,
  [data] [datetime] NULL,
 CONSTRAINT [PK_Notifiche_1] PRIMARY KEY CLUSTERED 
(
  [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO NOTIFICHE(CODALBERGO,CODCOMUNE,DATA)VALUES(1,59032,'01/05/2010')
INSERT INTO NOTIFICHE(CODALBERGO,CODCOMUNE,DATA)VALUES(1,59032,'16/05/2010')
INSERT INTO NOTIFICHE(CODALBERGO,CODCOMUNE,DATA)VALUES(1,59032,'01/08/2010')

CREATE TABLE [dbo].[Anagrafica_camere](
  [Id] [int] IDENTITY(1,1) NOT NULL,
  [codalbergo] [int] NULL,
  [codcomune] [int] NULL,
  [nrletti] [int] NULL,
  [tipocamera] [int] NULL,
  CONSTRAINT [PK_Anagrafica_camere] PRIMARY KEY CLUSTERED 
(
  [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO ANAGRAFICA_CAMERE(CODALBERGO,CODCOMUNE,NRLETTI,TIPOCAMERA)VALUES(1,59032,12,1)
INSERT INTO ANAGRAFICA_CAMERE(CODALBERGO,CODCOMUNE,NRLETTI,TIPOCAMERA)VALUES(1,59032,23,2)
INSERT INTO ANAGRAFICA_CAMERE(CODALBERGO,CODCOMUNE,NRLETTI,TIPOCAMERA)VALUES(1,59032,10,3)