Reading: Project Overview阅读：项目概述

Project Overview 项目概述

Now that you are equipped with the knowledge and skills to design databases, create tables, and load data, you have the opportunity in the final project to practice and apply your skills by implementing a new data infrastructure.
现在你已经掌握了设计数据库、创建表和加载数据的知识和技能，在最终项目中，你有机会通过实施新的数据基础设施来练习和应用你的技能。

Scenario 场景

In this scenario, you have recently been hired as a Data Engineer by a New York based coffee shop chain that is looking to expand nationally by opening a number of franchise locations. As part of their expansion process, they want to streamline operations and revamp their data infrastructure.
在这个场景中，你最近被一家位于纽约的连锁咖啡店聘为数据工程师，该咖啡店计划通过开设多家特许经营店来扩大全国业务。作为其扩张过程的一部分，他们希望简化运营并改进其数据基础设施。

Your job is to design their relational database systems for improved operational efficiencies and to make it easier for their executives to make data driven decisions.
你的工作是设计他们的关系数据库系统以提高运营效率，并使他们的高管更容易做出数据驱动的决策。

Currently their data resides in several different systems: Accounting software, suppliers' databases, point of sales (POS) systems, and even spreadsheets. You will review the data in all of these systems and design a central database to house all data. You will then create the database objects and load them with source data. Finally, you will create subsets of data that your business partners require, export them, and then load them into staging databases that use different RDBMS.
目前他们的数据存储在多个不同的系统中：会计软件、供应商数据库、销售点（POS）系统和电子表格等。您将审查这些系统中的所有数据，并设计一个中央数据库来存储所有数据。然后，您将创建数据库对象并将它们加载到源数据中。最后，您将创建您的商业伙伴所需的数据子集，导出它们，然后加载到使用不同关系数据库管理系统（RDBMS）的暂存数据库中。

Once you complete your assignment, please take the required screenshots of your work.
完成您的任务后，请截取所需的工作截图。
You can then submit your project using one of the following options:
然后您可以使用以下选项之一提交您的项目：

Option 1 – AI-Graded Submission:
选项 1 - AI 评分提交：
The system will automatically evaluate your completed tasks and provide instant feedback and grading based on your SQL implementation and results.
系统将自动评估您完成的任务，并根据您的 SQL 实现和结果提供即时反馈和评分。

Option 2 – Peer-Reviewed Submission:
选项 2——同行评审提交：
Submit the screenshots you captured as evidence of your completed work for peer evaluation. Ensure that your screenshots clearly display your code, SQL queries, ERD, and outputs.
提交您捕获的截图作为完成工作的证据，供同行评审。确保您的截图清晰显示您的代码、SQL 查询、ER 图和输出。