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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Consider a checkpoint protocol and the following operations in the log. Question One [start_transaction,T4] [Write_Item,T4,D,20,30] [start_transaction,T1] [Commit, T4] [Write_Item,T1,C,5,9]...

Q:

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...

Q:

Part 1. [15 points]. Complete exercise E.4.5 [E.4.5.a, E.4.5.b, E.4.5.c, E.4.5.d, E.4.5.e, E.4.5.f, E.4.5.g]. Picture for reference is attached below. Part 2. [15 points]. Complete exercise E.4.6...

Q:

Quick plz 100b||7 Marks) Consider the following relation Project_Inforamtion: Project Information (EID ProjCode. Proj_Title, Proj_Budget, Dep_No, Dep_Name, Hours, Emp Name, Emp Salary) As can be seen...

Q:

answer the two questions: (A) Please indicate one or two aspects that resonated with you about the document. (B) Please indicate what didnt resonate with you or that you disagree with Section 1: The...

Q:

Problem 4. [25pts) Consider a database with the following schema: Employee(SSN, name, salary, DNo) Department (DNo, DeptName, MgrSSN) Project (PNo, location, ProjName) HourLog(SSN, PNo, hours) The...

Q:

Solve all of the following capacitir statistics questions pleasejQuery224029353428889428_1622752845134?Capacities In this endeavor, you will show your power of the going with abilities: Apply real...

Q:

Ex 4.5 a, b, c, d, e, f, g Chapter 4. Update Operations, Update anomalies, and Normalization 1 2 relation sample . Consider the following with data IA AIRPORT KLX TABLE bate Airlinelo AirlineName...

Q:

answer these two questions: (A) Please indicate one or two aspects that resonated with you about the document. (B) Please indicate what didnt resonate with you or that you disagree with Section 1:...

Q:

Question 2. Normalisation (9 points). Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date, contractor, contractNo) Some notes...

Q:

The Virginia legislature passed two regulations that prohibited the use of certain words in advertisements for alcoholic beverages generally and advertisements within college student publications...

Q:

For the payroll week ending on September 30 (the 39th payroll period of the year), the three following employees had gross earnings as indicated. Each had been employed at the same salary since...

Q:

What effect does written communication have on ones professional life?

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

Q:

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

Q:

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...