can primary key of one table be a primary key in many other tables
The Primary Key of one table is foreign key for other table. The primary key of one table can be primary key of other tables, but there will be no use of that, it will break the RDBMS Rule and make the RDBMS slow.