Explain the representation of a one-to-many strong entity relationship in a relational database design.
Latest Answer: Department-Employees Under one Department many employees are working.Project-Employees ...
What is an intersection table and why is it important?
Latest Answer: A table added to the database to break down a many-to-many relationship to form two one-to-many relationships ...
Why is the choice of primary key important and are three characteristics of an ideal primary key?
Latest Answer: Primary key will let the retrieval operation to be fast.It will not allow you to insert duplicate and null values.It is used to uniquely identify a row in a table. ...
Discuss the difference between unique and non-unique keys
Latest Answer: Unique - Take for example employee table, it has column empno which is called as unique key where as non-unique key is column workdept, i.e when we do relationship between two tables as employee & department tables, dept. table also contains deptno as ...
Name three activities involved in requirement gathering
What is meant by type of participation? Name the three types of relationship participation.
Latest Answer: I just know two types of Participation: Total and Partial.Lets take an example of 2 entities Department and Employee.
Relation: For each department there is an Head of the Department (who is an employee again). (Dept-Head-of-emp)So now for this relation ...
List the rules used to enforce table level integrity.
What is the degree of relationship? Name the three degrees.
Latest Answer: It basically represent the number of entities participating in relation. ...
Show the basic architecture of Data Warehouse and briefly describe its components.
Differentiate between Microsoft and Oracle's XML technology support for database.
View page << Previous 1 [2] 3 4 5 6 7 Next >>
Go Top
