Home » SQL & PL/SQL » SQL & PL/SQL » payroll management system
payroll management system [message #7163] Sun, 25 May 2003 23:47
Sub
Messages: 2
Registered: May 2003
Junior Member
Hi Everybody,
I am looking for a simple payroll management system in Oracle PL/SQL for my university assignment.
The report should have
1.db design(ER diagram) with primary key,foreign key
2.relatiionship between tables
3.minimum of 3 tables
4.ddl,dml commands used in project
5.processing logic used for computation of data
6. reports

create table
insert test data in table
update values
modify alter table columnsquery tables with various combinations
query table with parent child relationss
write function procedure to do meaning ful data processing
write pl sql procedures for reports

Thank you
Previous Topic: Copying DB files
Next Topic: how to use os command in pl/sql programme
Goto Forum:
  


Current Time: Thu Mar 28 23:46:31 CDT 2024