Bangladesh Petroleum Exploration and Production Company Limited
Post: Assistant General Manager (ICT)
Exam Date: 20-01-2023 , Exam Taker: BUET
For each IP address in Group I, identify the correct outgoing interface from Group II using the routing table above.
3. Consider the Schema employee(id, name,salary), equipment(id, name, price), hire(employee_id, equipment_id)
Entity-Relationship Diagram (ERD) for Employee, Equipment, and Hire
Explanation:
Employee Entity: Contains information about employees such as id (Primary Key), name, and salary.
Equipment Entity: Holds details about equipment, including id (Primary Key), name, and price.
Hire Relationship: The Hire relationship connects employees to the equipment they have hired. This is a many-to-many relationship between Employee and Equipment. It includes:
employee_id: A foreign key from the Employee entity.
equipment_id: A foreign key from the Equipment entity.
Many-to-Many Relationship: An employee can hire multiple pieces of equipment, and each piece of equipment can be hired by multiple employees over time.
SELECT e.name FROM employee e JOIN hire h ON e.id = h.employee_id JOIN ( SELECT equipment_id, COUNT(*) AS num_borrowed FROM hire GROUP BY equipment_id ORDER BY num_borrowed DESC LIMIT 1) AS max_equip ON h.equipment_id = max_equip.equipment_id;
Breadth First Traversal: 1 2 3 4 5 or 1 2 3 5 4 or 1 3 2 4 5 or 1 3 2 5 4
Depth First Traversals: 1 2 4 5 3
Given the operations:
Push(200), Push(500), Push(100), S = Pop();
The sequence of operations is as follows:
- Push(200): Adds 200 to the stack.
- Push(500): Adds 500 to the stack.
- Push(100): Adds 100 to the stack.
- Pop(): Removes the topmost element (100) from the stack and assigns it to S.
The value of S after the operation is: 100
1
