Describe shortly the purpose of the following protocols: Ad…

Describe shortly the purpose of the following protocols: Address Resolution Protocol (ARP) Ethernet IEEE802.3 (with focus on the Exponential Backoff Algorithm) Spanning Tree Protocol (STP) Dynamic Host Configuration Protocol (DHCP) HyperText Transfer Protocol (HTTP)

Assume the following relations: BOOK (Book_ID, Book_Title, B…

Assume the following relations: BOOK (Book_ID, Book_Title, Book_Publisher, Book_Year, Book_Category, Book_Price) STUDENT (St_ID, St_LName, St_FName, St_Major, St_Age, St_GPA) AUTHOR (Author_ID, Author_LName, Author_FName, Author_State) BORROWED (Borrrow_Number, Book_ID, St_ID, Date) BOOK_AUTHOR (Book_ID, Author_ID)   Specify the following queries (Q1—Q3) in relational algebra using a single or multiple expressions. You can use the following relational algebra operators in your solution (copy/paste): σ, ∏, ρ, x, ⋈, ⟕, ⟖, ⟗, ∩, ∪, -, ÷, ℑ You can also use the text equivalent to the above notations instead (e.g., use ‘select’ instead of ‘σ’) Use the Subscript option available in the menu when needed.   (Q1) List the names of students and the title of the books they borrowed since 2020.    (Q2) List the authors of the books that the student ‘Kim Smith’ has never borrowed.   (Q3) Count the number of students in each major who borrowed a book since 2021.