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.