Pleae help to prove the full typed, currently sql query(sucess to run in Mysql), E-R digram, and some word explain following the Introduction and requirement blew, thank you so much.

Intriduction:

A library has a collection of 120000 items. Most of them, but not all, may be borrowed. There are about 80000 different titles. Thus, some title has multiple copies. Each title has an identifier, a name and a type. There may be a lot of descriptive information attached to each title. These may include information about the authors, the publisher and the number of pages. Each descriptive piece of data has a name. For example, the name of the publisher information is PUBL. What descriptive data may be used in describing a title depends on the type of the title. The descriptive data used for books may not be the same than the ones used for movies. Some of the elements are mandatory, some are optional. Introduction of new descriptive data elements should be made possible without changing the structure of the database.

There are also items specific information that do not depend on the type of the item. They include where the item is located (department, compartment, self) and when and with what price it has been purchased. Each item has a unique number.

The library has about 20000 customers. Standard customer information like name and address should be registered of all customers. Each customer has been assigned a unique customer identifier. Customers may borrow items from the library. They may also make reservations for the titles. When an item is returned the system should inform the first customer in reservation queue of the return. When an item is borrowed the date of borrowing and the latest date of return is registered. If the item is returned a marking is made in the borrowing record. Records of the borrowing are never deleted.

Project Requirements:

1. MODEL REQUIREMENT

Identify the entities, attributes and relationship between the entities and draw the conceptual model.

2. Table requirement

Design and normalize the tables. Identify the column names, foreign keys and the data types.

Use the CREATE TABLE command to create tables in the database.

3. DATA (created by yourself) LOAD requirement

Insert at least 10 rows in all the tables created.

4. TEST SYSTEM requirement(show answer as five sql queries that used)

Test your table entities individually and against each other by designing five database queries (including simple and complex joins and subqueries, HAVING Key word, WHERE Key word and GROUP BY clause). Use both valid and invalid data to perform your test queries.

5. ER-digram requirement

Draw a E-R digram about the schma you use for the project

Project anlysis explanation