Is there anyone to solve my problem. I want details of the solution.?

Question

Write a program for Library Management which will ask to input the name and show the
directory of the main Library Database(LD) file. Then a menu with 5 options will be shown on the screen. The options will be these:

1. Add Record into Library: With this option, a new book's name, it’s code no, writer name and
in which shelf it is kept will be added in the LD.

2. Delete Record from Library: By giving input a book's code no, this option will delete that
book’s record from LD.

3. Find Book from Library: Whether a particular book is kept in the library or not and if it
is, then writer name, code no of that particular book and in which
shelf it is kept will be shown.

4. Show book list: Option to show the all stored books in the Library and the related writer
name, code no and shelf no


5. Exit: Option to quit the program.

Answer 1

As usual, there are too parts to this problem.



One is the database, for storing the book info, adding, deleting, and searching through entries.

The first thing to decide is the data structure.

In real life, this would need to be very large and flexible.

The linked list flexibility of the B+Tree is best of all, and quick to search.

Less powerful but also dynamic linked list structures are the hash table, stack, and queue.

But if this is just a homework assignment, you could just use a sequential array with a static limit of 100 or so.

No teacher is actually going to enter more books than that.



The second part is the user interface.

That is the part that actually is constantly running, and is what calls all the shots to the rest of the routines.

Basically that is always a continuous loop.

It constantly is waiting for input, and then based on the choice, calls the appropriate routine for the logic to carry it out.

After that routine completes, it returns to the user interface calling module, which continues with its loop.

Of course until option 5 is entered.

At which point the routine called does not return, but does an exit instead.



Of course you have to decide what OS (Windows, Linus, Mac) this is for, what programming language to use, whether to use a GUI (graphical user interface) or command line, etc.?

Answer 2

Sounds like all you want is a basic database program. As far as detailed answers, I would pretty much have to write the program, which I did a long time ago for a book store, sorry no longer have it. Any ways, you need to figure out what sort of database you want to use (ie. MySQL, SQL,Access, ....) then write code to interact with it. SQL statements (the satements passed to the database to manilpulate data) are not hard, the hardest part will be error checking and formating the data the way to want it. I am not sure what language you are going to use, vb or c# would make pretty quick work of it.



You may want to check out www.planetsourcecode.com for library programs and them change them for you need. I have a MySQLFront up there that has most of the code in a DLL so that it can be used for more than just my program...but it is still a major work in progress.





Research SQL...you will need to know the statements for INSERT, DELETE, UPDATE, and SELECT and INNER JOIN.

Answer 3

Which Computer Programming Language?

=

Answer 4

You do not give enough detail. Language would be a good start



but more importantly.....



Obviously homework! at least try to do some yourself and ask for help when you get stuck.