Eliminate repeating groups, Database Management System

Assignment Help:

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


Related Discussions:- Eliminate repeating groups

Database Management System, please give me introduction to full data in D B...

please give me introduction to full data in D B M S in a short assignment

Triggers and Stored Procedures, 10A.53 Code an Oracle Database trigger to e...

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet

Describe association design of an object, Describe association design of an...

Describe association design of an object by giving one suitable example of it. The Design of Associations Associations are "glue" of advanced object oriented analysis and

A database administrator'', A database administrator''s responsibilities an...

A database administrator''s responsibilities and data contents

Which is a valid sql type, Which is a valid SQL type? A valid SQL Shoul...

Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Differance between ddl and sdl, Differance between DDL and SDL? DDL and...

Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and

Search the name department number and salary of employees , Example : Searc...

Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

Write query to list the staff who work within the branch, Consider the foll...

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

The maximum no of key fields that can be used in a header, The Maximum no o...

The Maximum no of key fields that can be used in a header is?? 50

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd