Saturday, May 19, 2012

C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

How to make the good design databases? That is the hard question. In my opinion, You were supposed to understand the theory, that can help. Database Design theory, Like Normalization or Normal Form.  Anyway, You can find out about them in the internet. By the way, I suggest to attend "C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class" seminar.
You will learn about.
1. Preamble
2. Normalization (= further normalization)
a. Generalities 
b. FDs and BCNF  
- informal  
- formal  
- preserving FDs  
- FD axiomatization
c. A remark on denormalization
d. JDs and 5NF
- informal
- formal
- implicit dependencies
- the chase
e. MVDs and 4NF
f. Other normal forms
- 6NF and RFNF
3. Orthogonality
4. Redundancy

However, You can purchase "C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class" videos from O'reilly. You can take your time for learning and understand about Normal Forms and etc.

What will you see in Videos?
- Preamble :- What design theory is and why its important. Logical vs. physical design. Redundancy and update anomalies.
- A Review of Relational Basics :- Relations vs. relvars. Predicates. The importance of constraints.
- Normalization - Preliminaries :- Nonloss decomposition. Normalization serves two purposes. Role of projection and join. The normal form hierarchy.
- Normalization - FDs and BCNF (informal) - Part 1 :- What 1NF really is. Functional dependencies (FDs).
- Normalization - FDs and BCNF (informal) - Part 2 :- Superkeys and subkeys. 2NF, 3NF. BCNF (the normal form with respect to FDs).
- Normalization - FDs and BCNF (formal) :- A crucial mental shift. What FDs and BCNF really are. Heaths Theorem.
- Normalization - Preserving FDs :- Good and bad decompositions; why the classical normalization procedure is inadequate. Irreducible covers. 3NF and BCNF algorithms.
- Normalization - FD Axiomatization :- Reasoning about FDs. Armstrongs axioms. Soundness and completeness.
- Denormalization :- A definition. Denormalization considered harmful. Role of star schemas.
- Normalization - JDs and 5NF (informal) :- A surprising fact. Join dependencies (JDs). A relvar in BCNF and not 5NF. Tuple forcing JDs.
- Normalization - JDs and 5NF (formal) - Part 1 :- What JDs and 5NF really are. JDs implied by keys.
- Normalization - JDs and 5NF (formal) - Part 2 :- A useful theorem. Update anomalies revisited.
- Normalization - Implicit Dependencies - Part 1 :- JD equivalence and JD implication. Irreducible JDs. Equivalence proofs.
- Normalization - Implicit Dependencies - Part 2 :- Sets of dependencies. Explicit vs. implicit dependencies.
- Normalization - The Chase :- Given a set of dependencies, what dependencies are implied by those in that given set?
- Normalization - MVDs and 4NF :- Another kind of dependency. Fagins Theorem. Axiomatization. Embedded dependencies.
- Normalization - Other Normal Forms - Part 1 :- 6NF. 5NF revisited: another surprising fact. Redundancy free relvars.
- Normalization - Other Normal Forms - Part 2 :- RFNF (ETNF); SKNF; DK/NF. The end of the road?
- Orthogonality :- Normalization reviewed. A little more science: The Principle of Orthogonal Design. The relationship between orthogonality and normalization.
- Redundancy - Part 1 :- Tuples vs. propositions. What is redundancy? Examples of normalized, orthogonal, redundant design.
- Redundancy - Part 2 :- Dealing with redundancy: four approaches. Controlled vs. uncontrolled redundancy.
- Redundancy - Part 3 :- A proposed definition. Historical notes.
- The Primacy of Primary Keys :- Are primary keys necessary? The invoices and shipments example.
- Redundancy Revisited :- Vincents definition. Yet another normal form. Further reading.

It's easy, you can choose each topic you need to learn. 
In videos, You will learn a lot of idea. It's helpful to understand easy. Because you will be able to learn from examples in video and you can rewind again and again. Wow! that nice. Anyway, You can upload them to iPad/iPhone or etc. You can watch them while you are on the bus.
If you are students? In Database course for College or University, I believe this video will help students for understand about Normalization and Relational concept... blah blah


One thing, this video was presented by C.J. Date (who has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience).


I don't see the reason what makes this video is useless. If you work in database career, or you are studying about Database Design ,Relational Theory or Normal Forms... and you are thinking to get some stuff about them, you should determine for this stuff. 

No comments: