Project Manual

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.

Main Menu of The GUI
Modifying Employee Table
Viewing The Employee Table
Inserting A New Item To The Employee Table
Updating The Item’s Gender To FEMALE In The Employee Table
Deleting The Newly Inserted Item In The Employee Table
Viewing And Modifying The Customer Table
Inserting A New Item To The Customer Table
Updating The Item’s Last Name To John In The Customer Table
Deleting The Newly Inserted Item In The Customer Table
Viewing And Modifying The Supplier Table
Inserting A New Item In The Supplier Table
Updating The Item’s Total Payment To 4 In The Supplier Table
Deleting The Newly Inserted Item In The Supplier Table
Viewing And Modifying The Book Table
Inserting A New Item In The Book Table
Updating The Item’s Stock Num To 4 In The Book Table
Deleting The Newly Inserted Item In The Book Table

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.

Posted in Database Systems | Leave a comment

My Contributions In The Database Systems Final Project

In the project our group just generally split the workload equally, we just tend to help each other to finish one the before the proceeding. For what I did during the project, I made some of the initial content for all of the tables, we first put it in an excel file and then implement it in to the MySQL.

Invoice Table In Excel For Example

Then I also help in the coding of the GUI. And I also help in making the Project Manual.

Posted in Database Systems | Leave a comment

Database Systems Final Project Proposal

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.

Posted in Database Systems | Leave a comment

My Contribution To The Game

So what I did was I gave the ideas of what obstacles the player need to face, and how each level should be. I also narrated the game to guide the player on the task they need to do. I needed to do alot of takes for the narration because I kept on twisting my tounge and mess up the whole sentance, and also trying to come up with different level puzzel and obstacles for kindergarten children, cause I was not sure if it is too difficult or too easy for them. But in the end I fell like I have successfully put my contribution to the game.

Posted in Uncategorized | Tagged | Leave a comment

Guide To The Game

So, the game that me (Raffles Teh Weihan), Nathan Setiawan, Edsel Putra Harren created is called Robert’s Great Big Adventure.

The main menu of the game.

So the main objective to the game is the player, playing as Robert the robot, finds a matching key to the lock in order to open a door to proceed to the next level/room to the end of the game.

The start of the game, in a test room to fulfill the objective.

The player will be controlling the robot using the arrow keys, and in order to pick up the key the player must move the robot near to the key and would automatically pick the key up, and in order to put the key in the lock the player just need to walk to the lock at it will be automatically placed to the lock.

Player pick up key.
Player put key into lock to oprn door.

Nathan was the one that made the sprits and the visuals of the levels, Edsel was the one that provides the sound effects and the back ground music of the game, I was the one that did the narration of the game and the level idea.

Posted in Uncategorized | Tagged | Leave a comment

Post For Game Project

So this is a game project that was made by 3 people, Nathan Setiawan, Edsel Putra Harren, and myself (Raffles Teh Weihan). So the main genre of this game is that it is an 8bit puzzle game, that follows the concept of lock and key. We made the puzzle concept easy because our targeted audience are kindergarten children. The title ,of the game, that we agreed upon is RGB, or it’s full tittle Robert’s Great Big Adventure. As you can probably recognize, the tittle is a play in words with the basic computer colours RGB (Red, Blue, Green), and since we made the game coloured base, I really think the title really suits the game. So the story of the game is that scientists are trying to experiment on the intelligence of Robert, the robot that the scientist made, by running some basic test to see if they understand colour coordination. So the player will be playing as Robert the robot in a insane looking laboratory, with different types of platform trying to hinder Robert’s progress, and Robert must bing the specific coloured key to the corresponding lock. The aim for this game is trying to help the children to understand about colour coordination.

Posted in Uncategorized | Tagged | Leave a comment