The project is about creating a database for an artificial Museum. The tasks involve:
- creating ERD using information regarding entities and their relationship. Such as paintings and their author as well as to or from which the paintings are loaned or borrowed.
- converting entities in ERD to tables using logical designs. this step involves recognizing and attribute unique primary keys to each table and foreign keys representing relationships.
- using SQL to create database, to update tables, to extract information serving specific topics in question.

ERD on Lucid Chart