SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[Tbl_1](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Description] [nvarchar](255) NOT NULL,
 CONSTRAINT [PK_Tbl_1] 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];
Insert  Into Tbl_1 ([Description]) VALUES ('M Number 5888');
Insert  Into Tbl_1 ([Description]) VALUES ('M Number 1444');
Insert  Into Tbl_1 ([Description]) VALUES ('M Number 7222');
Select * FROM Tbl_1;


Id
Description


1
M Number 5888

2
M Number 1444

3
M Number 7222


CREATE TABLE [dbo].[Tbl_2](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Fk_Tbl1_Id] [int] NOT NULL,
	[ItemOrdinal] [int] NOT NULL,
	[ItemDesc] [nvarchar](255) NOT NULL,
	[ItemAmt] Decimal(18,2)  NULL,
	[ItemQty] Decimal(18,0)  NULL,
 CONSTRAINT [PK_Tbl_2] 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];
ALTER TABLE [dbo].[Tbl_2]  WITH CHECK ADD  CONSTRAINT [FK_Tbl_2_Tbl_1] FOREIGN KEY([Fk_Tbl1_Id])
REFERENCES [dbo].[Tbl_1] ([Id]);
ALTER TABLE [dbo].[Tbl_2] CHECK CONSTRAINT [FK_Tbl_2_Tbl_1];
Insert  Into Tbl_2 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,1, 'M Number 5888_1',  3.0,  12);
Insert  Into Tbl_2 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,2, 'M Number 5888_2', 51.0,   5);
Insert  Into Tbl_2 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,3, 'M Number 5888_3',  4.0,   9);
Insert  Into Tbl_2 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,4, 'M Number 5888_4',  8.0,  17);
Insert  Into Tbl_2 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,5, 'M Number 5888_5',  3.2,  52);
Insert  Into Tbl_2 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,6, 'M Number 5888_6', 16.0,   2);
Select * FROM Tbl_2;


Id
Fk_Tbl1_Id
ItemOrdinal
ItemDesc
ItemAmt
ItemQty


1
1
1
M Number 5888_1
3.00
12

2
1
2
M Number 5888_2
51.00
5

3
1
3
M Number 5888_3
4.00
9

4
1
4
M Number 5888_4
8.00
17

5
1
5
M Number 5888_5
3.20
52

6
1
6
M Number 5888_6
16.00
2


CREATE TABLE [dbo].[Tbl_3](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Fk_Tbl1_Id] [int] NOT NULL,
	[ItemOrdinal] [int] NOT NULL,
	[ItemDesc] [nvarchar](255) NOT NULL,
	[ItemAmt] Decimal(18,2)  NULL,
	[ItemQty] Decimal(18,0)  NULL,	
 CONSTRAINT [PK_Tbl_3] 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];
ALTER TABLE [dbo].[Tbl_3]  WITH CHECK ADD  CONSTRAINT [FK_Tbl_3_Tbl_1] FOREIGN KEY([Fk_Tbl1_Id])
REFERENCES [dbo].[Tbl_1] ([Id]);
ALTER TABLE [dbo].[Tbl_3] CHECK CONSTRAINT [FK_Tbl_3_Tbl_1];
Insert  Into Tbl_3 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,1, 'M Number 5888_1', 47.0,  1);
Insert  Into Tbl_3 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,2, 'M Number 5888_2',  2.0, 21);
Insert  Into Tbl_3 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,3, 'M Number 5888_3', 43.0,  2);
Insert  Into Tbl_3 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,4, 'M Number 5888_4',  4.0, 12);
Select * FROM Tbl_3;


Id
Fk_Tbl1_Id
ItemOrdinal
ItemDesc
ItemAmt
ItemQty


1
1
1
M Number 5888_1
47.00
1

2
1
2
M Number 5888_2
2.00
21

3
1
3
M Number 5888_3
43.00
2

4
1
4
M Number 5888_4
4.00
12


CREATE TABLE [dbo].[Tbl_4](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Fk_Tbl1_Id] [int] NOT NULL,
	[ItemOrdinal] [int] NOT NULL,
	[ItemDesc] [nvarchar](255) NOT NULL,
	[ItemAmt] Decimal(18,2)  NULL,
	[ItemQty] Decimal(18,0)  NULL,
 CONSTRAINT [PK_Tbl_4] 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];
ALTER TABLE [dbo].[Tbl_4]  WITH CHECK ADD  CONSTRAINT [FK_Tbl_4_Tbl_1] FOREIGN KEY([Fk_Tbl1_Id])
REFERENCES [dbo].[Tbl_1] ([Id]);
ALTER TABLE [dbo].[Tbl_4] CHECK CONSTRAINT [FK_Tbl_4_Tbl_1];
Insert  Into Tbl_4 ([Fk_Tbl1_Id], [ItemOrdinal], [ItemDesc], [ItemAmt],[ItemQty]) VALUES (1,1, 'M Number 5888_1', 1.50, 220);
Select * FROM Tbl_4;


Id
Fk_Tbl1_Id
ItemOrdinal
ItemDesc
ItemAmt
ItemQty


1
1
1
M Number 5888_1
1.50
220
Id	Fk_Tbl1_Id	ItemOrdinal	ItemDesc	ItemAmt	ItemQty
1	1	1	M Number 5888_1	3.00	12
2	1	2	M Number 5888_2	51.00	5
3	1	3	M Number 5888_3	4.00	9
4	1	4	M Number 5888_4	8.00	17
5	1	5	M Number 5888_5	3.20	52
6	1	6	M Number 5888_6	16.00	2
Id	Fk_Tbl1_Id	ItemOrdinal	ItemDesc	ItemAmt	ItemQty
1	1	1	M Number 5888_1	47.00	1
2	1	2	M Number 5888_2	2.00	21
3	1	3	M Number 5888_3	43.00	2
4	1	4	M Number 5888_4	4.00	12