This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE ismerdatabase | |
GO | |
CREATE SCHEMA Employeess | |
GO | |
CREATE TABLE HumanResourcesEmployeess( | |
HRid INT NOT NULL PRIMARY KEY IDENTITY(1,1), | |
HRname NVARCHAR NOT NULL, | |
HRsurname NVARCHAR NOT NULL, | |
HRSSN INT NOT NULL UNIQUE) | |
CREATE TABLE ITEmployeess( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create database sistem1 | |
go | |
use sistem1 | |
go | |
create table [dbo].[marka]( | |
marka_no int not null PRIMARY KEY IDENTITY(1,1), | |
marka_isim nvarchar(50) not null) | |
create table [dbo].[urun]( |