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 external view
What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency
This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship diagrams. Draw a set of Entity-Relationship diagrams to mode
Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as
Describe the storage structure of indexed sequential files and their access method. Ans: Index offers a lookup capability to rapidly reach the vicinity of the desired record.
What is the need for triggers? Triggers are useful mechanisms for alerting humans or for starting particular tasks automatically when particular conditions are met.
What are the advantages and disadvantages of using a database system. Sol. Advantages of Database System (DBMS) : (1) Data Redundancy and Inconsistency: Since differen
What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,
Design a database for an airline.The database must keep track of customers and their reservations,flights and their status, seat assignment on individual flights and, the schedule
In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies. Determine the normal form of this table. Remember that the normal form is the HIGHE
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd