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
Describe Database state in details? Database state: The actual data within the database at a particular moment in time is known as a database state.
What is a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in
How can you connect to the MySQL Server? In order to connect to the MySQL server it is necessary to give the username and password so this be able to done with The following
What is advantage of two-way association? Two-way association advantages are following: a) Independent of the classes. b) Useful for existing predefined classes that are
What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among
List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements c) Finding the loops d) Finding error ro
Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper
Define a relation ? Relation - A relations is a named two-dimensional table of data. Mathematically, a relation can be described as a subset of the cartesian product of a lis
There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes
Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi
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