uniplan

TUTORIAL PARA DESENVOLVIMENTO DE
AGENDA ELETRÔNICA.

Sumário

1. Criação banco de dados.

Abra o SQL Server Management Studio (No meu caso estou usando o SQL Server 2008).

Clique em NOVA CONSULTA conforme.

Figura 1.

2. Digite código abaixo na nova consulta.

USE [master]
GO
/****** Object: Database [AGENDA] Script Date: 04/15/2013 19:20:51 ******/
CREATE DATABASE [AGENDA] ON PRIMARY

CREATE TABLE [dbo].[AGENDA]( [ID_CONTATO] [int] IDENTITY(1,1) NOT NULL, [NOME] [varchar](100) NOT NULL, [EMAIL] [varchar](50) NOT NULL, [TELEFONE] [varchar](30) NOT NULL, [ENDERECO] [varchar](100) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tb_nivel_acesso]( [id_nivel_acesso] [int] NOT NULL, [nivel_acesso] [varchar](50) NULL, CONSTRAINT [PK_tb_nivel_acesso] PRIMARY KEY CLUSTERED
(
[id_nivel_acesso] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

CREATE TABLE [dbo].[tb_usuario]( [id_usuario] [int] IDENTITY(1,1) NOT NULL, [usuario] [varchar](50) NULL, [senha] [varchar](50) NULL, [repita_senha] [varchar](50) NULL, [data_cadastro] [datetime] NULL, [dia_acesso] [datetime] NULL, [nivel_acesso] [int] NULL, CONSTRAINT [PK_tb_usuario] PRIMARY KEY CLUSTERED
(
[id_usuario] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tb_usuario] WITH CHECK ADD CONSTRAINT [FK_tb_usuario_tb_nivel_acesso] FOREIGN KEY([nivel_acesso])
REFERENCES [dbo].[tb_nivel_acesso] ([id_nivel_acesso])
ON UPDATE CASCADE
ON DELETE SET NULL
GO

ALTER TABLE [dbo].[tb_usuario] CHECK CONSTRAINT [FK_tb_usuario_tb_nivel_acesso]