AT&T; LTE 7:42 PM XMidterm practice questions.docx Question 1 (20 points) Develo

Question

AT&T; LTE 7:42 PM XMidterm practice questions.docx Question 1 (20 points) Develop an (ER) Entity-Relationship Diagram that adequately represents the scenario below PRIMCO is a large consulting firm located in the DC area. Its clients are large multinational companies. PRIMCO's business model is based on assigning consultants to clients by matching the client's needs and the consultant's unique client number, the company name, and the industry in which the client specializes. Consultants are described by a unique employee number, first and last name, hire date, and experience level. A consultant can be engaged with several clients simultaneously. Some clients require multiple consultants for a particular project. There is never a need to store a client in the database who has not engaged at least one consultant. Not all consultants have client service experience. engaged on a project, an hourly rat is computed. The start of the engagement must be recorded as well as the end of the engagement. Clients can also rate each consultant. specialty. Clients are described by a When a consultant is PRIMCO has a set of core competencies (e.g. security audit & assurance services, big data analytics etc.). Consultants have specialties in at least one of the core competencies. Of course, for PRIMCO to claim that it has a competency it must have one or more consultants who specialize in the competency. A competency is uniquely identified by its name. Competencies also have detailed descriptions. Finally, PIMCO records the date it acquired a competency Open With Print

Explanation / Answer

a) Not a 2nf because PSALARY( a non prime attribute) is dependent on PNAME which is a proper subset of primary key combination (PID,SID,CID) and this kind
of dependency is not accexptable in 2nf.

It is not in 3nf as for 3nf, it is mandatory that the table should be 2nf and in this case we don't have that.

b) To make it 2nf we will have following tables:

   PID PNAME | SID SNAME | PNAME PSALARY   | CID CNAME CDATE

   The above tables are 2nf as well as 3nf because we don't have transitivity
    issue also which states that non prime attributs should not depend on the     prime attributes transitively

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.