def METHOD_NAME(cls, database_id: int) -> dict[str, Any]:
    database: Any = cls.find_by_id(database_id)
    datasets = database.tables
    dataset_ids = [dataset.id for dataset in datasets]
    charts = (
        db.session.query(Slice)
        .filter(
            Slice.datasource_id.in_(dataset_ids),
            Slice.datasource_type == DatasourceType.TABLE,
        )
        .all()
    )
    chart_ids = [chart.id for chart in charts]
    dashboards = (
        (
            db.session.query(Dashboard)
            .join(Dashboard.slices)
            .filter(Slice.id.in_(chart_ids))
        )
        .distinct()
        .all()
    )
    sqllab_tab_states = (
        db.session.query(TabState).filter(TabState.database_id == database_id).all()
    )
    return {
        "charts": charts,
        "dashboards": dashboards,
        "sqllab_tab_states": sqllab_tab_states,
    }