Interested to Buy Any Domain ? << Click Here >> for more details...
9)When information has to be stored w.r.t employees and
their respective departments, which of the following is the
Correct formulation of entries?
A)Employee and department would together be represented as
an entity.
B)This is too less information to decide on entities.
C)An employee would be one entity and a department would be
another.
D)Such a scenario cannot be modelled in RDBMS
- 2 Answers
- 5621 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mak
The answer is
An employee would be one entity and a department would be
another
| Is This Answer Correct ? | 2 Yes | 0 No |
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
what are the database links ?
What are the different types of partitions in oracle?
What is open database communication (odbc) in oracle?
without using count(*) and rownum how can we count total record in a table
How would you best determine why your MVIEW couldnt FAST REFRESH?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
what are the disadvantages of hierarchial database over RDBMS?
How to retrieve 5th highest sal from emp table?
Oracle General 
