Programming Languages Case Study

Project requirements :

Prepare the movie database program written in Python and storing data in the SQLite database with

the following functionality:

$1.$Three tables: movies, directors, actors with the proper relations $($primary and foreign keys$)$

$2.$Added at least one index for faster search

$3.$Added the transaction support

$4.$User interface that allows for:

a$.$ Adding new movie, actor or director from the keyboard

b$.$ Modifying the selected details of the movie, actor or director

c$.$ Searching for the provided details

d$.$ Importing data from csv and Excel files

e$.$ Exporting data to csv and Excel files

$*$Add one more functionality, like uploading the image $($picture of the director$/$actor or the

movie poster$).$

$**$ Build the simple Web$-$based system to manage the data