Please help it is urgent!

Step1: Use Access to create the operational database (E8.2) City Police Department and input sample data as shown in Figure 8.39 (1^st Edition 8.43) and Figure 8.40 (1^st Edition, 8.44).

Step 2: Use SQL commands to create the data warehouse table structures (without data) based on the star schema as shown in Figure 8.41 (1^st Edition: 8.45) and Figure 8.42 (1^st Edition 8.46).

Step 3: Use SQL statements to populate the data warehouse tables.

Step 4: Use SQL commands to:

8.39

8.40

8.41

8.42

Officer Officer Name DTID DTDate DLN Driver Name OFFICER Issues DRIVING TICKET Issued To DRIVER Office Rank Isot Driver Gender DriverBirthYear) DTViolation DTFee DTICKET TYPE PTTypeID Issued for PTViolation DTTypeID PTICKETTYPE Issues Isor PTFee VehicleMake PARKING TICKET Issued For VEHICLE DLN PTID PTDate VehicleLPN VehicleModel DRIVINGTICKET OFFICER DTID DTDate Officer ID OfficeriD (FO DRIVER Officerfame DLN (FK) OfficerRank Vehicle PN FC Driver Name DTTypeID IKI DriverGender Driver BirthYear DTICKETTYPE DTTypeID DTViolation DTFee PARKINGTICKET PTID PTDate Officer D (FK) VEHICLE VehicleLPN (FK) VehicleLPN PTTypeID (FCO) VehicleMake VehicleModel PTICKETTYPE PTTypeID DTViolation OFFICER PTF Officer officer Name officer Rank PTICKETTYPE DTICKETTYPE 1 Joe Sergeant PTTYPID PTViolation PTF DTTYPGID DTViolation DTF 2 Mike Patrolman P1 Meter Expired $100 01 Red Light $200 3 Bob Patrolman P2 Hydrant $150 D2 Seat Belt $100 DRIVINGTICKET VEHICLE DTID DTDate OfficerID DLN Vehicle PN DTTypeID VehicleLPN VehicleMake VehicleModel DT1111 1-Jan-2020 1 111 IL1111 DI IL1111 Honda CRV DT2222 2-Jan-2020 2 222 142222 D: 1L2222 Honda Civic DT3333 2-Jan-20203 111 IL1111 D2 IL3333 Honda Civic PARKINGTICKET DRIVER PTID PTDate Officer D VehicleLPN PTTypeID BLN Driver Name Diver Gender Diver BirthYear PT1111 1-an-2020 1 IL1111 P1 111 Bill Male 1998 PT2222 1-Jan-20202 IL2222 P2 222 Suzy Female 1987 PT3333 2-Jan-20203 123333 P2 VEHICLE REGISTRATION TABLE VehicleLPN Vehicle Vehicle Make Model IL1111 Honda CRV IL2222 Honda Civic Vehicle Year 2017 Owner DLN Owner Gender Owner Name Bill Owner Birth Year 1998 111 Male 2020 222 Female 1987 Suzy David IL 3333 Honda Civic 2018 333 Male 1976 CALENDAR Dimension Calendarkey FullDate DayOfWeek DayOfMonth Month Quarter Year PAYER Dimension PayerKey PayerDLN PayerName PayerGender PayerBirth Year OFFICER Dimension Officer Key OfficerID OfficerName Officer Rank TICKETREVENUE Fact table Calendarkey (FK) Officer Key (FK) PayerKey (FK) VehicleKey (FK) TicketTypeKey (FK) TicketID Amount TICKETTYPE Dimension TicketTypeKey TicketCategory TicketViolation TicketFee VEHICLE Dimension VehicleKey VehicleLPN VehicleMake VehicleModel Vehicle Year VehicleOwnerDLN VehicleOwnerName VehicleOwnerGender VehicleOwnerBirth Year CALENDAR Dimension Otr Calendarkey c1 cz FullDate 1-Jan-2013 2-Jan-2013 DayOfWeek DayOfMonth Tuesday 1 Wednesday 1 Month January January 01 01 Year 2013 2013 PAYER Dimension Paverkey P1 PZ P3 PayerDLN 111 222 333 PayerName Bill Suzy David Payer Gender Male Female Male Payer BirthYear 1988 1977 1966 OFFICER Dimension Officerkey 01 OZ 03 Officerid 1 2 3 Officer Name Joe Mike Officer Rank Sergeant Patrolman Patrolman Bob VEHICLE Dimension Vehiclekey Vehicle LPN Vehicle Make Vehicle Model Vehicle Year Vehicle Owner DLN 111 222 333 Vehicle Owner Name Bill Suzy David Vehicle Owner Gender Male Female Male Vehicle Owner Birth Year 1988 1977 1966 V1 V2 V3 IL1111 IL2222 1L3333 Honda Honda Honda CRV Civic Civic 2007 2012 2005 TICKETTYPE Dimension Ticket TypeKey PK1 PKZ DR1 DRZ Ticket Category Parking Parking Driving Driving Ticket Violation Meter Expired Hydrant Red Light Seat Belt Ticket Fee $100 $150 $200 $100 TICKETREVENUE Fact Table CalenderKey Officerkey Payerkey Vehiclekey Ticketid Amount ci c1 cz C1 CZ 01 Oz 03 01 OZ 03 P1 P2 P3 P1 PZ P1 V1 V2 V3 V1 VZ V1 Ticket Typekey PK1 PKZ PKZ DR1 DR1 DRZ T1 TZ T3 T4 T5 $100 $150 $150 $200 $200 $100 T6