Design an updateable database to store data received from another source.

Design an updateable database to store data received from another source.

It is possible that a databased developed may be based on some fixed data that is fed once from a single or multiple sources and the database is then made operational with no facility to update it. But in real life situation the situation is different. Many websites have SQL at their back end. These websites receive data from multiple sources and this data is received and stored in the website’s own database. The basic design of a database receiving data from to sources may look

Image 1

Image 1.

The database design can be carried out with the help of the following code.

For example we want to insert data from Source DB1 into DB1:

Insert into DB1;

Select {Column, Table};

FROM Source DB1;

Select {Column, Table};