Avatar billede Ankit Dixit Praktikant
01. oktober 2019 - 08:56 Der er 3 kommentarer

Question about database normalization

Hello All,

I want to know to some points in DBMS normalization:

1. When is the process of normalization used?
2. What is Boyce and Codd Normal Form?
3. Can anyone explain me about this example? How database is working

Course code    Course venue    Instructor Name    Instructor’s phone number
CS101    Lecture Hall 20    Prof. George            +1 6514821924
CS152    Lecture Hall 21 .      Prof. Atkins            +1 6519272918
CS154    CS Auditorium            Prof. George            +1 6514821924

Here, the data basically stores the course code, course venue, instructor name, and instructor’s phone number.

4. Any references where i can understand more about it.
Avatar billede Jørgen Kirkegaard Professor
01. oktober 2019 - 13:52 #1
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.
Avatar billede arne_v Ekspert
01. oktober 2019 - 16:39 #2
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.
Avatar billede Rohan Joshi Praktikant
05. november 2019 - 12:10 #3
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
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester