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
-
Write a program to check prime number using pl/sql
-
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...
-
(a) Consider the relational table given below and answer the following SQL queries. Think that the table has filled up by employee’s re...
-
Write a program to check prime number using pl/sql
-
What is Data Warehouse ? A Data warehouse is a repository of integrated information, available for queries and analysis. Data and ...
-
What is SQL? SQL stands for Structured Query Language. SQL is used to communicate with a database. According to American National Stan...
-
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) ...
-
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...
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