please help with these first three. thank you

INSTRUCTIONS: Please read through every instruction and question well. Answer all questions on the answer sheet provided, and turn in the question paper together with the answer sheets. All SQL query statements must be executed on a DBMS. Open-book and notes.

Convert the following relation into an equivalent collection of relations in 3^rd normal form (3NF) by writing down the schema of the resulting tables. The relation concerns student information. The information listed on the students includes details about their books borrowed from the library.

Student(sid firstname, lastname, Status,(ISBN, title, publisher, yearpubliser, cover, dateborrowed, dateofReturn, datereturned))

STUDENT (Sid: char(3), Firstname: char(10), Lastname: char(10),

Status: char(10), (ISBN : char(6), Title : char(20), Publisher: char(20),

YearPublished: numeric(5), Cover: char(4), DateBorrowed: date, DateOfReturn: date, DateReturned: date))

The following functional dependencies exist in the relation above.

Sid Firstname, Lastname, Status

ISBN Title, Publisher, YearPublished, Cover, DateBorrowed, DateOfReturn,

DateReturned

ISBN, Sid DateBorrowed, DateOfReturn, DateReturned

Use SQL to create the normalized tables from your answer to question (1), specifying the primary keys for each table. You are ONLY required to submit the SQL statements used to create the tables.

Using SQL, insert the records (shown on a separate sheet) into the normalized tables created above. You are required to submit the SQL statements.