/* İkinci dersin ilişkisel tablo ve sorgu örnekleri. */

.reveal .slides section table {
  max-width: 100%;
}

.reveal .slides section table thead th {
  color: #356b78;
  font-weight: 500;
}

.reveal .slides section table td,
.reveal .slides section table th {
  vertical-align: top;
}

.reveal .slides section .flat-record td:nth-child(3),
.reveal .slides section .repeat-table td:nth-child(3) {
  background: #dceff2;
  color: #235c6a;
}

.reveal .slides section .flat-record td:nth-child(4),
.reveal .slides section .repeat-table tbody tr:nth-child(-n+2) td:nth-child(4) {
  background: #fff4dc;
}

.reveal .slides section .repeat-table table {
  width: 100%;
}

.reveal .slides section pre {
  width: 100%;
  margin: 0.8em 0;
  font-size: 0.68em;
  line-height: 1.35;
}

.reveal .slides section pre code {
  max-height: none;
}

.reveal .slides section .relation-tables {
  display: grid;
  grid-template-columns: 1.45fr 1.3fr 0.8fr;
  gap: 0.55em;
  align-items: start;
  margin: 1.2em 0 0.7em;
}

.reveal .slides section .relation-tables table {
  width: 100%;
  margin: 0;
  border-collapse: collapse;
  font-size: 0.72em;
}

.reveal .slides section .relation-table > p {
  margin: 0 0 0.15em;
  color: #356b78;
  font-size: 0.66em;
}

.reveal .slides section .relation-table > p strong {
  font-weight: 600;
}

.reveal .slides section .relation-tables table th,
.reveal .slides section .relation-tables table td {
  white-space: nowrap;
  padding: 0.24em 0.2em;
  border-bottom: 1px solid #ccdce1;
}

.reveal .slides section .relation-tables table th {
  background: #eef5f7;
}

.reveal .slides section .relation-table:nth-child(1) td:last-child,
.reveal .slides section .relation-table:nth-child(2) td:first-child {
  background: #dceff2;
}

.reveal .slides section .relation-table:nth-child(2) td:last-child,
.reveal .slides section .relation-table:nth-child(3) td:first-child {
  background: #fff0cc;
}

.reveal .slides section .database-download {
  color: #0c728d;
  text-decoration-thickness: 0.06em;
  text-underline-offset: 0.15em;
}

/* Anahtarlar: aynı kayıtları slayt adımlarıyla okuyabileceğimiz sade tablolar. */
.reveal .slides section .key-demo {
  margin: 0.55em auto 0.25em;
}

.reveal .slides section .key-demo table {
  margin: 0;
  border-collapse: collapse;
  background: #fff;
}

.reveal .slides section .key-demo caption {
  caption-side: top;
  padding: 0 0 0.18em;
  color: #356b78;
  font-size: 0.9em;
  font-weight: 600;
  text-align: left;
}

.reveal .slides section .key-demo th,
.reveal .slides section .key-demo td {
  padding: 0.24em 0.4em;
  border: 1px solid #ccdce1;
  text-align: left;
  white-space: nowrap;
  transition: background-color 0.45s ease, box-shadow 0.45s ease;
}

.reveal .slides section .key-demo th {
  background: #eef5f7;
  color: #356b78;
}

.reveal .slides section .key-demo--primary {
  width: min(90%, 21em);
}

.reveal .slides section .key-demo--primary table {
  width: 100%;
  font-size: 0.78em;
}

.reveal .slides section .key-demo-context {
  margin: 0.4em 0 0;
  color: #4d6369;
  font-size: 0.64em;
  line-height: 1.35;
  text-align: center;
}

.reveal .slides section .key-demo--primary[data-step="1"] .pk-name {
  background: #fff0cc;
  box-shadow: inset 0 0 0 2px #d6a341;
}

.reveal .slides section .key-demo--primary[data-step="2"] .pk-id {
  background: #dceff2;
  box-shadow: inset 0 0 0 2px #25829a;
}

.reveal .slides section .key-demo-status {
  min-height: 1.5em;
  margin: 0.35em 0 0;
  color: #356b78;
  font-size: 0.74em;
  text-align: center;
}

.reveal .slides section .key-demo-trigger {
  position: absolute;
  width: 0;
  height: 0;
  overflow: hidden;
}

.reveal .slides section .key-demo--foreign {
  width: 100%;
}

.reveal .slides section .key-demo-stage {
  position: relative;
}

.reveal .slides section .key-demo-tables {
  display: grid;
  grid-template-columns: 1.5fr 1.4fr 0.8fr;
  gap: 0.6em;
  align-items: start;
}

.reveal .slides section .key-demo--foreign table {
  width: 100%;
  font-size: 0.54em;
}

.reveal .slides section .key-demo--foreign th,
.reveal .slides section .key-demo--foreign td {
  padding: 0.23em 0.25em;
}

.reveal .slides section .key-demo-links {
  position: absolute;
  inset: 0;
  z-index: 2;
  width: 100%;
  height: 100%;
  overflow: visible;
  pointer-events: none;
}

.reveal .slides section .key-demo-link {
  fill: none;
  stroke: #25829a;
  stroke-width: 3;
  stroke-linecap: round;
  stroke-linejoin: round;
  stroke-dasharray: var(--link-length, 1000);
  stroke-dashoffset: var(--link-length, 1000);
  transition: stroke-dashoffset 0.7s ease;
}

.reveal .slides section .key-demo--foreign[data-step="1"] .key-demo-link--album,
.reveal .slides section .key-demo--foreign[data-step="2"] .key-demo-link--album,
.reveal .slides section .key-demo--foreign[data-step="2"] .key-demo-link--artist {
  stroke-dashoffset: 0;
}

.reveal .slides section .key-demo--foreign[data-step="1"] .fk-album-source,
.reveal .slides section .key-demo--foreign[data-step="1"] .fk-album-target,
.reveal .slides section .key-demo--foreign[data-step="2"] .fk-album-source,
.reveal .slides section .key-demo--foreign[data-step="2"] .fk-album-target {
  background: #dceff2;
  box-shadow: inset 0 0 0 2px #25829a;
}

.reveal .slides section .key-demo--foreign[data-step="2"] .fk-artist-source,
.reveal .slides section .key-demo--foreign[data-step="2"] .fk-artist-target {
  background: #fff0cc;
  box-shadow: inset 0 0 0 2px #d6a341;
}

.reveal .slides section .key-demo--foreign .key-demo-link--artist {
  stroke: #d6a341;
}

/* İlişki türlerinde gerçek tablolar yan yana durur; renk yalnızca eşleşen kimlikleri izletir. */
.reveal .slides section .concept-tables {
  display: grid;
  gap: 0.75em;
  align-items: start;
  margin: 0.7em 0 0.5em;
}

.reveal .slides section .one-many-tables {
  grid-template-columns: 0.85fr 1.55fr;
}

.reveal .slides section .bridge-tables {
  grid-template-columns: 1fr 0.88fr 1.25fr;
  gap: 0.5em;
}

.reveal .slides section .concept-tables table {
  width: 100%;
  margin: 0;
  border-collapse: collapse;
  font-size: 0.68em;
}

.reveal .slides section .bridge-tables table {
  font-size: 0.53em;
}

.reveal .slides section .concept-tables caption {
  caption-side: top;
  padding-bottom: 0.2em;
  color: #356b78;
  font-size: 0.9em;
  font-weight: 600;
  text-align: left;
}

.reveal .slides section .concept-tables th,
.reveal .slides section .concept-tables td {
  padding: 0.28em 0.35em;
  border-bottom: 1px solid #ccdce1;
  text-align: left;
  white-space: nowrap;
}

.reveal .slides section .concept-tables th {
  background: #eef5f7;
}

.reveal .slides section .concept-tables .key-match-list {
  background: #dceff2;
  color: #235c6a;
}

.reveal .slides section .concept-tables .key-match-track {
  background: #fff0cc;
  color: #6c4a14;
}

.reveal .slides section .composite-key-table table {
  width: 40%;
  margin: 0.4em auto 0.6em;
  font-size: 0.78em;
}

.reveal .slides section .composite-key-table tbody tr:first-child td {
  background: #dceff2;
}

/* JOIN bölümünde iki gerçek tabloyu aynı kimliklerden okuyup sonuç satırına taşıyoruz. */
.reveal .slides section .sea-tables,
.reveal .slides section .join-match-sources {
  display: grid;
  grid-template-columns: 0.85fr 1.15fr;
  gap: 1em;
  align-items: start;
  margin: 0.55em auto;
}

.reveal .slides section .sea-tables table,
.reveal .slides section .join-match-demo table,
.reveal .slides section .join-outcome table {
  width: 100%;
  margin: 0;
  border-collapse: collapse;
  background: #fff;
}

.reveal .slides section .sea-tables table {
  font-size: 0.55em;
}

.reveal .slides section .sea-tables caption,
.reveal .slides section .join-match-demo caption,
.reveal .slides section .join-outcome caption {
  caption-side: top;
  padding: 0 0 0.18em;
  color: #356b78;
  font-size: 0.92em;
  font-weight: 600;
  text-align: left;
}

.reveal .slides section .sea-tables th,
.reveal .slides section .sea-tables td,
.reveal .slides section .join-match-demo th,
.reveal .slides section .join-match-demo td,
.reveal .slides section .join-outcome th,
.reveal .slides section .join-outcome td {
  padding: 0.18em 0.42em;
  border-bottom: 1px solid #ccdce1;
  text-align: left;
  white-space: nowrap;
}

.reveal .slides section .sea-tables th,
.reveal .slides section .join-match-demo th,
.reveal .slides section .join-outcome th {
  background: #eef5f7;
}

.reveal .slides section .join-match-demo[data-step="3"] .unmatched-left td:first-child,
.reveal .slides section .join-outcome .join-added-left td:first-child {
  background: #f9e1eb;
  color: #873257;
}

.reveal .slides section .join-match-demo[data-step="3"] .unmatched-right td:first-child,
.reveal .slides section .join-outcome .join-added-right td:nth-last-child(2) {
  background: #fff0cc;
  color: #6c4a14;
}

.reveal .slides section .join-match-demo {
  width: min(95%, 31em);
  margin: 0 auto;
}

.reveal .slides section .join-match-demo table {
  font-size: 0.62em;
}

.reveal .slides section .join-match-result {
  width: 70% !important;
  margin: 0.42em auto 0 !important;
}

.reveal .slides section .join-match-sources tr td,
.reveal .slides section .join-match-result tbody tr {
  transition: background-color 0.35s ease, opacity 0.5s ease, transform 0.5s ease;
}

.reveal .slides section .join-match-demo[data-step="1"] .match-ayah td:first-child,
.reveal .slides section .join-match-demo[data-step="2"] .match-ayah td:first-child,
.reveal .slides section .join-match-demo[data-step="3"] .match-ayah td:first-child,
.reveal .slides section .join-match-demo[data-step="2"] .match-spot td:first-child,
.reveal .slides section .join-match-demo[data-step="3"] .match-spot td:first-child {
  background: #dceff2;
  color: #235c6a;
}

.reveal .slides section .join-match-result tbody tr {
  opacity: 0;
  transform: translateY(-0.6em);
}

.reveal .slides section .join-match-demo[data-step="1"] .join-match-result .match-ayah,
.reveal .slides section .join-match-demo[data-step="2"] .join-match-result .match-ayah,
.reveal .slides section .join-match-demo[data-step="3"] .join-match-result .match-ayah,
.reveal .slides section .join-match-demo[data-step="2"] .join-match-result .match-spot,
.reveal .slides section .join-match-demo[data-step="3"] .join-match-result .match-spot {
  opacity: 1;
  transform: translateY(0);
}

.reveal .slides section .join-outcome {
  width: min(91%, 29em);
  margin: 0.5em auto 0.15em;
}

.reveal .slides section .join-outcome table {
  font-size: 0.65em;
}

.reveal .slides section .join-outcome--full table {
  font-size: 0.54em;
}

.reveal .slides section .join-outcome .join-added-left,
.reveal .slides section .join-outcome .join-added-right {
  display: none;
}

.reveal .slides section .join-outcome--left[data-step="1"] .join-added-left,
.reveal .slides section .join-outcome--right[data-step="1"] .join-added-right,
.reveal .slides section .join-outcome--full[data-step="1"] .join-added-left,
.reveal .slides section .join-outcome--full[data-step="2"] .join-added-left,
.reveal .slides section .join-outcome--full[data-step="2"] .join-added-right {
  display: table-row;
  animation: join-row-arrive 0.5s ease both;
}

@keyframes join-row-arrive {
  from { opacity: 0; transform: translateY(-0.5em); }
  to { opacity: 1; transform: translateY(0); }
}

.reveal .slides section .join-demo-trigger {
  position: absolute;
  width: 0;
  height: 0;
  overflow: hidden;
}

.reveal .slides section .join-demo-status {
  min-height: 1.3em;
  margin: 0.35em 0 0;
  color: #356b78;
  font-size: 0.64em;
  text-align: center;
}

/* Çalma listelerindeki küme işlemleri aynı Venn yerleşimiyle okunur. */
.reveal .slides section .playlist-venn {
  display: block;
  width: min(100%, 800px);
  max-height: 340px;
  margin: 0.3em auto 0.2em;
  font-family: inherit;
}

.reveal .slides section .playlist-venn .venn-a {
  fill: #bcdfe5;
  fill-opacity: 0.8;
  stroke: #4e8794;
  stroke-width: 3;
}

.reveal .slides section .playlist-venn .venn-b {
  fill: #f4d8ac;
  fill-opacity: 0.8;
  stroke: #b88941;
  stroke-width: 3;
}

.reveal .slides section .playlist-venn .venn-outline {
  fill: none;
  stroke: #7c9ca4;
  stroke-width: 3;
}

.reveal .slides section .playlist-venn .venn-selected {
  fill: #a8d5dc;
}

.reveal .slides section .playlist-venn .venn-cutout {
  fill: #fff;
}

.reveal .slides section .playlist-venn .venn-list-name {
  fill: #356b78;
  font-size: 23px;
  font-weight: 600;
}

.reveal .slides section .playlist-venn .venn-count {
  fill: #234f5a;
  font-size: 30px;
  font-weight: 600;
}

.reveal .slides section .playlist-venn .venn-example {
  fill: #39565e;
  font-size: 18px;
}

.reveal .slides section .venn-intro .venn-intro-b {
  opacity: 0;
  transform: translateX(140px);
  transition: opacity 0.35s ease, transform 0.8s ease;
}

.reveal .slides section .venn-intro-trigger:first-child.visible ~ .playlist-venn .venn-intro-b {
  opacity: 1;
}

.reveal .slides section .venn-intro-trigger:nth-child(2).visible ~ .playlist-venn .venn-intro-b {
  transform: translateX(0);
}

.reveal .slides section .venn-intro .venn-intro-regions,
.reveal .slides section .venn-intro-trigger:nth-child(2).visible ~ .playlist-venn .venn-intro-total-a,
.reveal .slides section .venn-intro-trigger:nth-child(2).visible ~ .playlist-venn .venn-intro-total-b {
  opacity: 0;
}

.reveal .slides section .venn-intro-trigger:nth-child(2).visible ~ .playlist-venn .venn-intro-regions {
  opacity: 1;
  transition: opacity 0.25s ease 0.55s;
}

.reveal .slides section .venn-intro-status {
  display: none;
  min-height: 1.4em;
  margin: 0.2em 0 0;
  color: #356b78;
  font-size: 0.64em;
  text-align: center;
}

.reveal .slides section .venn-intro-status--first,
.reveal .slides section .venn-intro-trigger:first-child.visible ~ .venn-intro-status--second,
.reveal .slides section .venn-intro-trigger:nth-child(2).visible ~ .venn-intro-status--third {
  display: block;
}

.reveal .slides section .venn-intro-trigger:first-child.visible ~ .venn-intro-status--first,
.reveal .slides section .venn-intro-trigger:nth-child(2).visible ~ .venn-intro-status--second {
  display: none;
}

.reveal .slides section .venn-intro-trigger {
  position: absolute;
  width: 0;
  height: 0;
}

.reveal .slides section .set-sql-reveal {
  color: #356b78;
  font-size: 0.84em;
}

.reveal .slides section .set-sql-reveal p {
  margin: 0.25em 0 0;
}

.reveal .slides section .set-query-table table {
  width: 100%;
  table-layout: fixed;
}

.reveal .slides section .set-query-table th:first-child {
  width: 56%;
}

.reveal .slides section .set-query-table th:nth-child(2) {
  width: 20%;
}

.reveal .slides section .set-query-table th:last-child {
  width: 24%;
}

/* GROUP BY: aynı altı satır önce türlerine ayrılır, ardından her grup sayılır. */
.reveal .slides section .group-demo {
  width: min(100%, 900px);
  margin: 0.65em auto 0;
}

.reveal .slides section .group-demo-stage {
  display: grid;
  grid-template-columns: 0.92fr 1.08fr;
  gap: 1.35em;
  align-items: start;
}

.reveal .slides section .group-demo-label {
  height: 1.6em;
  margin-bottom: 0.3em;
  color: #356b78;
  font-size: 0.7em;
  font-weight: 600;
}

.reveal .slides section .group-demo-label code {
  font-weight: 600;
}

.reveal .slides section .group-demo-source table {
  width: 100%;
  margin: 0;
  border-collapse: collapse;
  font-size: 0.72em;
}

.reveal .slides section .group-demo-source th,
.reveal .slides section .group-demo-source td {
  padding: 0.23em 0.5em;
  border-bottom: 1px solid #ccdce1;
  text-align: center;
}

.reveal .slides section .group-demo-source th {
  background: #eef5f7;
}

.reveal .slides section .group-demo-source tbody tr td {
  transition: background-color 0.55s ease, color 0.55s ease;
}

.reveal .slides section .group-demo-groups {
  display: grid;
  gap: 0.48em;
}

.reveal .slides section .group-demo-lane {
  display: grid;
  grid-template-columns: 2em 1fr;
  column-gap: 0.55em;
  align-items: center;
  min-height: 2.25em;
  padding: 0.35em 0.55em;
  border: 1px solid #ccdce1;
  border-left: 0.25em solid #8aa5ac;
  background: #f8fbfc;
  font-size: 0.63em;
  text-align: left;
  transition: background-color 0.55s ease, border-color 0.55s ease;
}

.reveal .slides section .group-demo-lane strong {
  grid-row: 1 / span 2;
  font-size: 1.35em;
  font-weight: 600;
  text-align: center;
}

.reveal .slides section .group-demo-items,
.reveal .slides section .group-demo-count {
  opacity: 0;
  visibility: hidden;
  transform: translateX(-1.5em);
  transition: opacity 0.5s ease, transform 0.5s ease, visibility 0.5s;
}

.reveal .slides section .group-demo-count {
  color: #234f5a;
  font-family: var(--r-code-font, monospace);
  font-size: 0.92em;
  transform: translateY(-0.5em);
}

.reveal .slides section .group-demo[data-step="1"] .group-demo-source .group-genre-1 td,
.reveal .slides section .group-demo[data-step="2"] .group-demo-source .group-genre-1 td,
.reveal .slides section .group-demo[data-step="1"] .group-demo-lane.group-genre-1,
.reveal .slides section .group-demo[data-step="2"] .group-demo-lane.group-genre-1 {
  background: #dceff2;
  border-color: #80b7c4;
}

.reveal .slides section .group-demo[data-step="1"] .group-demo-source .group-genre-2 td,
.reveal .slides section .group-demo[data-step="2"] .group-demo-source .group-genre-2 td,
.reveal .slides section .group-demo[data-step="1"] .group-demo-lane.group-genre-2,
.reveal .slides section .group-demo[data-step="2"] .group-demo-lane.group-genre-2 {
  background: #fff0cc;
  border-color: #d9b86d;
}

.reveal .slides section .group-demo[data-step="1"] .group-demo-source .group-genre-3 td,
.reveal .slides section .group-demo[data-step="2"] .group-demo-source .group-genre-3 td,
.reveal .slides section .group-demo[data-step="1"] .group-demo-lane.group-genre-3,
.reveal .slides section .group-demo[data-step="2"] .group-demo-lane.group-genre-3 {
  background: #ede5f2;
  border-color: #bba6c9;
}

.reveal .slides section .group-demo[data-step="1"] .group-demo-items,
.reveal .slides section .group-demo[data-step="2"] .group-demo-items,
.reveal .slides section .group-demo[data-step="2"] .group-demo-count {
  opacity: 1;
  visibility: visible;
  transform: none;
}

.reveal .slides section .group-demo[data-step="1"] .group-genre-2 .group-demo-items,
.reveal .slides section .group-demo[data-step="2"] .group-genre-2 .group-demo-items {
  transition-delay: 0.15s;
}

.reveal .slides section .group-demo[data-step="1"] .group-genre-3 .group-demo-items,
.reveal .slides section .group-demo[data-step="2"] .group-genre-3 .group-demo-items {
  transition-delay: 0.3s;
}

.reveal .slides section .group-demo-status {
  min-height: 1.4em;
  margin: 0.55em 0 0;
  color: #356b78;
  font-size: 0.7em;
  text-align: center;
}

.reveal .slides section .group-demo-trigger {
  position: absolute;
  width: 0;
  height: 0;
  overflow: hidden;
}

@media (max-width: 780px) {
  .reveal .slides section .relation-tables {
    grid-template-columns: 1fr;
  }

  .reveal .slides section .key-demo-tables {
    grid-template-columns: 1fr;
  }

  .reveal .slides section .key-demo--foreign table {
    font-size: 0.68em;
  }

  .reveal .slides section .key-demo-links {
    display: none;
  }

  .reveal .slides section .concept-tables {
    grid-template-columns: 1fr;
  }

  .reveal .slides section .concept-tables table {
    font-size: 0.63em;
  }

  .reveal .slides section .composite-key-table table {
    width: 70%;
  }

  .reveal .slides section .sea-tables,
  .reveal .slides section .join-match-sources {
    gap: 0.4em;
  }

  .reveal .slides section .join-match-demo table,
  .reveal .slides section .join-outcome table {
    font-size: 0.5em;
  }

  .reveal .slides section .group-demo-stage {
    gap: 0.55em;
  }

  .reveal .slides section .group-demo-lane {
    font-size: 0.55em;
  }
}

@media (prefers-reduced-motion: reduce) {
  .reveal .slides section .key-demo td,
  .reveal .slides section .key-demo-link,
  .reveal .slides section .join-match-sources tr td,
  .reveal .slides section .join-match-result tbody tr,
  .reveal .slides section .group-demo-source tbody tr td,
  .reveal .slides section .group-demo-lane,
  .reveal .slides section .group-demo-items,
  .reveal .slides section .group-demo-count,
  .reveal .slides section .venn-intro .venn-intro-b,
  .reveal .slides section .venn-intro .venn-intro-regions {
    transition: none !important;
  }

  .reveal .slides section .join-outcome .join-added-left,
  .reveal .slides section .join-outcome .join-added-right {
    animation: none;
  }
}