Question: Consider the following table (primary key is underlined). P NO 1 1 1 2 2 3 3 P_NAME Hurricane Hurricane Hurricane Coast Coast Satellite Satellite

 Consider the following table (primary key is underlined). P NO 1

Consider the following table (primary key is underlined). P NO 1 1 1 2 2 3 3 P_NAME Hurricane Hurricane Hurricane Coast Coast Satellite Satellite E NO 101 102 104 101 103 104 102 E NAME JOB CLASS John News Elect. Eng David Senior Comm. Tech. Anne Ramoras Comm. Tech. John News Elect. Eng. June Arbough Biol. Eng. Anne Romoras Comm. Tech. David Senior Comm. Tech. CHG HOUR 65 60 60 65 55 60 60 HOURS 13 16 19 15 17 18 14 source: Case Study (Rob & Coronel] The fact that employee 101's name is John News appears to be replicated in this table. The facts that John News is an Elect. Eng. and employee 101's is an Elect. Eng. are also replicated in this table. Assuming it is known that no two employees have the same name, how many facts in this table appear to be replicated. Select one: O a. 1 O b. 5 O c.4 O d. 3 O e. 2

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!