Edsel Site for stuff

Group Members: Raffles Teh Weihan, Edsel Putra Harren, Nathanael Jason Limantara

For our final project we planned on making a data base for a book store, with the name of the book store being Books n Stationary. We are thinking of making the project with 6 tables, the tables would be Employee, Customer, Book, Stationary, Supplier, and Invoice. For the SQL we were thinking of using MySQL, and for coding the GUI we were thinking of coding it with Python and use tkinter. In the application we want the user to be able to insert, update, and delete the items in each table.

For our project we have 6 tables. Every table has a primary key. The employee table keeps records of all the employees, the customer table gives the store members’ information, the supplier table gives a record of both stationary and books bought from the supplier, the stationary table shows what stationary item we sell, the books tables shows what books we sell, the invoice table keeps record for a confirm purchase.

Employee(Employee_ID, Fname, Lname, Gender, DoB, Phone_Num, Email, Salary)

Customer(Member_ID, Fname, Lname, Gender, DoB, Phone_Num, Email)

Supplier(Item_ID, Company_Name, Phone_Num, Item_Name, Item_Quantity, Item_Price, Total_Payment)

Stationary(Item_ID, Price, Stock_Num) Foreign Key(Item_Name) Reference(Supplier(Item_Name))

Book(Item_ID, ISBN, Author, Book_Price, Stock_Num) Foreign Key(Item_Name) Reference(Supplier(Item_Name))

Invoice(Invoice_Num, Equipment_Quantity, Book_Quantity, Total_Price, Invoice_Date) Foreign Key(Member_ID, Employee_ID, Item_ID, ISBN) Reference(Customer(Member_ID), Employee(Employee_ID), Stationary(Item_ID), Book(ISBN))

For our application, the user would be able to view each of the table content and also modify it if they want to, like adding, updating, and deleting.

As for the rest of the tables it is practically the same as the others, the user can insert a new item, update an existing item, and delete an existing table.

What I did for the group project of Books and Stationary are first making the table for MySQL , Then I continue with make a excel for keeping track at everything and also make it easy to check on the thing that we insert. Then I continue with making the GUI, especially the View tab , connecting to the main data base, also making the main windows, and lastly helping a bit on the modify section.