For this database project, I contributed in the makings of the ERD. After making the ERD, I used Jason C’s mysql server to make the database and tables using DDL.
Then, I made the query functions so that it can be connected to the flask applications.
When the final project was first assigned to our group, we decided to immediately brainstorm on some ideas that our relevant to what is required from it. We were quite ambitious at first as in to make a larger scale database for a large business, such as a supermarket or a sports store. But in the end, we decided to scale down and go for either a salon, shipping service or a news outlet. We found that making a database for a salon is much more doable than the rest, plus we could attribute most of the time emphasizing on the details. The group members for this project are Monique Senjaya, Jason Jeremy Wijadi, and Christopher Tendi. We decided to code a web app and it will be called Sigma Salon! Sigma Salon is a web app designed to manage a pseudo salon database. The database contains 7 tables in order to store data on customers, staff, services, appointments, salary, appointments branch and person. The application will be created using Python using the Flask module and MySQL as the DBMS.
Genre: Typing Game
My team (Ardelia, Monique) is planning to create a kindergarten game that aims to introduce kindergartens to typing in keyboards.
Getting familiar with the key placement, and typing in general, is important to be learnt at a very young age. However, a lot of people still overlook this skill.
Game Concept
Through our game, the kindergartens will not only learn to type, they will also be able to differentiate different types of animals and how to spell them (Alphabets), how to do addition and subtractions with the aid of pictures of animals (Numbers), and also spell out/differentiate different colours of the animals on screen (Colours).
Game Modes
Alphabets
– Pictures of an animal and the word (colour: white) will appear on screen. User will have to press the keys in order to highlight the letter. Once all the letters are highlighted, the next word and animal will appear.
Numbers
– random + and – equations will appear on screen, including the numbers and animals (amount of animals vary according to the numbers in the equation). Users will type in the number and try to count up the result. Once they get the result, they need to type the number in, then the game will give another set of new, randomized, equation.
Colours
– A name of colour will appear on screen, including the animal with the corresponding colour. Similar to the alphabets, users need to type in the correct order of spelling of the colours. When each correct key is pressed, the white letter will be coloured according to the corresponding colour.
Conclusion
Our game aims to teach them to get used to the key placement and at the same time also cover common kindergarten categories such as “Alphabets”, “Colours”, and “Numbers”. We plan to do this by using an intriguing theme, “Animals”, as the learning object.
Our game, will surely be family-friendly and is designed to catch the attention of kindergartens to prevent boredom.
Note: This proposal is our initial plan of the game and it might change over the course of development.
Proposal by Monique Senjaya and Ardelia Araminta
Hi, this is my first post for the blog, stay tuned for other updates on my journey being a computer science student in Binus International.