Database Design

[mariaale2023]

Design the MongoDB schema for movies, users, reviews, comments, and other necessary collections

• Create a database schema to movies listings, user information, saved searches, and review.

• The schema should include tables for movies, users, searches, and rewiew, with appropriate relationships and indexes.

• The movies table will store details such as ID, img, URLvideo, name, year, country, description and other relevant attributes.

• The users table will store user information including user ID, name, email(if required), password, and any additional profile details.

• The searches table will store saved search criteria, associating them with the corresponding user.

• The review table will store the properties that users have marked as favorites.