Start Discovering Solved Questions and Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Illustrate stored procedures, and how do they are distinct from triggers?
Name four applications which are employing for triggers in DBMS?
Describe briefly the ‘paradigm mismatch’ among SQL and application programming languages.
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
What do you understand by the term cascading update in DBMS?
How can we handled are recursive relationships in a database design? Describe briefly?
Briefly define and describe the term data constraints?
Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?
Write down the steps for transforming an entity into a table?
Describe briefly the term recursive relationship? Comprise an appropriate example?
What is the archtetype or instance pattern?
Describe briefly three types of binary relationships in DBMS?
Describe briefly the difference between identifier and attributes?
Describe the relationship among entity, entity class, and entity instance.
Describe the inconsistent values problem? Comprise an appropriate example?
Why is the multi value or multicolumn problem any other type of the multivalued dependency problem?
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
Why do normalized tables need more complex SQL when SQL statements are employed in application programs?
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
What does it mean when we say that a relation is in Boyce-Codd Normal Form (BCNF)?
Illustrate briefly the term insertion and deletion anomalies?
What do you understand by the term foreign key in DBMS, and why is it employed for?
In which case the functional dependencies are not equations? Describe briefly?
Describe briefly the alternative terminology which is employed in the relational model?
Illustrate briefly the term SQL sub query?