Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
Database-name
1
Gurpreet Malhotra
2
Access
Faisal Khan
4
DB2
3
Manisha Kukreja
FoxPro
Sameer Singh
Oracle
explain participation constraints with examples
please give me introduction to full data in D B M S in a short assignment
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 by giving one suitable example of it. The Design of Associations Associations are "glue" of advanced object oriented analysis and
A database administrator''s responsibilities and data contents
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? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and
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
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 is?? 50
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd