Link to project github: https://github.com/edselph/Books_and_Stationary-.git

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.

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 woulds 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.

In the group project, we basically split out the works to be done. We helped each other along the way. I got to be the one who created, and inserted values for our tables in our MYSQL database. I turned the values that has been created by my team into queries and inserted the values into the database. I also did some of the coding part for our GUI.

I came up with the idea of making a platform jumping game as it seems to be simple to be played and young children should be able to play games like these. I then try to connect it to the aim of the game, which is to educate kindergarten children. Instead of using coins and uses them to unlock characters (like other platform jumping games) I decided to switch it to letters that will be merged into a word once all the letters are collected.

I started the game by making the first stage and the character movements along with its animation. Then I started making the menu and the level select part. Along the way, I tried making two characters so that players could choose which character they would like to use, but in the end after lots of scrambling around it seems like it causes error and makes the game broken. After trying and trying, I decided to remove the character selection part as I think that it has used a lot of my time that I could’ve used for something else. I then added music to the game and it’s finally done.

After the game was done, I thought that the game would run smoothly, but I was wrong. I continued to see bugs on the game and tried fixing it afterwards. It took me hours and hours trying to figure out how to fix this and how to fix that. As I work alone on this project, I usually ask help from my TA when I have problems that I couldn’t solve. I was pretty impressed with the final result, it was a very exhausting and interesting project after all

Genre: Platform “Jump” game

Game Guide:

Player has to collect letters which later on could be gathered to make up a word. Once it has merged, the word along with a picture will pop up in the screen. As the player collect letters along the game, the collected letters would pop up on top of the screen, giving clue of what is the end result of the collected letters. Player should not fall out of the screen or else its game over. There are 3 stages with 3 different levels of difficulty, 1 being the easiest and 3 being the hardest.

• 

• 

• 

• 

Controls:

All character movements are controlled using the arrow buttons on the keyboard. Mouse clicks are for clicking next button, level select, play button, etc.

Assets:

– Platform & Background

https://goo.gl/mBmVnH

– Letters

http://www.newdesignfile.com/post_font-styles-alphabet_44501/

– Buttons & GUI

https://goo.gl/WfFlCt

– Animal images

https://www.pngitem.com/middle/ioToxxi_transparent-dog-vector-png-dog-clipart-png-download/

http://clipart-library.com/clipart/clip-art-dog-22.htm

https://illustoon.com/?id=3354

https://creazilla.com/nodes/6274-wolf-clipart

https://www.jing.fm/iclip/bmbmm_tiger-clipart-jungle-animal-cute-tiger-head-clipart/

https://clipart.me/istock/cute-tiger-cartoon-342091

– Character

https://opengameart.org/content/toon-characters-1

– Music

https://www.youtube.com/watch?v=W9bqfTRm4AQ&list=PL9Awn3xplT3um3t3sevojRgrxkmUFmA35&index=24

Genre: Platform “Jump” game

Game concept:
Player has to collect letters which later on could be gathered to make up a word. Once it has merged, the word along with its definition will pop up in the screen.

• There are 2 characters that players could choose later on

• Character movements are controlled using the arrow buttons on the keyboard.
• it has a cartoon-theme background and display

Game rules:
Player has to stay inside of the screen or else it’s game over

Game aim:
to teach kindergartens new vocabulary. By collecting the letters one by one it also teach them to spell a certain. word. Lastly, they will figure out the meaning of the word while having fun in the process.