A                  is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

Related MCQs

• Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
• Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
• A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
• A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
• The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):