In a relational data base the data are stored in tables which thecolumns are att

Question

In a relational data base the data are stored in tables which thecolumns are attributes. A certain table T1 has two attributes. Acertain table T1 has two attributes Identity Number, Job title. Asecond table T2 has two attributes Job Title, Department. the tableT1 is as follows:

Identity Number
Job Title
100 Assistant 101 Team Leader
102 Assistant

Under what condition in the entries of T2 is it possible to combineT1 and T2 into a single table T with the three attributes IdentityNumber, Job Title, Department?

Now suppose that the table T2 in the first requirement satisfiesthe condition under which T1 and T2 can be combined into a singletable T. Describe how T can be created from T1 and T2 by usingJoin, SELECT, and PROJECT in the order given, i.e. JOIN is appliedfirst.



Identity Number
Job Title
100 Assistant 101 Team Leader
102 Assistant

Explanation / Answer

Dear.., T1 has two attributes. T1(Identifynumber, jobtitle) T2(jobtitle,department) SELECT * FROM Tabel1 t1 INNER JOIN Table2 t2 ONt1.jobtitle=t2.jobtitle Now single table we will get Identify number jobtitle and department. I Hope this will helps you. Now single table we will get Identify number jobtitle and department. I Hope this will helps you.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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