Create a database called $$LMS$$ for Library Management System using SQL DDL for the with the following scenario:

A public library wants to digitize its inventory and member management systems. The library has a variety of books, magazines, and DVDs$.$ Each item can be borrowed by a library member under specific borrowing rules. The library needs a database to track these items, the members, and the borrowings.

Below are the requirements for each entity:

Items: Each item in the library $($be it a book, magazine, or DVD$)$ has a title, publication year, and a unique item ID $$ all these attributes are required. Books have authors and ISBNs $($assume only $1$ author per book$),$ Magazines have issue numbers and editors $($assume $1$ editor per magazines$),$ and DVDs have durations and directors $($assume $1$ director per DVD$).$

Members: Each member of the library has a unique member ID$,$ a name, an email address, and a phone number. All mandatory fields

Borrowings: The library needs to track which member borrows what item, including the borrowing date and the return date.

Solution must include the following:

Choose appropriate SQL data types for each column.

Establish relationships between tables using primary keys and foreign keys pair.

SQL Statements for creating tables with appropriate data types and constraints.

Use NULL or NOT NULL appropriately.