Antwoord

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])
);