Design a database for the Spotify website.
- Identifying the necessary tables and created them on the E-R diagram.
- Tables are as follows: tbluser, tblplaylist, tblfolloweduser, tblpremiummembership, tblsong, tblsessionhistory, tblsearchhistory, tbldevices, tblfavouritesong, tblcomment.
- The columns required for these tables have been added with appropriate data types. The primary keys of the tables were determined. The foreign keys were added.
- Designed a form application that allows data entry into the spotify database.
- Used C# form for this and included the necessary tools and packages in project to connect Postgresql database to form application.
- Created 10 forms for 10 tables in the database also created a query form where display queries.
- With the form application, it can both add data to database and query the data.
