Completed

build a library management system using python, C# and mysql

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.

Skills: C Programming, MySQL, PHP, Python

See more: project library management using aspnet, project library management using access, fine calcutation library management using vbnet, library management system step by step create in c sharp part 01, library management system in c# codeproject, library management system in visual studio, library management system c#, film library project c#, how to make library management system, online library management system project in c# net, library management system in sql with source code, software development, c# programming, software architecture, windows desktop, library management using php, simple program library management using, library management using access, online library management using jsp, library management using sql java

About the Employer:
( 1 review ) Dubai, United Arab Emirates

Project ID: #17423973

Awarded to:

shinelancer

*** I have checked your description... I have experience on python and C#. You can see my portfolio. I can do your project as weill. I want to discuss with you this project. Relevant Skills and Experience python, c# More

$155 USD in 3 days
(24 Reviews)
4.9

30 freelancers are bidding on average $208 for this job

hbxfnzwpf

I am java, c++ and python expert, u can check my review and you will know that, please let me do this. Relevant Skills and Experience I am very proficient in c and c++. I have 16 years c++ developing experience now, a More

$200 USD in 7 days
(106 Reviews)
6.8
$155 USD in 1 day
(72 Reviews)
6.4
goalscoreplayer

Hello, nice to meet you. I have checked description carefully. I can satisfy your requirements as Admin interface using python, user interface using c# Relevant Skills and Experience I have 6 years experience for C#,P More

$250 USD in 3 days
(37 Reviews)
6.0
ITPyramid85

hello,how are you. i read your bid carefully. i am C#, Python, SQL expert and have full experience for 7 years. C#, Python, SQL is my top skill. I can provide most quality and high fast. Relevant Skills and Experience More

$155 USD in 3 days
(6 Reviews)
5.8
Programmer59

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 More

$250 USD in 7 days
(50 Reviews)
5.7
MyAwesomeTeam

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 More

$153 USD in 2 days
(29 Reviews)
5.5
ArkssTech

Hi , It’s great to meet you. I’m Somya Tripathi, co-owner of Arkss Technologies Private Limited. We develop: kickass, cutting-edge software for web applications, mobile apps, Blockchain, Cryptocurrency, Tra More

$155 USD in 3 days
(25 Reviews)
5.1
$155 USD in 3 days
(25 Reviews)
5.3
manhpham

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

$222 USD in 5 days
(36 Reviews)
5.1
TakaAlex

Hello Have read your project description carefully. I can do it with 7+ years MySQL,Python Experience. LEt's have a talk for more detail. Thanks. Relevant Skills and Experience C Programming, MySQL, PHP, Python Prop More

$1110 USD in 3 days
(12 Reviews)
5.1
$210 USD in 10 days
(25 Reviews)
4.9
nodinh325

Hi, I am an expert in Python, C# and MYSQL. Your project is to build a library management system. Relevant Skills and Experience I have built many library managements previously. I can do your project perfectly. Prop More

$155 USD in 3 days
(15 Reviews)
4.4
roshanasim

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 More

$196 USD in 3 days
(15 Reviews)
4.5
$250 USD in 4 days
(10 Reviews)
4.2
Guru2705

i can do this Relevant Skills and Experience php Proposed Milestones $155 USD - decide later

$155 USD in 3 days
(7 Reviews)
3.7
harrysathe

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 More

$55 USD in 3 days
(6 Reviews)
3.7
uzafar92

Hi, I am experience python developer with projects done for nearly half a decade. I hope I can help you with your project as smoothly as possible. Relevant Skills and Experience Python Genius Proposed Milestones $50 More

$250 USD in 4 days
(3 Reviews)
3.3
$155 USD in 3 days
(7 Reviews)
3.0
origami07

interface to db Relevant Skills and Experience python c# gui mysql Proposed Milestones $222 USD - complete

$222 USD in 3 days
(8 Reviews)
3.3
midas0925

C# and Python expert whom YOU find is ME. Relevant Skills and Experience I have rich experiences in C# and Python and DBMS- database management system which you want to build. I can make it perfect ASAP what you want More

$222 USD in 3 days
(2 Reviews)
2.1