The script below is extracted from LucidCharts in SQL Server format. It provides 'Schema Ready' result in SQL Fiddle website.---

 

CREATE TABLE [movie] (

 [movieID] integer,

 [moviename] varchar(50),

 [genreID] integer,

 [releasedate] date,

 [duration] time,

 [language] varchar(50),

 PRIMARY KEY ([movieID])

);

 

CREATE TABLE [rental] (

 [rentalID] integer,

 [movieID] integer,

 [memberID] integer,

 [rentaldate] date,

 [returndate] date,

 [totalcost] decimal(10,2),

 PRIMARY KEY ([rentalID]),

 CONSTRAINT [FK_rental.movieID]

   FOREIGN KEY ([movieID])

     REFERENCES [movie]([movieID])

);

 

CREATE TABLE [movieCharacter] (

 [characterID] integer,

 [role] varchar(50),

 [movieID] integer,

 PRIMARY KEY ([characterID]),

 CONSTRAINT [FK_movieCharacter.movieID]

   FOREIGN KEY ([movieID])

     REFERENCES [movie]([movieID])

);

 

CREATE TABLE [member] (

 [memberID] integer,

 [firstname] varchar(50),

 [lastname] varchar(50),

 [registrationdate] date,

 PRIMARY KEY ([memberID])

);

 

CREATE TABLE [finePayments] (

 [finepaymentsID] integer,

 [memberID] integer,

 [paymentdate] date,

 [paymentamount] decimal(10,2),

 PRIMARY KEY ([finepaymentsID]),

 CONSTRAINT [FK_finePayments.memberID]

   FOREIGN KEY ([memberID])

     REFERENCES [member]([memberID])

);

 

CREATE TABLE [genreData] (

 [genreID] integer,

 [genrename] varchar(50),

 PRIMARY KEY ([genreID]),

 

 

);

 

CREATE TABLE [fine] (

 [fineID] integer,

 [memberID] integer,

 [rentalID] integer,

 [finedate] date,

 [fineamount] decimal(10,2),

 PRIMARY KEY ([fineID]),

 CONSTRAINT [FK_fine.rentalID]

   FOREIGN KEY ([rentalID])

     REFERENCES [rental]([rentalID]),

 CONSTRAINT [FK_fine.memberID]

   FOREIGN KEY ([memberID])

     REFERENCES [member]([memberID])

);

 

---The values I want to insert are shared below.---

movie Table: movieID, moviename, genreID, releasedate, duration, language

1, Fear, 6, 2020-10-10, 01:25, Arabic

2, Alien, 7, 2020-09-18, 01:48, Turkish

3, Troll, 8, 2020-08-27, 01:33, Spanish

4, Wednesday, 9, 2020-11-11, 01:58, Chinese

5, Avatar, 10, 2020-05-09, 02:02, English 

movieCharacter Table: characterID, role, movieID

11, hero, 1

12, lover, 2

13, magician, 3

14, explorer, 4

15, innocent, 5

 

genreData Table: genreID, genrename

6, action

7, horror

8, fiction

9, romance

10, comedy

 

member Table: memberID, firstname, lastname, regitrationdate

16, Ahmet, Kayalar, 2019-04-09

17, Patrick, Mahome, 2019-04-18

18, Kevin, Durant, 2019-05-15

19, Steph, Curry, 2019-12-03

20, Grant, Baskan, 2019-05-07

 

rental Table: rentalID, movieID, memberID, rentaldate, returndate, totalcost

21, 1, 16, 2021-01-01, 2021-02-02, 15

22,2, 17, 2021-01-02, 2021-02-03, 36

23,3, 18, 2021-01-03, 2021-02-04, 43.5

24,4, 19, 2021-01-04, 2021-02-05, 24

25,5, 20, 2021-01-05, 2021-02-06, 27.99

 

fine Table: fineID, memberID, rentalID, finedate, fineamount

26, 16, 21, 2021-01-10, 10

27, 17, 22, 2021-01-11, 12.5

28, 18, 23, 2021-01-12, 11.99

29, 19, 24, 2021-01-13, 21.35

30, 20, 25, 2021-01-14, 19.85

 

finepayments table: finepaymentsID, memberID, paymentdate, paymentamount

31, 16, 2022-01-01, 10

32, 17, 2022-01-05, 12.5

33, 18, 2022-01-10, 11.99

34, 19, 2022-01-15, 20

35, 20, 2022-01-20, 15

---I created a script for it. The insert command script is pasted below.---

INSERT INTO movie (movieID, moviename, genreID, releasedate, duration, language) VALUES

(1, 'Fear', 6, '2020-10-10', '01:25:00', 'Arabic'),

(2, 'Alien', 7, '2020-09-18', '01:48:02', 'Turkish'),

(3, 'Troll', 8, '2020-08-27', '01:33:05', 'Spanish'), 

(4, 'Wednesday', 9, '2020-11-11', '01:58:59', 'Chinese'),

(5, 'Avatar', 10, '2020-05-09', '02:02:02', 'English')   ;

INSERT INTO movieCharacter (characterID, role, movieID) VALUES

(11, 'hero', 1),

(12, 'lover', 2),

(13, 'magician', 3),

(14, 'explorer', 4),

(15, 'innocent', 5);

INSERT INTO genreData (genreID, genrename) VALUES

(6, 'action'),

(7, 'lover'),

(8, 'fiction'),

(9, 'romance'),

(10, 'comedy'); 

INSERT INTO member (memberID, firstname, lastname, registrationdate) VALUES

(16, 'Ahmet', 'Kayalar', '2019-04-09'),

(17, 'Patrick', 'Mahome', '2019-04-18'),

(18, 'Kevin', 'Durant', '2019-05-15'),

(19, 'Steph', 'Curry', '2019-12-03'),

(20, 'Grant', 'Baskan', '2019-05-07');

INSERT INTO rental (reantalID, movieID, memberID, rentaldate, returndate, totalcost) VALUES

(21, 1, 16, '2021-01-01', '2021-02-02', 15),

(22, 2, 17, '2021-01-02', '2021-02-03', 36),

(23, 3, 18, '2021-01-03', '2021-02-04', 43.5),

(24, 4, 19, '2021-01-04', '2021-02-05', 24),

(25, 5, 20, '2021-01-05', '2021-02-06', 27.99);

INSERT INTO fine (fineID, memberID, rentalID, finedate, fineamount) VALUES

(26, 16, 21, '2021-01-10', 10),

(27, 17, 22, '2021-01-11', 12.5),

(28, 18, 23, '2021-01-12', 11.99),

(29, 19, 24, '2021-01-13', 21.35),

(30, 20, 25, '2021-01-14', 19.85);

INSERT INTO finepayments (finepaymentsID, memberID, paymentdate, paymentamount) VALUES

(31, 16, '2022-01-01', 10),

(32, 17, '2022-01-05', 12.5),

(33, 18, '2022-01-10', 11.99),

(34, 19, '2022-01-15', 20),

(35, 20, '2022-01-20', 15);

 

---On SQL Fiddle, I get this error 'Invalid column name 'reantalID'. 

Can you correct these errors and provide me full script including create table and insert values commands in SQL Server FORMAT?. So that it can be successfully run on Microsoft SQL Server Management Studio.