資料庫專題實作：二手書交易平台

Abstract

中文摘要 (1) 目的 大學生每年都得為新的課堂添購課本，但新課本價格昂貴，甚至課程結束後，難有機會再次使用它。因此，我們希望建立一個平台，讓第一次上新課程的同學，可以透過我們的平台，用較低的價格買到二手教科書之餘，也可以讓已經上完課的同學，透過我們的平台，將課本轉售出去。如此一來，可以紓解大學生買課本的經濟壓力之外，還可以達到環保愛地球的功效。 (2) 過程及方法 本次專題首先是用畫ER-MODEL設計資料庫的分類和內容，接著是將資料正規化，避免設計不周全的錯誤，在規劃完善之後，即開始在電腦主機上做實作，以及匯入必要之資料進資料庫，主要著重使用SQL、XAMPP軟體、HTML、CSS、JavaScript與PHP等程式語言撰寫，最後將完成的成果架上網站。 (3) 結果： 我們打造出了二手書交易平台，已經可以實現書本交易、上架書本、管理上架書本、管理交易紀錄與系統後台管理平台的功能。雖然還存在一些問題導致無法立刻上線，但我們會繼續努力，將該平台的功能完善後上線經營。

Abstract Purpose Every year, College students have to buy textbooks for a new courses, but the new textbooks are too expensive, and even in the end of courses, it is difficult to have the opportunity to use them again. Therefore, we hope to build a platform so that students who are taking a new course for the first time can buy second-hand textbooks at a lower price through our platform, and students who have already finished the courses can also use our platform to resell their textbooks. In this way, it not only relieve the financial pressure of college students to buy textbooks, but can also achieve the effect of environmental protection and love for the earth.

Process and Approach First, this project is using ER-MODEL to design the classification and content of the database, and then to normalize data to avoid the error of design incompletion. After finishing the design, we start to work on computer host and put necessary data into database. We primarily focus on using programming language like SQL, XAMPP, HTML, JavaScript, CSS, and so on. Finally, we put the completed result on the website.

Result We have already built a second-hand transaction platform that can accomplish functions of book transaction, book shelf management, transaction record management and system background management platform. Although there are still some problems which hinder the platform from working on the Internet immediately, we will continue to work hard to improve the functions of the platform and make it work online.