1 / 10

Minggu 10, Pertemuan 20 Normalization (cont.)

Minggu 10, Pertemuan 20 Normalization (cont.). Matakuliah : T0206-Sistem Basisdata Tahun : 2005 Versi : 1.0/0.0. Learning Outcomes. Pada akhir pertemuan ini, diharapkan mahasiswa dapat mendemonstrasikan proses normalisasi dalam menyusun logical data model (C3). Outline Materi.

chacha
Download Presentation

Minggu 10, Pertemuan 20 Normalization (cont.)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Minggu 10, Pertemuan 20Normalization (cont.) Matakuliah : T0206-Sistem Basisdata Tahun : 2005 Versi : 1.0/0.0

  2. Learning Outcomes Pada akhir pertemuan ini, diharapkan mahasiswa dapat mendemonstrasikan proses normalisasi dalam menyusun logical data model (C3)

  3. Outline Materi • How to identify Boyce–Codd normal form (BCNF).

  4. Boyce–Codd Normal Form (BCNF) • Based on functional dependencies that take into account all candidate keys in a relation, however BCNF also has additional constraints compared with general definition of 3NF. • BCNF - A relation is in BCNF if and only if every determinant is a candidate key.

  5. Boyce–Codd normal form (BCNF) • Difference between 3NF and BCNF is that for a functional dependency A  B, 3NF allows this dependency in a relation if B is a primary-key attribute and A is not a candidate key. • Whereas, BCNF insists that for this dependency to remain in a relation, A must be a candidate key. • Every relation in BCNF is also in 3NF. However, relation in 3NF may not be in BCNF.

  6. Boyce–Codd normal form (BCNF) • Violation of BCNF is quite rare. • Potential to violate BCNF may occur in a relation that: • contains two (or more) composite candidate keys; • the candidate keys overlap (i.e. have at least one attribute in common).

  7. Review of Normalization (UNF to BCNF)

  8. Review of Normalization (UNF to BCNF)

  9. Review of Normalization (UNF to BCNF)

  10. Review of Normalization (UNF to BCNF)

More Related