(a) Use STUDENT and LECTURER tables shown below to answer questions (i) and (ii).Table name: STUDENTSTUD ID100278128569LECT_ID2512272453123525312685534271Table name: LECTURERLECT IDFACULTY ID1223644(i) Based on STUDENT and LECTURER tables, illustrate a naturaljoin.(ii) Create the relational diagram for the database.(b) Define dirty data and identify FIVE (5) of its sources.(c) Give some recent examples of Business Intelligence (BI) usage, using the Internet forassistance. What BI benefits have companies discovered?

As per our rules, we can answer only the first sub-part in a multi-part question. Please submit the…

(a) Use STUDENT and LECTURER tables shown below to answer questions (i) and (ii). Table name: STUDENT STUD ID LECT_ID 100278 128569 512272 4 531235 531268 553427 1 Table name: LECTURER LECT ID FACULTY ID 1 2 2 3 6 4 4 (i) Based on STUDENT and LECTURER tables, illustrate join. a natural (ii) Create the relational diagram for the database.

(a) Use STUDENT and LECTURER tables shown below to answer questions (i) and (ii). Table name: STUDENT STUD ID LECT_ID 100278 128569 512272 4 531235 531268 553427 1 Table name: LECTURER LECT ID FACULTY ID 1 2 2 3 6 4 4 (i) Based on STUDENT and LECTURER tables, illustrate join. a natural (ii) Create the relational diagram for the database.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 11P

See similar textbooks