AY1516 T2 Team13 Natasha Studio Findings Database
| EXPLORATORY DATA ANALYSIS | OTHER ANALYSIS | DATABASE CREATION |
|---|
Contents
SQLite database
Without the help of a 3rd party user interface (UI) program, SQLite runs mainly using command prompt commands. The team feels that this would be non-intuitive for the user and hence not user friendly. Therefore, the team has decided to use SQLiteStudio as the main UI. SQLiteStudio allows users to perform create, read, update, delete (CRUD) functions using either SQL or the UI. It also allows us to import and export databases or tables in .csv format. Most of the functions are available in the form of a UI, thus prior knowledge of SQL required in order to configure the database is kept to a minimal.
SQLite Entity Diagram
When creating the tables and its columns, we took into consideration the historical records so as to keep as close to the as-is situation as possible. We are still in the midst of discussing certain naming conventions with our client.
Table Description
Daily Class
Contains the records for all the classes that is held daily
All Class
Contains the records for all types of classes that is held in the studio since its inception
Instructor
Contains the data for the instructors that holds classes in the studio
Member
Contains the data for Natasha Studio’s customers
Package
Contains the records of all the packages that is available for purchase
Attendance
Records the members that attended classes in Natasha Studio, along with the package that the member is currently using.
PackagePurchase
Contains records for day-to-day sales during working hours
