Question about database normalization

1. When you start designing your database. It's implicit. It's only a process of reshuffling if you come to a bad designed database.
2. ?
3. You have a table (relation) with Instructors for their rows (attributes) with e.g. Name, Phone etc. Information regarding them only. The you have another table, say Courses with Course code e.g. about the courses only. Instructor is only one information, and from that information, you can fetch the other ones from table Instructors.
4. An Introduction to Database Systems By C J Date.
Send me a mail if you want me to help you design the database.

re 1)

Du bruger normalisering i database design fasen.

re 2)

BCNF (Boyce Codd Normal Form) er næsten det samme som 3NF (3. Normal Form). Det er muligt at konstruere eksempler som er 3NF men ikke BCNF, men det er nogle meget specielle eksempler.

https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form har detaljer.

re 3)

Den viste tabel struktur er ikke normaliseret, da der er redundant information omkring telefonnumre, når samme instructor optræder flere gange.

re 4)

Enhver seriøs database bog vil have et kapitel omkring normalisering.

Den allerede nævnte An Introduction to Database Systems af C J Date er en god bog. Men i modsætning til hvad titlen antyder, så er det ikke en nem bog for begyndere.

Hi Ankit,
I want to give your answer for the questions which you have asked?

1. When is the process of normalization used?
Answer: In data processing, a process applied to all data in a set that produces a specific statistical property. For example, each expenditure for a month can be divided by the total of all expenditures to produce a percentage.

2. What is Boyce and Codd Normal Form?
Answer:  Boyce–Codd normal form is a normal form used in database normalization. It is a slightly stronger version of the third normal form. BCNF was developed in 1974 by Raymond F. Boyce and Edgar F. Codd to address certain types of anomalies not dealt with by 3NF as originally defined.

For Detailed difference between You cah go with the given link: https://hackr.io/blog/dbms-normalization