stage.6

stage.6 work

• Finished the project reflection report
• Recorded the demo video

stage.5

stage.5 work

1. Implement CRUD operations
2. Implement two advanced SQL queries
3. Implement two stored procedures
4. Implement two triggers
5. For extra credit:

• Used a TA-proposed dataset
• Used dynamic chart to display video statics
• User can watch video by clicking the target thumbnail

stage.4

Stage 4 work:

Implement insert, search, update, delete and integrate the application with two advanced SQL queries.

• Insert: User can save videos to target watch list.
• Search: User can get the recommendation videos based on the input keyword and selected video categories.
• Update: User can update the name of selected watchlist.
• Delete: User can delete the selected video from target watchlist.
• Advanced SQL Query1: This SQL query is used to count the number of favorite videos for each video category and sort the result by the number of favorite videos in descending order. As the dataset only contains 13 categories, we did not use the LIMIT clause to select the top 15 rows.
• Advanced SQL Query2: This query is finding the 15 most popular videos with at least 10,000 views that have a high proportion of likes relative to their total reactions based on the most recent record of each video information. Since there are many records for each video on different trending dates, this approach helps to ensure that the query results only contain the most recent information.

stage.3

Stage 3 work:

• Database implementation
• Advanced Queries creation
• Indexing Analysis

stage.2

Stage 2 work:

• Draw a complete and correct ER/UML diagram
• The ER/UML diagram has 5 or more entities
• Had a complete and correctly translated relational schema
• Assumptions of the ER/UML diagram
• A description of each relationship and its cardinality

stage.1

Stage 1 work:

• Updated in TeamInfo.md for teamName
• Updated in TeamInfo.md for project summary
• Creation of the project proposal placed in the doc folder.
• The project proposal includes the title and project summary
• The project proposal includes a detailed description of the application
• The project proposal includes a detailed usefulness description of the application:
• The project proposal includes a detailed realness description of the application
• The project proposal includes a detailed functionality description of the application
• The project proposal includes a detailed low-fidelity UI mockup of the application
• The project proposal includes a detailed project work distribution across the team
• Creatde a release with the correct tag for the submission and submited it on canvas

stage.0

Stage 0 done

• Project team signup, including team name
• Create the project repository with the correct naming and repository URL
• Create the project repository, in the right location, with the correct format
• Create the Readme.md file
• Create the TeamInfo.md file and make appropriate changes.
• Create a release with the correct tag for the submission