I

Mapping ER Model to Relational Model Points: 50 points Instructions: For this assignment you must submit a document file (in pdf or doc format). Figure below is the EER Schema for a Video streaming platform. Map this schema into a relational schema. Make sure to specify all primary keys and foreign keys. Provide Relational Schema in the format shown in the lecture slides (Module: Mapping ER model to Relational Model: See page 2 of this assignment for an example). Tited Actor HOME - HOW WATCHING TITLE CHAPTER WATCHINGMOVIE Cond The WATCHING. CHAPTER BOOK Book Title Publisher nama BOOK AUTHORS Bookid Author name PUBLISHER Nurne Address Phone BOOK COPIES Book Branchd No of copies BOOK LOANS Book Bruichid Card_m Dale Due date LIBRARY BRANCH Branch Branch name Address BORROWER Card no Name Address Phone Look that all the ines are individual lines that go from one atbute another Please don't merge or reuse ines, Ines need to beINDIVIDUAL always, including it they are respointing to the same place in bookid Mapping ER Model to Relational Model Points: 50 points Instructions: For this assignment you must submit a document file (in pdf or doc format). Figure below is the EER Schema for a Video streaming platform. Map this schema into a relational schema. Make sure to specify all primary keys and foreign keys. Provide Relational Schema in the format shown in the lecture slides (Module: Mapping ER model to Relational Model: See page 2 of this assignment for an example). Tited Actor HOME - HOW WATCHING TITLE CHAPTER WATCHINGMOVIE Cond The WATCHING. CHAPTER BOOK Book Title Publisher nama BOOK AUTHORS Bookid Author name PUBLISHER Nurne Address Phone BOOK COPIES Book Branchd No of copies BOOK LOANS Book Bruichid Card_m Dale Due date LIBRARY BRANCH Branch Branch name Address BORROWER Card no Name Address Phone Look that all the ines are individual lines that go from one atbute another Please don't merge or reuse ines, Ines need to beINDIVIDUAL always, including it they are respointing to the same place in bookid