mysql - Denormalization a database (Tables with more then one Primary Key)

Question

CREATE TABLE testA1 (
s_id VARCHAR(25),
rang TINYINT(3),
next_step VARCHAR(25),
primary key (s_id,rang) using btree);

CREATE TABLE TestA2 (
s_id VARCHAR(25),
seqtyp TINYINT(3),
startime TIMESTAMP,
primary key (s_id,seqtyp,startime) using btree);

CREATE TABLE TestB1 (
tracker_id VARCHAR(25),
seqtyp TINYINT(3),
startime TIMESTAMP,
something VARCHAR(24),
primary key (tracker_id,seqtyp,startime) using btree);

I want to add that after TestB1 it follows a TableB2 which has the tracker_id as PrimaryKey and some other PrimaryKeys which are in TableC1 and so on. Is this database a Normalized one? And if Yes how do denormalization if there are any tools I could use please tell me. It also would be nice if some could show me how would get this 3 tables into one table as an example. I am young and new to this stuff.

question from:https://stackoverflow.com/questions/65948091/denormalization-a-database-tables-with-more-then-one-primary-key

Answer 1

Waitting for answers