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
What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa

Consistency: This property makes sure that a complete transaction implementation takes a database from one consistent state to another consistent state. If the transaction fails e

Discuss how the one-to-one associations have to be implemented. Some of properties of associations can be implemented directly by providing suitable declarations of the data me

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Consider the following relations: BRANCH( bno, street, area, city, pcode, Tel_no, Fax_no) STAFF( Sno, Fname, Lname, address, position , salary, bno) Express the subsequent qu

What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log.            Ans:  The system log, which is generally writt

Define Signal. It allows methods to respond to events triggered by themselves or by other processes. Each signal corresponds to an exacting event. A signal is represented in Sy

Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte

ER diagram on cosmetics

In an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the