> For the complete documentation index, see [llms.txt](https://metis-montessori-lyceum.gitbook.io/sql-0/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://metis-montessori-lyceum.gitbook.io/sql-0/database-bouwen/7-tabellen-maken/antwoord.md).

# Antwoord

```sql
CREATE TABLE [personen] 
(
    [PERSOONID] int,
    [VOORNAAM] text,
    [ACHERNAAM] text,
    PRIMARY KEY ([PERSOONID])
);

CREATE TABLE [films] 
(
    [FILMID] int,
    [TITEL] text,
    [JAAR] text,
    PRIMARY KEY ([FLMID])
);

CREATE TABLE [rating] 
(
    [RATINGID] int,
    [FILMID] text,
    [PERSOONID] text,
    [RATINGSDATUM] date,
    [AANTALSTERREN] int,
    PRIMARY KEY ([RATINGID])
);
```

![](https://753078255-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MOeeu-y2Q6rkZfpKoTs%2F-MOf9ApbbIMz3cA3d2O-%2F-MOfCEREPjZT56WYXhUQ%2Fimage.png?alt=media\&token=d928e1bc-027c-4d0b-b526-c6d1b59a4206)