Eliminate repeating groups, Database Management System

Eliminate Repeating Groups

The problem is, "Find out the list of employees, who knows DB2".

For this problem we require to perform an awkward scan of the list looking for references to DB2. This is ineffective and a very untidy way to retrieve information.

We change the relation to 1NF. Please note that in the Department-loc fields and conversion Department will be part of Employee relation. The Emp-ID in the Database relation matches the primary key in the employee relation, giving a foreign key for relating the two relations with a join operation. Now we can response the question by looking in the database relation for "DB2" and getting the list of Employees. Please note that in this design we require not add D-ID (Database ID). Just the name of the database would have been sufficient as the names of databases are original.

Employee Relation

 

 

Database Relation

Emp-ID

Emp-Name

D-ID

Emp-ID

Database-name

1

Gurpreet Malhotra

1

2

Access

2

Faisal Khan

2

4

DB2

3

Manisha Kukreja

3

3

FoxPro

4

Sameer Singh

4

1

Oracle

 

4

4

Oracle

Posted Date: 3/7/2013 2:26:24 AM | Location : United States







Related Discussions:- Eliminate repeating groups, Assignment Help, Ask Question on Eliminate repeating groups, Get Answer, Expert's Help, Eliminate repeating groups Discussions

Write discussion on Eliminate repeating groups
Your posts are moderated
Related Questions
Define Join and Outer Join and differentiate between them.      Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition.  Oute

Question: (a) What is ODBC and what is its function? (b) What is Web application server, and how does it work from a database perspective? (c) What does e-commerce mean

Briefly explain the state diagram by taking one example. State Diagram - An object can be given a sequence of input instructions. The state of the object can vary depending u

All edges of a cube are expanding at a rate of 6 centimeters per second. How fast is the surface area changing when each edge is (a) 2 centimeters and (b) 10 centimeters?

Performance of Various Concurrency Control Mechanisms

Explain the concept of deadlock Yes. It can direct to deadlock. Suppose that a batch of frames arrived correctly and were accepted. Then receiver will advance its window. Now s

What is view in SQL? How is it defined? Any relation that is not part of the logical model, but is made visible to a user as a virtual relation is known as a view. We descri

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

WHY SHOULD NULL IN A RELATION BE AVOID AS possible?

Question: (a) Use the following business rules to produce the E-R diagram. You should clearly show all the minimum and maximum cardinality constraint on each side of the relati