Database Integration-Distributive Database System-Lecture Slides, Slides of Distributed Database Management Systems

Download Database Integration-Distributive Database System-Lecture Slides and more Slides Distributed Database Management Systems in PDF only on Docsity!

In the name of Allah

Dept of CS, MAJU, Ibd

Database Integration

 Reference Chapter 4

Dept of CS, MAJU, Ibd

GAV

Project (pId, pTitle, clName)

Site (pId, stId, stLocation)

Project (pId, pTitle, mangrId)

Create view PROJ1 (pNo, pName, budget, loc, cname, dName) as Select pId, pTitle, ‘NULL’ , ;NULL’, ‘NULL’, ‘DB 1 ’ from DB1.Project

DB1 DB

Create view PROJ2 (pNo, pName, budget, loc, cname, dName) as Select pId, pTitle, ‘NULL’, stLocation, clName, ‘DB 2 ’ from DB2.Project p, DB2.Site s where p.pId = s.pId

PROJ(pNo, pName, budget, loc, cName, dbName)

Create view PROJ (pNo, pName, budget, loc, cname, dName) as

Select * from DB1.PROJ

Union All

Select * from DB2.PROJ2;

GCS