Success Video Store (SVS) runs a series of fairly standard video stores. Before a video can be put on the shelf, it must be catalogued and entered into the video database. Every customer must have a valid SVS customer card to rent a video. Customers rent videos for 3 days at a time. Every time a customer rents a video, the system must ensure that he or she does not have any overdue videos. If so, the overdue videos must be returned and an overdue fee must be paid before the customer can rent more videos. Likewise, if the customer has returned overdue videos but has not paid the overdue fee, the fee must be paid before new videos can be rented. Every morning, the store manager prints a report that lists overdue videos; if a video is 2 or more days overdue, the manager calls the customer to remind him or her to return the video. a. Draw a context diagram for the scenario mentioned above. (10 marks) b. Draw a level 0 logical Data Flow Diagram (DFD) for the scenario mentioned above. (20 marks) c. Draw an Entity Relationship Diagram (ERD) for the video rental store mentioned above. Each relationship must be clearly defined. (30 marks)Kelly's Boutique sells books as well as woman's shoes. Kelly is eager to incorporate computers in her business. She uses a database to keep a record of her book inventory. She has a partial list of books which can be a table in her database. The list includes each book's ISBN, department code, related supervisor and supervisor phone number, book title, publisher and publisher contact number, author and list price. 1) Create a new database file using the following information and name the file StudentName_Access. a. Use the information below to create a book table, department table and publisher table in Access, and then PRINT each table. (3 Marks) Book Table ISBN DeptID BookTitle Author PubNum ListPrice 684872153 1 Angela's Ashes McCourt 7 $ 7.99 60244151 2 Betsy‐Tacy Lovelace 2 $ 12.95 670175919 2 Blueberries for Sal McCloskey 5 $ 16.99 27136701 2 Caddie Woodlawn Brink 4 $ 17.00 60173289 1 Divine Secrets of the YaYa Sisterhood Wells 2 $ 24.00 394800168 2 Green Eggs and Ham Seuss 6 $ 7.99 439064864 2 Harry Potter and the Chamber Of Secrets Rowling 9 $ 17.95 439136350 2 Harry Potter and the Prisoner Of Azkaban Rowling 9 $ 17.95 590353403 2 Harry Potter and the Sorcerer's Stone Rowling 9 $ 17.95 140286276 1 The Deep End of the Ocean Mitchard 3 $ 12.95 Department Table DeptID Dept Supervisor Phone 1 Adult Nancy Wine 555‐9754 2 Children Barbara Manchester 555‐1974 Page 4 of 8 Publisher Table PubNum Publisher Contact Phone 1 Mass Market Paperback Smith 555‐9745 2 Harper Collins Potter 555‐7481 3 Penguin Frued 555‐8974 4 Simon & Schuster Gonzales 555‐9874 5 Viking Press Hu 555‐1654 6 Random House Ouimet 555‐9144 7 Scholastic Press Salazar 555‐9888 8 Touchstone Books Chi 555‐1112 9 Arthur A. Levine Books Robinson 555‐5118 b. Establish the appropriate relationship between each table, PRINT the relationship report. (3 Marks) c. Create and PRINT a query that lists department, book title, author, supervisor, publisher and contact. Save this query as BooksByDepartment. (6 Marks) d. Create a form that shows all fields from the book table in a columnar format. Save it as Book Form and PRINT the first record. (7 marks) e. Create and PRINT a report that contains the book title, ISBN, publisher, and phone number. The report should have no grouping, be sorted by book title in ascending order, and be formatted in a tabular portrait layout and all field information should be visible. Save this report as Book Report. (7 Marks)