This database was designed to monitor all the actions and sales of the film shop during some period of time. With the help of this database it will be easier to overlook the stock of films and sales.
Database contains:
3 tables:
- films (film ID, title, type, comments, price, producer ID, production year, date of sales)
- producers (producer ID, producer’s name, address, tel. number, e-mail)
- sales (sales ID, film ID, date of sales, amount of films sold)
…