Database Design.pdf_____________________

Database Design

1. Database
Design

2. Understanding Tables (or)Entity

3. Natural Vs Surrogate Keys

4. ER Diagram Vs UML Diagram

5. Relationship Degree

6. Relationship Multiplicity(type)

7. Relationship Optionality

8. ER Diagram Vs UML Diagram

9. Requirement Specification

10. Requirement Specification

11. Step 1:Finding Entities

12. Step 2:Marking Relationship between Entities

13. Step 2:Marking Relationship between Entities

14. Step 2:Marking Relationship between Entities

15. Step 2:Marking Relationship between Entities

16. Step 2:Marking Relationship between Entities

17. Step 2:Marking Relationship between Entities

18. Step 2:Marking Relationship between Entities

19. Step 2:Marking Relationship between Entities

20. Step 2:Mark Relationship

21. Step 3: Assign keys and find attributes

22. Step 4:Mapping attributes for Relationship

23. Step 4:Mapping attributes for Relationship

24. Step 4:Mapping attributes for Relationship

25. Step 4:Mapping attributes for Relationship

26. Normalization

30. Normalization motto
Dependencies only on the key, the whole key and
nothing but the key.
The First Normal Form : key
The Second Normal Form : whole key
The Third Normal Form : only on the key