Please original work select a topic related to architectures or infrastructures (Data Lakehouse Architecture). Discussing how you would implement your chosen topic in a data warehouse project Please cite in text references and add weblinks

Database designs often include two or three levels, depending on their needs. A three-tier database design has what advantages? Mention

Explain the concept of a data warehouse and how it differs from an OLTP database architecture.

Explain the benefits and challenges of implementing a real-time data warehouse.

Explain the term "Data Lake" and how it differs from a traditional database.

Explain the concept of data marts within a data warehousing framework. How do they differ from the central data warehouse, and when should you consider using them?

Explain the principles of data warehousing architecture, including ETL processes, data marts, and OLAP cubes.

Accounting Group Select a problem statement for a proposed database system related to your assigned business area. Pretend you are a consultant firm and are being hired to help a business with a specific business need. Why would they hire you? Document the goals, objectives and mission statement This should be a basic summary of the problem you are trying to solve by designing and building a database. An initial use case diagram for your system: Use cases (at least 4) Actors (at least 2) Relationships (at least 5) (Note: this will require you to define some classes as well!) The use case diagrams should be created using Lucidchart.

Explain the role of data marts in a data warehousing architecture and provide examples of scenarios where data marts are preferred over a centralized data warehouse.

Explain the role of data marts in a data warehouse architecture. How do they support specific business functions or departments within an organization?