This project involves the design and implementation of a relational database for an OTT Subscription Business. The goal was to create a robust database architecture, ensure data security, and provide insightful visualizations to aid decision-making.
- Database Design:
- Designed an Entity-Relationship Diagram (ERD) for a well-structured relational database.
- Stored Procedures:
- Implemented stored procedures for optimized query execution and automated workflows.
- Encryption:
- Added encryption to ensure secure storage of sensitive data such as user information and payment details.
- Data Integrity:
- Applied table-level checks to maintain data consistency and accuracy.
- Visualizations:
- Created detailed dashboards and reports using Tableau to provide business insights.
This project was a collaborative effort by a team of five members:
- Shubhada Bagal
- Kaustubh Khedekar
- Sanket Bansal
- Monica Choudhari
- Yichi Zhang
- Database Management: SSMS
- Visualization: Tableau
- Programming: SQL
- Security Features: Data encryption
- Gained hands-on experience in designing and implementing relational databases.
- Improved understanding of database security practices and data visualization techniques.
- Delivered a fully functional database and an insightful Tableau dashboard.
Feel free to explore this repository and contact us for further details!