The database has two tables:
1- Book Table: with the fields: ID, title, publish date, publisher, category, author ID (which is foreign key to author table).
2- Author Table: with the fields: ID, Name, email, Qualification, Phone, address
Each book has only one author. The author may have more than one book.
The three web forms are:
1- Insert Book form: which allows the visitor to insert a new book. Important hint: the author field should allow the visitor to enter the name as a string, showing suggestions, for example: when he starts with H, the textfield shows all the names that starts with H in the authors table, then insert that author ID in the book table. It's pretty much like Google search suggestion.
2- Search Book form: it allows the visitor to search using any field in the Book Table including the author by name. Regarding the title and the author: the visitor should be given a choice to search by "all the word", (hint: he may enter the title in incorrect order words), or "the exact word or phrase", the same for the author. He may enter the author full name or missing the middle name for example. Anyway, he should get the result.
3- Import Form: the user should be able to import a list of books in an excel file into the Book Table. Hint: the author name in this excel file is entered as text. It should be checked in the author table then added as a foreign key in the Book Table after adding it in the author table if it's not already exist.
All IDs should be generated automatically in the database. The database should be SQL server and the forms asp.NET using the latest .Net environment. Clean, easy to understand, and documented code would be appreciated.