logo

Expense Tracker Database Design

   

Added on  2019-09-21

3 Pages439 Words282 ViewsType: 282
 | 
 | 
 | 
Problem analysis and descriptionI assumed myself as professional. My assumed problem is to deal with the daily home basedexpenses and how I can save money monthly or daily bases. This database design solve myproblem. I have created three table one table represent the expense category on which I spentmoney. These expense category can be increases by in future that is why I have created this asseparate table. The second table is designed to store the day, month, year and the total amountof expense according to each expense category. According to this table design I am free toenter record on daily basis or on monthly basis or year basis so this removed my headache tomaintain data according to particular period of time. I have created one more table that is thirdtable in which I can store details of salary and saving. In this table user have to enter the day,month, year and the monthly salary and monthly saving amount. Again this design makes freeuser to enter data on daily or monthly or yearly basis this is his/her own choice how they wantto maintain their records. This type of database give freedom to user. User can save moneyaccording to particular days interval it may be 10 or 15 it is totally depends on user choice. Database Schema1.expenseCategory(expenseTypeID, expenseType)2.expenseDetails(id,expenseTypeID,day,month,year,totalAmount)3.monthlySaving(id,day,month,year,monthySalary,savingAmount)
Expense Tracker Database Design_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Enforcement of Partial Referential Integrity in a Database System | Critique
|4
|603
|21

NoSQL Database: Key-Value, Document-Based, Column-Based, Graph-Based
|11
|689
|420

The Other Sources of Finances
|10
|2705
|26

Development of Project Management System
|6
|758
|43

Nature of environmental problems PDF
|9
|2244
|45

TRA Race Entry System Author: Name + Number.
|7
|471
|85