Database Systems Concepts and DesignΒΆ
Notes for the Database systems concepts and design course.
Link to Course - https://edstem.org/us/courses/47527/lessons/
- Syllabus
- Readings
- Office Hours
- Important Slides of DBMS Class
- Case Study For Database Management
- Normalization
- Normalize
- What is all about?
- The Rules
- Not a relation
- Relation with Problems
- Relation with Problems - Redundancy
- Relation with Problems - Insertion Anamoly
- Relation with Problems = Deletion Anamoly
- Relation with Problems - Update Anamoly
- Information loss
- Dependency Loss
- Perfect Decomposition
- Functional Dependencies
- Full Functional Dependency
- Functional Dependencies and Keys
- Overview of Normal Forms
- Normal Form - Definitions
- Kent and Diehr Quote
- 1NF BCNF flow chart
- Compute with Functional Dependencies with Armstrongs Rules
- How to guarantee lossless joins
- How to guarantee preservation of FDs
- Email Interest - Good Decomposition
- 3NF and BCNF
- It Never Happens in Practice
- Efficiency
- Methodology IV: Implementation
- Metadata
- Archival Metadata Hardware used
- Experiences with Metadata
- The Question
- Preservation metadata OAIS information Model
- OAIS Information Model
- Content Information Package
- OAIS Information Model Part 2
- Preservation Description Information
- OAIS Information Model part 03
- Standards for Archival Metadata are not mature
- Metadata Representation Standards
- Several elements are necessary
- Fundamentals of Databases
- Terms