= Advanced Database Development

== Views

==== Detailed View of a Release

{{{#!div style="text-align: justify; width: 100%;"
Combines the entire metadata of a music release into one detailed overview. For any given release, it aggregates its main artists, features, tracks, total track duration, and provides a real-time summary breakdown of available warehouse stock and pricing for all physical formats simultaneously.
}}}

==== Top 10 Highest Selling Products

{{{#!div style="text-align: justify; width: 100%;"
A detailed analytical view that uses a the previous 7-day period to show the Top 10 best-selling products. It combines data from multiple tables, calculates the total quantity sold, excludes cancelled orders, and sorts the products from highest to lowest selling.
}}}