Concept
Composite key
Related lectures (20)
Relational Model: Basics
Covers the basics of the relational model in database management systems, including data models, primary and foreign keys.
Database Management Systems: Fundamentals
Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.
File Organization and Indexing
Explores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.
Relational Model: Basics
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Privacy-preserving data publishing: Challenges and Solutions
Explores challenges in privacy-preserving data publishing, including k-anonymity and synthetic data solutions.
Relational Algebra and SQL: Foundations of Database Management
Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.
Privacy-preserving data publishing: Challenges and Solutions
Explores challenges in privacy-preserving data publishing, including failed de-identification examples and privacy threats, and presents a case study on Airbnb's efforts to address racist practices while protecting user privacy.
Data Wrangling Techniques: HBase and Hive Integration
Covers data wrangling techniques using HBase and Hive, focusing on integration and practical applications.
Analytics on Data at Rest and Data in Motion
Explores combining data at rest with data in motion, emphasizing the Lambda architecture complexities and quality assessment of streams and batches.
Entity-Relationship Model
Introduces the Entity-Relationship model for designing databases with a focus on conceptual and relational aspects.