•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 391,624 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,700 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 3327 | Replies: 1
 |
•
•
Join Date: Sep 2006
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Employee Salary Database design. I am a developer creating a package for Employee.
Salary Slip maintenance creating problem means I am not getting ideas of create table.
Please help me to create table.
Salary of an Employee has following heads
* Consoldated Amt
* Additional Allowance
* Camp Allowance
* Vechile Allowance
* Servant Allowance
Tax / Reduction
* Profession Tax [ Change according to Govt. Rule ]
* Provident Fund[ Change according to Govt. Rule ]
[ Above * Fields are fixed means employee either get 0 or some amount in a month on these heads.
Below * Fields are optional. ]
Other Allowance
* One or More Allowances are given to an employee depending on satisfaction of an Employer
Bonus
* Yearly
pleaseeeeeeeeeeeeeeeeeeee help me:rolleyes:
Salary Slip maintenance creating problem means I am not getting ideas of create table.
Please help me to create table.
Salary of an Employee has following heads
* Consoldated Amt
* Additional Allowance
* Camp Allowance
* Vechile Allowance
* Servant Allowance
Tax / Reduction
* Profession Tax [ Change according to Govt. Rule ]
* Provident Fund[ Change according to Govt. Rule ]
[ Above * Fields are fixed means employee either get 0 or some amount in a month on these heads.
Below * Fields are optional. ]
Other Allowance
* One or More Allowances are given to an employee depending on satisfaction of an Employer
Bonus
* Yearly
pleaseeeeeeeeeeeeeeeeeeee help me:rolleyes:
•
•
Join Date: Oct 2006
Location: Maryland
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Look into to DB normalization. Standard procedure in design of relational DB tables. Normalization will help to define the assorted tables needed to effectively do the job. You then use the tools provided by the DB to create a table.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
•
•
•
•
avatar backup bcsd bcsm breach ccie certification cisco cissp comptia creative daniweb data protection database design government hacker howto ibm illustrator magazine medicine microsoft navigation news normalization photoshop print red hat research rhce salary security server sql survey toread tutorials web
- Database Design for storing versions (Database Design)
- Database Design feedback (absolute beginner here :) (Database Design)
- Help with contact/mailing list database design... (Database Design)
- Database design - subtypes and instances of an entity (Database Design)
- Database Design - Supertypes and Subtypes (Database Design)
- Database Design Advice (MySQL)
Other Threads in the Database Design Forum
- Previous Thread: database connectivity
- Next Thread: Help with student induction timetable database
