2A) Why the B+ tree is preferred in database indexing compared to the B tree justify your answers in terms of the pros and cons of the same and justify your answer with the minimum 5 difference.
2B) Consider the student-detail ER Diagram. Design the DDL commands for student, Course and Subjects entities using SQL.
2C) Consider the following Product schema:
Suppliers(sid: integer, sname: string, address: string)
Parts(pid: integer, pname: string, color: string)
Catalog(sid: integer, pid: integer, cost real)
Solve the following queries using SQL.
1. Find the sids of suppliers who supply some red parts and stay at 221 Packer Street.
2. Find the sids of suppliers who supply some red parts.