🤭First solution ("Weak")
© Alexander Sychev, Sergei Sychev, “TRIZ-RI Group”
The applicant created following tables:
1) Table "Firms"
Where field Firm_id – is a primary key. The type of company is given in text form.
Firm_id
Firm_name
Firm_type
1.
Pan Myšlenek Company
Our company
2.
TRIZ-RI Group
Client
… etc.
...
...
N.
Sychev&Co Ltd
Supplier
2) Table "People"
Where field People_id – is a primary key, and field Firm_id – is foreign key linking to the table Firms.
People_id
People_name
Firm_ID
1.
Alexander Sychev
1
2.
Alevtina Kavtreva
2.
...etc.
...
...
N.
Sergey Sychev
N.
Obviously, this solution is weak. For example, you can't register an individual as a Client, and many other things do not turn out well. As they say: "The database structure is not normalised ".
Last updated