Page 235 - IT2

Dossier 3 : BASE DE DONNEES - SQL (10 pts)

1) Code de création de la base (TRANSACT SQL)

CREATE TABLE [dbo].[EMETTRE](
[CODE_CHAINE] [varchar](10) NOT NULL,
[CODE_SATELLITE] [int] NOT NULL,
[FREQUENCE] [int] NULL,
[POLARISATION] [char](1),
[DEBIT] [int] NULL,
CONSTRAINT [PK_EMETTRE] PRIMARY KEY CLUSTERED
(
[CODE_CHAINE] ASC,
[CODE_SATELLITE] ASC
)

ALTER TABLE [dbo].[EMETTRE] WITH CHECK ADD CONSTRAINT
[FK_EMETTRE_EMETTRE_CHAINE] FOREIGN KEY([CODE_CHAINE])
REFERENCES [dbo].[CHAINE] ([CODE_CHAINE])
GO
ALTER TABLE [dbo].[EMETTRE] CHECK CONSTRAINT [FK_EMETTRE_EMETTRE_CHAINE]
GO
ALTER TABLE [dbo].[EMETTRE] WITH CHECK ADD CONSTRAINT
[FK_EMETTRE_EMETTRE2_SATELLIT] FOREIGN KEY([CODE_SATELLITE])
REFERENCES [dbo].[SATELLITE] ([CODE_SATELLITE])
GO

www.itlearning-settat.com
Email: admission@itlearning-settat.com

Tél.:0661077812