[عبد الخالق]

(27-07-23, 08:28 PM)ahmed_king2023 كتب : USE [master]
GO

/****** Object: Database

---

Script Date: 27/07/2023 06:13:23 م ******/
CREATE DATABASE

---

CONTAINMENT = NONE
ON PRIMARY
( NAME = N'HR', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'HR_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE

---

GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_id] 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
/****** Object: Table [dbo].[Employees] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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
/****** Object: Table [dbo].[management] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] PRIMARY KEY CLUSTERED
(
[id] 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
/****** Object: Table [dbo].[unit] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] PRIMARY KEY CLUSTERED
(
[id] 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

هذا السكريبت فيه تكوين الجدوال فقط ولم يتضمن بيانات
اعد السكريبت ولكن قم بتضمين البيانات

---

ايضا لم اجد الاستعلام الذي في اول الموضوع

---

قم بعمل سكريبت لكامل قاعده البيانات بشمل البيانات والاجراءات المخزنه ايضا