build a library management system using python, C# and mysql
$30-250 USD
Plačilo ob prevzemu
PART 1 – Administrative interface (in Python):
This part concerns the development of a Python application, which allows the user to
add, edit, delete and search for books and view book details.
1. You have to use Python to design the application and MySQL to create the
database and provide code to establish the connection between Python and
MySQL to facilitate the required process.
2. Create the Books table in MySQL as per the instructions given in Appendix 1.
3. Provide a user friendly GUI and write code to add, edit and delete books.
4. Allow the user to select Book ID from a summary view and then be able to
view book details of the selected ID.
5. Provide a summary of the contents of the book store, printing the number of
books available, the number of books per subject area, the range of publication
dates (from oldest and to youngest), the range of prices (from minimum to
maximum) and the average price of a book in the bookstore.
PART 2 – User interface (in C#):
This part concerns the development of a user interface (in C#) and an underlying
business logic for the book store, allowing a user to login, search for books, view
book details, check for availability and reserve a book.
Stage 1:
As a first step, make sure that all the technologies required for the development of this
project is installed on your system. In particular, the MySQL DBMS (see the Software
section of this document).
Using the MySQL server, you are then required to create a database library, which
consists of four tables books, authors, customers and reservation
Stage 2:
In this part of the project, you are required to develop a graphical front end to
implement the application server of the site with a user interface. The details of the
functionality required are provided below:
Home: This is the starting point for the application. The user should specify
whether he/she is a customer or not. If a customer, a customer id is required to
be passed for the application. If not a customer, the user should register first
and provide customer id. The response should contain customer details and a
link to the Search Request functionality.
Search Request: This part should allow the user to enter a search criterion
(search by name, by author, by subject) and a value for the chosen criterion.
Search Result: The reply of the search request should be provided by a search
result summary, which requires a search criterion and a value. The response
should contain links to Search Request and Book Detail.
Book Detail: This part returns the details of a particular book. A book id
parameter is required for this interaction. The response should contain links to
Search Request and Check for availability functionalities.
Check for availability: This part returns the available number of the particular
book by tracking the stock from the books table. A book id parameter is
required for this interaction. The response should contain links to the
reservation page.
Reserve a book: A record of reserving books should be associated with each
user, and here such a count is updated. If no record is associated with a user,
one should be created in this interaction. New items should always be added to
the record. A separate function should allow the deletion of an item. Every
time when a reservation is made, the B_STOCK in the Books table is updated
accordingly. The response contains the updated reservation record, displayed
as a list of items with unit prize and per-item costs together with the total cost
for all reserved items. This summary should include links to the records page
for each item and to the Search Request page.
ID projekta: #17423973
Več o projektu
20 freelancerjev ponuja v povprečju za $170 na tem delu
Hi. I'm Thinh. .I think i can do this project Our skills same your requirement skills : PHP, Python, C Programming, MySQL. I always: -Do project fast as possible. -Charge a re Več
Hello Sir, We read your description We have lot of experience in this filed We can do that also If you want We are available for start work right now I am waiting your response Thank you so much. We have complete Več
I have worked in python for 5 years. I have developed a library management system expression recognition in python integration with android, natural language processing in python, regular expressions handling, developm Več
Hello, I am Python and C# expert from Vietnam. I can help you to build the LMS system using those techniques. Please let me help you ya
Hello, how are you? I have read the details provided, but please contact me so that we can discuss more on the project. I believe I have the required skills in this case. Relevant Skills and Experience I believe I hav Več
interface to db Relevant Skills and Experience python c# gui mysql Proposed Milestones $222 USD - complete
Hello Sir, I have read the project description very carefully and I understand that you need a Library Management System Desktop Application in C# and MySQL and in my opinion Python is unnecessary as we can develop th Več
Dear Manager I have read your job posting carefully and noticed what you want I believe my skill for python and C# is enough to finish this task in a short time. I'm looking for your message. Regards Relevant Skills a Več
Hello Client, I have read your requirement about - build a library management system using python, C# and mysql and I am sure I can complete it as per the given description. I do have skills like PHP, Python w Več