S
S
sidor_tank2019-02-22 00:49:58
Database design
sidor_tank, 2019-02-22 00:49:58

How to convert a table to 3rd normal form?

The task is as follows: the issuance of loans by the bank. The loan can be obtained by a legal entity. Information fields: Name of the type of loan, Rate, Name of the client company, Type of ownership, Address, Phone, Contact person, Amount, Date of issue, Date of return.
Interesting to know the options. It only occurs to me to create two tables Firms and Loans. Does anyone have any other options?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
sim3x, 2019-02-22
@sidor_tank

Loan:
 type
 datetime_created
 period
 business = FK(Business)

Business:
 name
 type
 addr

Contacts:
 business = FK(Business)
 phone

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question