Which of these is a reason to relate tables in Power BI

Define second normal form. What types of problems might you encounter using tables that are not in second normal form?

Using the tables in Figure Q3.13, create the table that results from MACHINE DIFFERENCE BOOTH. FIGURE Q3.13 THE CH03_VENDINGCO DATABASE TABLES

List the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade.

Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component. Make each entry match the values shown in the following table. TABLE P8.53 UPDATES FOR THE DETAILRENTAL TABLE RENT_NUM VID_NUM DETAIL_RETURNDATE 1001 34342 02-MAR-18 10:00am 1001 61353 03-MAR-18 11:30am 1002 59237 04-MAR-18 03:30pm 1003 54325 09-MAR-18 04:00pm 1003 61369 09-MAR-18 04:00pm 1003 61388 09-MAR-18 04:00pm 1004 44392 07-MAR-18 09:00am 1004 34367 07-MAR-18 09:00am 1004 34341 07-MAR-18 09:00am 1005 34342 05-MAR-18 12:30pm 1005 44397 05-MAR-18 12:30pm 1006 34366 04-MAR-18 10:15pm 1006 61367 1007 34368 1008 34369 05-MAR-18 09:30pm 1009 54324 1001 34366 02-MAR-18 10:00am

Create the ERM. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES