SQL Queries: Examples on Database Operations

Posted by on Feb 7, 2025 in Graphic Arts | 0 comments

SQL Queries for Member, Book, and Borrowed Tables

The following SQL queries operate on these tables:

  • member(memb_no, name, age)
  • book(isbn, title, authors, publisher)
  • borrowed(memb_no, isbn, date)

1. Members Who Borrowed McGraw-Hill Books

Print the names of members who have borrowed any book published by “McGraw-Hill”.

SELECT name
FROM member m, book b, borrowed l
WHERE m.memb_no = l.memb_no
AND l.isbn = b.isbn
AND b.publisher = 'McGraw-Hill';

Relational Algebra:

t1 <-- πisbn(σpublisher = "McGraw-Hill"
Read More

Wet Bell Diving: Essential Safety and Operational Procedures

Posted by on Jan 15, 2025 in Graphic Arts | 0 comments

Understanding Wet Bell Diving Operations

Wet bells are used to form a basket with a pavilion where air can be stored. This creates an emergency shelter at the top of the bell in case of equipment failure. Diving support vessels (DPVs) commonly use wet bells in dynamic positioning to transport divers to their workplace.

Advantages of Using Wet Bells

  • They provide safe passage through the splash zone and strong tides.
  • Umbilicals are kept safe and away from dangers on the ship.
  • The amount of air in the rescue
Read More