Home » SQL & PL/SQL » SQL & PL/SQL » payroll management system
payroll management system [message #7161] Sun, 25 May 2003 23:39
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: Several sql commands in one script file
Next Topic: Copying DB files
Goto Forum:
  


Current Time: Fri Apr 26 06:07:42 CDT 2024