declare @Tags table( Id int identity(1,1),TagName varchar(100))

declare @UserTags table (Id int identity(1,1), UserId int,TagId int)

declare @Users table ( Id int identity(1,1), FirstName varchar(100))

insert into @Users

select 'Ravi Sharma' union...

declare @Tags table( Id int identity(1,1),TagName varchar(100))

declare @UserTags table (Id int identity(1,1), UserId int,TagId int)

declare @Users table ( Id int identity(1,1), FirstName varchar(100))

insert into @Users select 'Ravi Sharma'...

When user create any tag then it cannot be inserted in TempTag table if it already exists. But 1 tag which created by a user also associated with other users....

This relationship refers to one to many. Tag created by one user also used by other multiple users.

Actually all this is like twitter tags functionality.

order by totaloftags desc

C Sharp existence in all users = 2

C++ existence in all users = 2

HTML existence in all users = 4

Java existence in all users = 2

SQL Server existence in all...

CREATE TABLE TempTags (Id int identity(1,1), TagName Varchar(50))

create table TempUserTags (Id int identity(1,1), TagId int, UserId int, TagType int)

create table TempUsers (Id int identity(1,1), FirstName varchar(50), LastName varchar(50))

insert into dbo.TempUsers(FirstName,...