Answer:

Subject: Distributed Databasebe

Please solve both parts as this is single qs and both parts are related. Solve it when you are sure about both.

a)

Create a table DEPARTMENT having attributes DEPID, DEPNAME, DEPLocation and then create table EMPLOYEE having attributes EmpID, EmpName, EmpAddress, EmpAge. The relationship between DEPARTMENT and EMPLOYEE table is one-to-many.

Apply following to the table EMPLOYEE and DEPARTMENT using SQL Query Engine.

• Map one-to-many relationship between EMPLYOEE and DEPARTMENT tables.
• Insert four records in both the tables and then apply inner join on them.
• Delete any record from the EMPLOYEE table using join.
• Update the address of any employee using join
• Apply left join on both the tables.

b)

Suppose you have developed an application for weather forecasting. In order to run this application, you need either a Uni-processor or parallel processing system. According to your understanding which system will be the best for this application and why? Identify the requirements for the proposed system and also its advantages.

Suppose you have developed an application for weather forecasting. In order to run this application, you need either a Uni-processor or parallel processing system. According to your understanding which system will be the best for this application and why? Identify the requirements for the proposed system and also its advantages.