Consider the project relation : project PNo Pname Budget Location p1 Database de
ID: 3826605 • Letter: C
Question
Consider the project relation :
project
PNo
Pname
Budget
Location
p1
Database develop
250,000
riyadh
p2
Maintenance
125,000
jeddah
p3
CAD
170,000
abha
p4
Design
200,000
madinah
p5
instrumentation
100,000
qasim
apply horizontal fragmentations:
table1 projects with budget less than 150,000.
b. table2 projects with budget greater than or equal to 150,000.
2. apply vertical fragmentations :
table1 information about project budget.
table2 information about projects names and locations.
how to answr this queation
PNo
Pname
Budget
Location
p1
Database develop
250,000
riyadh
p2
Maintenance
125,000
jeddah
p3
CAD
170,000
abha
p4
Design
200,000
madinah
p5
instrumentation
100,000
qasim
Explanation / Answer
Horizontal fragmentations:
2.Vertical fragmentations:
project1 (a) p2 Maintenance 1,25,000 jeddah p5 instrumentation 1,00,000 qasim project2 (b) p1 Database develop 2,50,000 riyadh p3 CAD 1,70,000 abha p4 Design 2,00,000 madinahRelated Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.