DEV Community

Mujahida Joynab
Mujahida Joynab

Posted on

DBMS

Agreegation ->
Representing a whole work as one entity is agreegation
Example - Student Payment Registration Advisor
In ternary relationship , There can be only three connection .
We can connect Student with payment and Registration . Send it to advisor as one entity . This is called agreegation .

Specialization
Generalization
Recursion
Redundant

Multi Row function
Take more than one as input

Employee -> Sum_Salary , Max_Salary, Average_Salary , Min_Salary

Total Employee -> Have to count

Top comments (0)

Billboard image

Try REST API Generation for Snowflake

DevOps for Private APIs. Automate the building, securing, and documenting of internal/private REST APIs with built-in enterprise security on bare-metal, VMs, or containers.

  • Auto-generated live APIs mapped from Snowflake database schema
  • Interactive Swagger API documentation
  • Scripting engine to customize your API
  • Built-in role-based access control

Learn more

👋 Kindness is contagious

If you found this post helpful, please leave a ❤️ or a friendly comment below!

Okay