For this hands$-$on assignment, identify and describe the type of data for the database you are developing to design a relational database for your AI assistant. You will apply your knowledge of database design concepts, including different types of relations, various types of keys, functional dependencies, and normalization. The goal is to create a well$-$structured and normalized database schema that efficiently stores and manages data for your selected domain. Remember, you will have an opportunity to build upon and make changes to this later in the course as your understanding and skillset grows. Complete the following steps to write a database design document for your project concept that contains an entity$-$relationship diagram $($ERD$),$ a description of attributes and data types, primary keys, foreign keys, and functional dependencies. Be sure to include in your document the following information.

ERD: Create a basic ERD that represents the necessary entities and their relationships for your project:

Attributes and data types: Define the attributes $($fields$)$ for each entity and specify their data types. Make sure to include appropriate attributes for primary keys, foreign keys, and any necessary attributes to capture relevant information.

Primary keys and foreign keys: Identify the primary keys for each entity. Determine which attributes will act as foreign keys to establish relationships between entities.

Functional dependencies: Identify and document functional dependencies for your entities. Describe how you determined these functional dependencies and why they are important for maintaining data integrity.