Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
tarefaum
CREATE DATABASE tarefaum --Entidade forte CREATE TABLE tbAluno( codAluno INT PRIMARY KEY IDENTITY(1,1) ,nomeAluno VARCHAR(30) ,datanascAluno smalldatetime ,rgCliente VARCHAR(30) ); --Entidade fraca (ela possui chave estrangeira) CREATE TABLE tbMatricula( codMatricula INT PRIMARY KEY IDENTITY(1,1) ,dataMatricula VARCHAR(10) ,codAluno INT FOREIGN KEY REFERENCES tbAluno(codAluno) ,codTurma VARCHAR (30) ); CREATE TABLE tbTurma( codTurma INT PRIMARY KEY IDENTITY(1,1) ,nomeTurma VARCHAR(30) ,horarioTurma DATETIME(8) ,codCurso INT FOREIGN KEY REFERENCES tbAluno(codCurso) ); CREATE TABLE tbCurso( codCurso INT PRIMARY KEY IDENTITY(1,1) ,nomeCurso VARCHAR(30) ,cargahoraCurso DATETIME (8) ,valorCurso DECIMAL );
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
"OrderForm.asp?Cart="
SQL Server - UK Holiday Calendar Example
Arif
get first parent with a value
Task2_Final
Teacher
student
New
ms sql update,insert
mc170403050
Please log in to post a comment.