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
-
Write a program to check perfect number using pl/sql
-
(a) Consider the relational table given below and answer the following SQL queries. Think that the table has filled up by employee’s re...
-
A binary relationship with 1:1 cardinality ratio, an employee can have one car and a car is used by one employee only. Do the following a...
-
Write a program to check perfect number using pl/sql
-
Write a program to check prime number using pl/sql
-
Write pl/sql code to generate Fibonacci Series
-
Aggregate Functions Aggregate functions return a single result row based on groups of rows, rather than on single rows. Aggregate funct...
-
▼ 11 (3) ▼ 10/16 - 10/23 (1) DAY-1: THE SQL ▼ 10/23 - 10/30 (1) DAY-1: EXAMPLE-1 ▼ 11/27 - 12...
-
Design a complete schema with relational diagram for the following situation: An organization has two types of employees, salarie...
-
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...
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