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

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

what is database management system? & why it is required?

Illustrate the State model for the ATM class let us take state model for the ATM class given below in Figure showing state model of the ATM class and the pseudo code derived fr

management information system based on functional organisation

1.  Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table (as shown in class).  Label the types of depe

XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

Structure Of Distributed Database: A distributed database system haves of a collection of sites, each of which keeps a local databases system. Every site is able to process local

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

Explain group By clause in SQL? Group By clause in SQL: The GROUP BY clause can be used in a SELECT statement to collect data across multiple records and group the results thro