NPTEL Data Base Management System week 3 Assignment 2024
1. Identify the cases below in which a trigger is not preferred to use.
a) Loading data from a backup copy.
b) Maintaining summary data.
c) Replicating updates at a remote site.
d) Enforcing database integrity.
Answer :- For Answers Click Here
2.
Answer :-
3.
Answer :- For Answers Click Here
4.
Answer :-
5. Consider the following scenario:
An Environmental resource management company keeps record of different forests, identified
by their names. A forest is associated with its location that contains the country and area
in which the forest is present. In each forest, there are different types of trees that are also
recorded by the company.
Which of the following schema correctly represents the Forest entity set?
a) Forest (Name, Location, Trees)
b) Forest (Name, Location, Country, Area, Trees)
c) Forest (Name, Location), Forest location (Location, Country, Area)
d) Forest (Name, Country, Area), Forest_trees (Name, Trees)
Answer :- For Answers Click Here
6.
Answer :-
7.
Answer :-
8. An entity in CUSTOMER entity set is associated with at most one entity in LOAN set. An entity
in LOAN, however, can be associated with any number (zero or more) of entities in CUSTOMER.
What is the cardinality of the relation between LOAN and CUSTOMER?
a) One-to-many
b) One-to-one
c) Many-to-many
d) Many-to-one
Answer :- For Answers Click Here
9.
Answer :-
10.
Answer :- For Answers Click Here
