create table cpu (
IDC int PRIMARY KEY,
IDM int,
Name varchar(15),
clock decimal(2,1)
);

-- hdisk (IDD int первичный ключ, IDM int, Name varchar(15), type varchar(4), size int,
create table hdisk (
IDD int PRIMARY KEY,
IDM int,
Name varchar(15),
clock decimal(2,1)
);

-- nb (IDN int первичный ключ, IDM int, Name varchar(15), IDC int, IDD int)
create table nb (
IDN int PRIMARY KEY,
IDM int,
Name varchar(15),
IDC int,
IDD int
);
-- Phone (IDP int первичный ключ, IDM int, Number int, NameManager varchar)
create table Phone(
IDP int PRIMARY KEY,
IDM int,
Number int,
NameManager varchar
);

create table BSUIR(
ID int primary key identity(1,1),
Building int,
Room int
);

insert into BSUIR values
(5, 605),
(4, 402);

select * from BSUIR;

insert into BSUIR
select Building, Room
from BSUIR


insert into manuf values
(1, 'Intel', 'Santa Clara'),
(2, 'AMD', 'Santa Clara'),
(3, 'WD', 'San Jose'),
(4, 'seagete', 'Cupertino'),
(5, 'Asus', 'Taipei'),
(6, 'Dell','Round Rock');

insert into CPU values
(1, 1, 'i5', 3.2),
(2, 1, 'i7', 4.7),
(3, 2, 'Ryzen 5', 3.2),
(4, 2, 'Ryzen 7', 4.7),
(5, null, 'Power9', 3.5);

insert into hdisk values
(1, 3, 'Green', 'hdd', 1000),
(2, 3, 'Black', 'ssd', 256),
(3, 1, '6000p', 'ssd', 256),
(4, 1, 'Optane', 'ssd', 16);

insert into nb values
(1, 5, 'Zenbook', 2, 2),
(2, 6, 'XPS', 2, 2),
(3, 9, 'Pavilion', 2, 2),
(4, 6, 'Inspiron', 3, 4),
(5, 5, 'Vivobook', 1, 1),
(6, 6, 'XPS', 4, 1);

insert into Phone values
(1, 1,2342, 'a'),
(2, 2,1231, 'b'),
(3, 3,1245, 'c');