Question-1 Integrating LAN Configuration and WAN Services
Task:a) Given a hypothetical business scenario (e.g., a multinational corporation with multiple branch offices), design a network topology that integrates LAN configurations for each branch office and WAN services to connect all offices. Justify your topology design based on scalability, performance, and cost considerations.b) Identify and explain the specific WAN service (e.g., Frame Relay, ATM, MPLS, Wide Area Ethernet) suitable for each branch office connection, taking into account their individual needs and data transfer requirements.
Question 2: Maximizing Guided and Wireless Transmission Media
Task:a) Analyze the advantages and disadvantages of using guided transmission media (e.g., optical fiber, coaxial cable) and wireless transmission media (e.g., Wi-Fi, cellular networks) in a LAN-WAN integrated network.b) Propose a plan to maximize the utilization of both guided and wireless transmission media for seamless communication between LANs and WANs, considering reliability, security, and bandwidth requirements.
Question-2 What is a trigger, and what is its purpose? What is a stored procedure and why is it particularly useful?