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

Preklicano Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Preklicano 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.

C programiranje MySQL PHP Python

ID projekta: #17423973

Več o projektu

20 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

20 freelancerjev ponuja v povprečju za $170 na tem delu

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 Več

$200 USD v 7 dneh
(168 ocen)
7.2
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 Več

$153 USD v 2 dneh
(95 ocen)
6.5
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 Več

$250 USD v 7 dneh
(86 ocen)
6.6
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 Več

$196 USD v 3 dneh
(40 ocen)
5.5
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 v 5 dneh
(36 ocen)
5.2
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 Več

$55 USD v 3 dneh
(7 ocen)
4.1
origami07

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

$222 USD v 3 dneh
(12 ocen)
3.9
bapixyrs

Dear Client, In my 5+ years as a full stack developer, I have successfully delivered numerous web solutions to my clients. I am confident I can do this project for you. Front End: HTML, CSS, Angular JS, React JS, Več

$155 USD v 3 dneh
(3 ocen)
2.7
farhadakram

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č

$170 USD v 5 dneh
(6 ocen)
2.7
hector1990112948

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č

$45 USD v 3 dneh
(0 ocen)
0.0
surqkhan

I am Siraj from Pakistan. I am working as freelancer since 2014 and also software engineer at Software company. I've worked on server client applications for performing different actions on user commands. I have deve Več

$333 USD v 20 dneh
(0 ocen)
0.0
nehameshram13

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č

$52 USD v 3 dneh
(0 ocen)
0.0