bookings.CustomerID ─────────(FK)────── customers.CustomerID (PK) │ │ │ (who made the booking) │ (customer details) └── Links booking to customer └── Name, contact info, address, etc.
┌─────────────────┐ │ Data Sources │ (CRM, ERP Systems) └────────┬────────┘ │ ┌─────────────────┐ │ Bronze Layer │ Raw, unprocessed data │ (bronze.*) │ - Exact copy of source ...