Notes

create table Users(
ID int not null unique identity,
UserName nvarchar(50) not null unique,
FullName nvarchar(50) not null ,
BlogsId int foreign key references Blogs(ID),
CommentID int foreign key references Comments(ID),
Age int,
check (Age>=0 and age<=150)
)

create table Comments(
ID int Primary key identity,
Content nvarchar not null,
check(Content>=0 and Content<=250)
)


create table BlogsTags(
ID int unique not null identity ,
BlogID int Foreign key references Blogs(ID),
TagID int foreign key references Tags(ID)
)

insert into Users
Values('Lamiya','Lamiya885',1,1,19),
('Fidan','Valiyeva',1,1,19),
('Turkan ','dadashova',1,1,19)

insert into Tags
values('#BP215',1)

insert into Blogs
Values('Description1','Title1',1),
('Description2','Title2',2),
('Description3','Title3',3)

insert into categories
values('eylence',1),
('name1',2)

insert into Comments
values('content1'),
('Content2')

create view use_getUsersBlogs
as
select B.Title [Title],U.UserName [User Name ],U.FullName [Full Name] from Blogs as B
join Users as U
on u.BlogsId=b.ID

create view use_getCategoriesBlogs
as
select B.Title [Title],C.[name] [name] from Blogs as B
join Categories as C
on C.BlogsId=B.ID

select *from use_getUsersBlogs
select *from use_getCategoriesBlogs


drop table comments
drop table Tags
drop table Users
drop table Blogs
drop table categories