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.
Home / Index Page
Subscribe to:
Post Comments (Atom)
Pages
- Home
- Inner Query
- Delete Duplicate Rows
- Error 6 initializing SQL*Plus
- How to unlock user or scott account in oracle
- Query for a Relational Banking Enterprise
- Design a Relational Database for Bank Emoployees
- Construct sql for an accident management database
- Design a Database for Student's course wise marks ...
- find missing values
- Inventory System for a Shopping Mall
- Create a Result database using Oracle PL/SQL
- Before Insert Trigger
- Result Entry system under a Client-Server archite...
- Cursor Details in pl/sql in oracle
- Stored Procedure in pl/sql in oracle
- Introduction to Directory Services and Directory Server
- Nested Sub Query
- What Is Database Design And What Are The Factors To Consider?
- MBA MIS Study Link : Spring 2019
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
-
DBMS: Database management System is software, which is use for maintaining Database. Database System supports single-user and mult... -
1. Write a program to count the prime number from previously stored values in a column of a table using pl/sql
-
Home Page/Index Oracle SHUTDOWN Summary : in this tutorial, you will learn how to use the Oracle SHUTDOWN statement to shut down t...
-
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...
-
1. Write a program to display all the perfect number from a column of a table. Use Cursor and User defined function.
-
Write a program to check perfect number using pl/sql
-
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 ...
-
Student Table Key word: Select, Create, Insert Schema: Entity/Field Name Data Type Student_id Number(10) ...
-
1. Create User : নতুন ইউজার তৈরি করা কেবলমাত্র ডাটাবেজ প্রশাসক ( system user ) কোন নতুন ইউজার তৈরি করতে পারে । ওরাকল ইনস্টল করার সময় স্...
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
Enroll today to get free access to our live demo session which is a great opportunity to interact with the trainer directly which is a placement based Salesforce training India with job placement and certification . Get salesforce training in affordable cost from a best computer institute.
ReplyDelete