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 pl/sql code to generate Fibonacci Series and save the series into a table. 2. Generate Fibonacci Series using a PL/SQL user defi...
-
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
-
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...
-
Consider a binary relationship with M: N cardinality ratio. A supplier supplies many engineering parts , and a part is supplied by ma...
-
DBMS: Database management System is software, which is use for maintaining Database. Database System supports single-user and mult... -
Step 3: Create Table & Alter Table Step 4: Create Integrity Constraint Step 5: Insert values Step 6: See the inserted values ...
-
What is Distributed Database Management System ? A distributed database management system is a software system that permits the man...
-
SQL অপারেটর ওরাকল অপারেটর এর মাধ্যমে একটি বা একাধিক আউটপুট তৈরী করা যায় । একই ভাবে অপারেটর একটি অথবা একাধিক অপারেন্ড / ভ্যালু(মান) / ...
Total Pageviews
Followers
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