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
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 1. apply horizontal fragmentations: a. table1 projects with budget less than 150,000. b. table2 projects with budget greater than or equal to 150,000. 2. apply vertical fragmentations : a. table1 information about project budget. b. table2 information about projects names and locations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Transactions On Large Scale Data And Knowledge Centered Systems Xxviii Special Issue On Database And Expert Systems Applications Lncs 9940
Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Qimin Chen
1st Edition
3662534541, 978-3662534540
