Design a complete schema with relational
diagram for the following situation: An organization has two types of
employees, salaried and wage earning. Both the types of employees have some
common properties, such as employee code, employee name, and employee address.
However, the salaried employees have other additional properties: basic,
allowance, and House Rent Allowance (HRA). The wage earning employees have
distinct properties that are daily wage and overtime. You have to add
additional table, if required, which is not mentioned above.
Database Design Techniques using PL/SQL in ORACLE
Subscribe to:
Post Comments (Atom)
Labels
attribute
(2)
basic structure
(1)
begin
(2)
binary
(1)
cardinality
(2)
clause
(1)
client server
(1)
columns
(1)
constraint
(1)
create
(1)
data
(1)
data staging
(1)
data storage
(1)
data type
(1)
database
(3)
database models
(1)
dbms
(3)
dbms_output.put_line
(3)
ddbms
(1)
declare
(2)
dependent
(1)
directory service
(1)
distributed dbms
(1)
else
(2)
employee
(1)
employee information
(1)
end if
(2)
end loop
(2)
entity
(2)
exit
(3)
Fibonacci
(1)
Fibonacci series
(1)
field
(1)
first normal form
(1)
for
(2)
for loop
(2)
foreign key
(1)
from
(3)
if
(3)
informix
(1)
insert
(1)
itu
(1)
ldap
(1)
loop
(1)
metadata
(1)
mod
(1)
multi-valued dependencies
(1)
normalization
(1)
object
(1)
object base logical model
(1)
osi
(1)
perfect
(2)
perfect number
(2)
pl/sql
(4)
plsql
(1)
prime number
(4)
program
(2)
query
(1)
rdbms
(2)
record
(2)
record based logical model
(1)
relationship
(1)
reporting
(1)
rows
(1)
schema
(2)
select
(3)
sql
(3)
strange number
(1)
sybase
(1)
table
(5)
warehouse
(1)
where
(1)
while
(1)
Popular Posts
-
1. Write a program to display all the perfect number from a column of a table. Use Cursor and User defined function.
-
1. Write a program to count the prime number from previously stored values in a column of a table using pl/sql
-
1. Write pl/sql code to generate Fibonacci Series and save the series into a table. 2. Generate Fibonacci Series using a PL/SQL user defi...
-
Write a program in PL/SQL to Calculate Grade, GPA and CGPA after considering a result table where subject wise marks are inserted by c...
-
Consider a binary relationship with M: N cardinality ratio. A supplier supplies many engineering parts , and a part is supplied by ma...
-
Write a program to check perfect number using pl/sql
-
What is Data Normalization ? Normalization is the process of efficiently organizing data in a database. There are two goals of ...
-
What is Directory Service ? A directory service is a software application — or a set of applications — that stores and organizes...
-
Student Table Key word: Select, Create, Insert Schema: Entity/Field Name Data Type Student_id Number(10) ...
-
Design a complete schema with relational diagram for the following situation: An organization has two types of employees, salarie...
https://www.dropbox.com/s/fd2snunqd0tq3mq/Lab%209.pdf?dl=0
ReplyDeletehttps://www.dropbox.com/s/2ob9mblf17k4dyl/lab%2009.docx?dl=0
ReplyDeletehttps://www.dropbox.com/s/8t2358elk866345/Lab_9.docx?dl=0
ReplyDeletehttps://www.dropbox.com/s/3gla0xg8dnf62yg/LLL09.docx?dl=0
ReplyDeletehttps://www.dropbox.com/s/h1deuymka9oi984/lab-9.zip?dl=0
ReplyDeletehttps://drive.google.com/file/d/0B0biE39CX7WnVEFBRFQ1dnhOazA/view?usp=sharing
ReplyDeletehttps://drive.google.com/drive/folders/0B7CJXGLcBeZGWENkaENwLTBkSkU
ReplyDeleteRevise
ReplyDeletehttps://drive.google.com/open?id=0B0biE39CX7WnNW5OUGJ2bU9Eb00