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 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
Get step-by-step solutions from verified subject matter experts
