The P$04\_04.$accdb file is an Access database file with several related tables on college courses that students just completed. Use Power Query to import all tables and fields into a Data Model. Which of the tables, if any, are bridge tables, and why are they required? By examining only the tables in the Power Pivot window $($that is$,$ not using pivot tables$),$ find the following information about Steven Buchanan$$s schedule: the sections of the courses he took, the rooms and buildings of these sections, the days and times of these sections, and his grades in these sections.

ID Section Number Course Name Grad Meeting Days Room Number Building

ID Section Number Course Name Grad Meeting Days Room Number Building Number

Select:

ACC $257/$

ART $251/$

BIO $280/$

BUS$151/$

HIS$101/$ POL$101$ Select:

Monday through Friday$/$

Tues$-$Thursday$/$

Mon$-$Wed$-$Friday$/$

Tues$-$Thurs$-$Fri$/$

Mon$-$Thurs$-$Friday$/$

Wed$-$Fri Select:

AS

CC

GYM

IB

LB

TB

Select:

ACC $257/$

ART $251/$

BIO $280/$

BUS$151/$

HIS$101/$ POL$101$ Select:

Monday through Friday$/$

Tues$-$Thursday$/$

Mon$-$Wed$-$Friday$/$

Tues$-$Thurs$-$Fri$/$

Mon$-$Thurs$-$Friday$/$

Wed$-$Fri Select:

AS

CC

GYM

IB

LB

TB

Select:

ACC $257/$

ART $251/$

BIO $280/$

BUS$151/$

HIS$101/$ POL$101$ Select:

Monday through Friday$/$

Tues$-$Thursday$/$

Mon$-$Wed$-$Friday$/$

Tues$-$Thurs$-$Fri$/$

Mon$-$Thurs$-$Friday$/$

Wed$-$Fri Select:

AS

CC

GYM

IB

LB

TB

Select:

ACC $257/$

ART $251/$

BIO $280/$

BUS$151/$

HIS$101/$ POL$101$ Select:

Monday through Friday$/$

Tues$-$Thursday$/$

Mon$-$Wed$-$Friday$/$

Tues$-$Thurs$-$Fri$/$

Mon$-$Thurs$-$Friday$/$

Wed$-$Fri Select:

AS

CC

GYM

IB

LB

TB

Select:

ACC $257/$

ART $251/$

BIO $280/$

BUS$151/$

HIS$101/$ POL$101$ Select:

Monday through Friday$/$

Tues$-$Thursday$/$

Mon$-$Wed$-$Friday$/$

Tues$-$Thurs$-$Fri$/$

Mon$-$Thurs$-$Friday$/$

Wed$-$Fri Select:

AS

CC

GYM

IB

LB

TB

Select:

ACC $257/$

ART $251/$

BIO $280/$

BUS$151/$

HIS$101/$ POL$101$ Select:

Monday through Friday$/$

Tues$-$Thursday$/$

Mon$-$Wed$-$Friday$/$

Tues$-$Thurs$-$Fri$/$

Mon$-$Thurs$-$Friday$/$

Wed$-$Fri Select:

AS

CC

GYM

IB

LB

TB

Tables Is Bridge Table?

Buildings Yes$/$No

Courses Yes$/$No

Rooms Yes$/$No

Sections Yes$/$No

Studnt$\_$Sections Yes$/$No

Students Yes$/$No