Facebook

Bolum1_BilisimVTOlusturmaScripti.sql safest cryptocurrency exchange

From Anadolu, 1 Week ago, written in LaTeX.
URL https://pastebin.pl/view/e6cddef2
Embed
Download Paste or View Raw
Hits: 95
  1. /*Bu script ktiap içindeki örnek veritabanı
  2.  -Bilişim veritabanı,
  3.  -tablolar
  4.  -Örnek verileri
  5.  oluşturma için kullanılabilir */
  6. USE [master]
  7. GO
  8.  
  9. CREATE DATABASE [Bilisim]
  10. GO
  11.  
  12. USE [Bilisim]
  13. SET ANSI_NULLS ON
  14. GO
  15. SET QUOTED_IDENTIFIER ON
  16. GO
  17. CREATE TABLE [dbo].[Bolumler](
  18.  [Bolum_No] [int] IDENTITY(1,1) NOT NULL,
  19.  [Bolum_Adi] [nvarchar](50) NULL,
  20.  CONSTRAINT [PK__Bolumler__7BD17FC87D1E6954] PRIMARY KEY CLUSTERED
  21. (
  22.  [Bolum_No] ASC
  23. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  24. ) ON [PRIMARY]
  25.  
  26.  
  27. CREATE TABLE [dbo].[Calisanlar](
  28.  [TC_No] [nvarchar](11) NOT NULL,
  29.  [Adi] [nvarchar](100) NULL,
  30.  [Bolum_No] [int] NULL,
  31.  [Cinsiyet] [nchar](1) NULL,
  32. PRIMARY KEY CLUSTERED
  33. (
  34.  [TC_No] ASC
  35. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  36. ) ON [PRIMARY]
  37.  
  38.  
  39. CREATE TABLE [dbo].[Satislar](
  40.  [Satis_No] [int] NOT NULL,
  41.  [Urun_No] [int] NULL,
  42.  [Calisan_TC_No] [nvarchar](11) NULL,
  43.  [Miktar] [int] NULL,
  44.  [Fiyat] [decimal](18, 2) NULL,
  45.  [Tarih] [date] NULL,
  46.  CONSTRAINT [PK_Satislar] PRIMARY KEY CLUSTERED
  47. (
  48.  [Satis_No] ASC
  49. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  50. ) ON [PRIMARY]
  51.  
  52.  
  53.  
  54. CREATE TABLE [dbo].[Urunler](
  55.  [Urun_No] [int] IDENTITY(1,1) NOT NULL,
  56.  [Urun_Adi] [nvarchar](50) NULL,
  57.  [Urun_Sayisi] [int] NULL,
  58.  [Urun_Fiyati] [decimal](18, 2) NULL,
  59.  [Bolum_No] [int] NULL,
  60.  CONSTRAINT [PK__Urunler__364714437ED39C8A] PRIMARY KEY CLUSTERED
  61. (
  62.  [Urun_No] ASC
  63. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  64. ) ON [PRIMARY]
  65.  
  66. SET IDENTITY_INSERT [dbo].[Bolumler] ON
  67. INSERT [dbo].[Bolumler] ([Bolum_No], [Bolum_Adi]) VALUES (1, N'Bilgisayar')
  68. INSERT [dbo].[Bolumler] ([Bolum_No], [Bolum_Adi]) VALUES (2, N'Tabletler')
  69. INSERT [dbo].[Bolumler] ([Bolum_No], [Bolum_Adi]) VALUES (3, N'Foto&Kamera;')
  70. INSERT [dbo].[Bolumler] ([Bolum_No], [Bolum_Adi]) VALUES (4, N'Beyaz Eşya')
  71. INSERT [dbo].[Bolumler] ([Bolum_No], [Bolum_Adi]) VALUES (5, N'Tv&Ses;')
  72. INSERT [dbo].[Bolumler] ([Bolum_No], [Bolum_Adi]) VALUES (6, N'Telefon')
  73. SET IDENTITY_INSERT [dbo].[Bolumler] OFF
  74.  
  75. INSERT [dbo].[Calisanlar] ([TC_No], [Adi], [Bolum_No], [Cinsiyet]) VALUES (N'17895632417', N'Ziya Doğan', 3, N'E')
  76. INSERT [dbo].[Calisanlar] ([TC_No], [Adi], [Bolum_No], [Cinsiyet]) VALUES (N'48975626633', N'Ayşe Saygı', 4, N'K')
  77. INSERT [dbo].[Calisanlar] ([TC_No], [Adi], [Bolum_No], [Cinsiyet]) VALUES (N'65638749631', N'Ali Yılmaz', 1, N'E')
  78. INSERT [dbo].[Calisanlar] ([TC_No], [Adi], [Bolum_No], [Cinsiyet]) VALUES (N'78965412305', N'Fatma Doğan', 5, N'K')
  79. INSERT [dbo].[Calisanlar] ([TC_No], [Adi], [Bolum_No], [Cinsiyet]) VALUES (N'89652341780', N'Hasan Çiçek', 2, N'E')
  80. INSERT [dbo].[Calisanlar] ([TC_No], [Adi], [Bolum_No], [Cinsiyet]) VALUES (N'89745632107', N'Kader Kara', 6, N'K')
  81. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (1, 1, N'48975626633', 2, CAST(2500.00 AS Decimal(18, 2)), CAST(N'2015-03-10' AS Date))
  82. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (2, 3, N'48975626633', 1, CAST(25.00 AS Decimal(18, 2)), CAST(N'2015-07-15' AS Date))
  83. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (3, 3, N'48975626633', 1, CAST(25.00 AS Decimal(18, 2)), CAST(N'2015-07-15' AS Date))
  84. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (4, 5, N'65638749631', 2, CAST(75.00 AS Decimal(18, 2)), CAST(N'2015-07-15' AS Date))
  85. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (5, 8, N'65638749631', 1, CAST(150.00 AS Decimal(18, 2)), CAST(N'2015-09-15' AS Date))
  86. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (6, 11, N'78965412305', 3, CAST(2500.00 AS Decimal(18, 2)), CAST(N'2015-08-15' AS Date))
  87. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (7, 15, N'65638749631', 2, CAST(1500.00 AS Decimal(18, 2)), CAST(N'2015-07-21' AS Date))
  88. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (8, 19, N'78965412305', 2, CAST(850.00 AS Decimal(18, 2)), CAST(N'2015-01-06' AS Date))
  89. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (9, 3, N'65638749631', 1, CAST(28.00 AS Decimal(18, 2)), CAST(N'2015-04-27' AS Date))
  90. INSERT [dbo].[Satislar] ([Satis_No], [Urun_No], [Calisan_TC_No], [Miktar], [Fiyat], [Tarih]) VALUES (10, 1, N'89745632107', 4, CAST(2350.00 AS Decimal(18, 2)), CAST(N'2015-11-15' AS Date))
  91. SET IDENTITY_INSERT [dbo].[Urunler] ON
  92.  
  93. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (1, N'Notebook', 3, CAST(2300.00 AS Decimal(18, 2)), 1)
  94. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (2, N'Ultrabook', 5, CAST(3000.00 AS Decimal(18, 2)), 1)
  95. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (3, N'USB Bellek', 7, CAST(20.00 AS Decimal(18, 2)), 1)
  96. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (4, N'Harici Disk', 4, CAST(180.00 AS Decimal(18, 2)), 1)
  97. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (5, N'İşlemci', 9, CAST(51.00 AS Decimal(18, 2)), 1)
  98. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (6, N'Apple Tablet', 4, CAST(1000.00 AS Decimal(18, 2)), 2)
  99. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (7, N'Android Table', 6, CAST(450.00 AS Decimal(18, 2)), 2)
  100. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (8, N'Windows Tablet', 3, CAST(130.00 AS Decimal(18, 2)), 2)
  101. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (9, N'Dijital Kompakt Makine', 8, CAST(250.00 AS Decimal(18, 2)), 3)
  102. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (10, N'SLR Profesyonel Makine', 5, CAST(2000.00 AS Decimal(18, 2)), 3)
  103. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (11, N'Aynasız Makine', 7, CAST(1600.00 AS Decimal(18, 2)), 3)
  104. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (12, N'Buzdolabı', 12, CAST(2000.00 AS Decimal(18, 2)), 4)
  105. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (13, N'Çamaşır Makinası', 9, CAST(1500.00 AS Decimal(18, 2)), 4)
  106. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (14, N'Setüstü Ocak', 6, CAST(400.00 AS Decimal(18, 2)), 4)
  107. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (15, N'LCD', 7, CAST(1300.00 AS Decimal(18, 2)), 5)
  108. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (16, N'Plazma', 6, CAST(2400.00 AS Decimal(18, 2)), 5)
  109. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (17, N'Samsung Telefon', 12, CAST(2500.00 AS Decimal(18, 2)), 6)
  110. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (18, N'Apple Telefon', 10, CAST(3500.00 AS Decimal(18, 2)), 6)
  111. INSERT [dbo].[Urunler] ([Urun_No], [Urun_Adi], [Urun_Sayisi], [Urun_Fiyati], [Bolum_No]) VALUES (19, N'Nokia Telefon', 0, CAST(700.00 AS Decimal(18, 2)), 6)
  112. SET IDENTITY_INSERT [dbo].[Urunler] OFF
  113.  
  114.  
  115. ALTER TABLE [dbo].[Calisanlar]  WITH CHECK ADD  CONSTRAINT [FK__Isciler__Bolum_I__1273C1CD] FOREIGN KEY([Bolum_No])
  116. REFERENCES [dbo].[Bolumler] ([Bolum_No])
  117. GO
  118. ALTER TABLE [dbo].[Calisanlar] CHECK CONSTRAINT [FK__Isciler__Bolum_I__1273C1CD]
  119. GO
  120. ALTER TABLE [dbo].[Satislar]  WITH CHECK ADD  CONSTRAINT [FK_Satislar_Calisanlar] FOREIGN KEY([Calisan_TC_No])
  121. REFERENCES [dbo].[Calisanlar] ([TC_No])
  122. GO
  123. ALTER TABLE [dbo].[Satislar] CHECK CONSTRAINT [FK_Satislar_Calisanlar]
  124. GO
  125. ALTER TABLE [dbo].[Satislar]  WITH CHECK ADD  CONSTRAINT [FK_Satislar_Urunler] FOREIGN KEY([Urun_No])
  126. REFERENCES [dbo].[Urunler] ([Urun_No])
  127. GO
  128. ALTER TABLE [dbo].[Satislar] CHECK CONSTRAINT [FK_Satislar_Urunler]
  129. GO
  130. ALTER TABLE [dbo].[Urunler]  WITH CHECK ADD  CONSTRAINT [FK__Urunler__Bolum_I__15502E78] FOREIGN KEY([Bolum_No])
  131. REFERENCES [dbo].[Bolumler] ([Bolum_No])
  132. GO
  133. ALTER TABLE [dbo].[Urunler] CHECK CONSTRAINT [FK__Urunler__Bolum_I__15502E78]
  134. GO
  135. USE [master]
  136. GO
  137. ALTER DATABASE [Bilisim] SET  READ_WRITE
  138. GO

Reply to "Bolum1_BilisimVTOlusturmaScripti.sql"