1. HSCI 709: Healthcare Databases Entity Relationship Diagrams
2. Objective
3. I Don't Understand!
4. Purpose of ER Diagrams
5. ER diagram?
6. Definition of ER Diagrams
7. Definition of Entity
8. From Logical to Physical
9. Jargon?
10. Design of Large Databases
11. Logically missing data?
12. Logically Missing Data
13. Duplication
14. Redundant Data
15. Multiple Tables Reduce Inefficiencies
16. Recognizing Entities
17. Electronic Medical Record
18. Looking for Entities
19. I See Two Entities
20. More Entities
21. Diagnosis is about Patients?
22. Depends on More Than Patients
23. Treatment?
24. Treatment Entity
25. Primary Key
26. Key Organizing Concept
27. Facts Belong to Primary Keys
28. Not Black & White
29. Design Choices
30. Art & Science
31. Patient Attributes?
32. Social Security Number
33. Primary Keys for Patient Entity
34. Patient Entity Attributes
35. Atomic Facts not Collections of Facts
36. Patient Attributes Revised
37. Provider table?
38. Provider Attributes
39. Treatment Entity?
40. Treatment Attributes
41. Visit Table
42. Visit Attributes
43. Foreign Keys
44. Components of ER Diagram
45. Setting Relationships
46. referential integrity
47. How?
48. Cascaded Updates
49. Types of Joins
50. Join Examples?
51. Relationships in Words?
52. One to One Joins
53. One to Many Joins
54. One Patient Many Visits
55. Many to Many Joins
56. Example of Junctions?
57. Patient & Address Junction Table
58. Advantage of Junctions
59. Patient & Patient Junction
60. Allows Self Relationships
61. Take Home Lessons
