Database Management Systems 10CS54 VTU notes

View note:Database-Management-Systems---10CS54-VTU-notes



Questions of this subject!.

QuestionLikes!Dislikes!Answers!
database management system

001
What is relational algebra in dbms ?

002
What is a Table in a database ?

102
Define the following terms: Database Management Systems - 10CS54 VTU notes 20 Marks (Jun/July 2013/June 2016)

001
Explain the characteristics of data base approach. Database Management Systems - 10CS54 VTU notes 4 Marks (Jun /July2014/June/July 2015)

001
What are the responsibilities of a data base administrators. Database Management Systems - 10CS54 VTU notes 4 Marks (Dec/Jan 2014, Jun / July2013)

001
Explain the typical components of a DBMS with a neat diagram. Database Management Systems - 10CS54 VTU notes 8 Marks (Dec /Jan 2013, Dec/Jan 2014, Dec2014/Jan2015)

001
Define and explain the following terms with an example for each. Database Management Systems - 10CS54 VTU notes 8 Marks (Dec /Jan 2013, Jun / July2014)

000
Discuss the main Characteristics of the database approach . Database Management Systems - 10CS54 VTU notes . 8Marks (Jun / July 2013, Jun / July2014)

001
Explain the difference between Logical and physical data Independence? Database Management Systems - 10CS54 VTU notes 8 or 10 Marks (Jun / July 2013/Jan 2016)

000
Define the database and briefly explain the implicit properties of the database? Database Management Systems - 10CS54 VTU notes 4 Marks (June/July 2015)

000
Define the following with examples: Database Management Systems - 10CS54 VTU notes 10 marks (Dec 14/Jan 15)

000
List the summary of the notations for ER diagrams. Include symbols used in ER diagram and their meaning. Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July2014/Jan 2016)

000
Explain hoe role names are assigned in case of recursive relationships? Illustrate this concept with an example. . Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July 2013/Jan 2016)

000
What is meant by partial key? Explain. Database Management Systems - 10CS54 VTU notes 4 Marks (Jun / July2014)

000
Define an entity and an attribute,explain the different types of attributes that occur in an ERdiagram model,with an example Database Management Systems - 10CS54 VTU notes 8 Marks (Dec /Jan 2013, Dec/Jan 2014)

000
Define the following with an example. Database Management Systems - 10CS54 VTU notes 20 Marks (Jun/July 2013 & June/July 2105)

000
Design an ER Diagram for keeping track of Information about Bank Database,Taking into account 4 entities? Database Management Systems - 10CS54 VTU notes 8 Marks (Dec /Jan 2013/June 2016)

000
Define and explain Partial Key, with example? Database Management Systems - 10CS54 VTU notes 4 Marks (Dec/Jan 2014, Jun / July2013)

000
What is meant by recursive relationship? Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July 2013/June 2016)

001
) Draw the ER –diagram of musician who performs for album : Database Management Systems - 10CS54 VTU notes . 8 Marks (Jun / July2014)

000
Design an ER diagram for an insurance company. : Database Management Systems - 10CS54 VTU notes 10 marks (June/ July 2015) (Dec 14/Jan 15)

000
What are structural constraints on relationship types? : Database Management Systems - 10CS54 VTU notes 10 Marks (Dec 14/Jan 15)

001
) Define the following terms with an example for each? : Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July2014)

001
Explain the following terms : Database Management Systems - 10CS54 VTU notes 8 Marks (Dec/Jan 2014)

001
) Define referential integrity constraint. Explain the importance of referential integrity constraint. : Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July 2013) (5 Marks Dec 14/Jan 15)

001
What is valid state and an invalid state, : Database Management Systems - 10CS54 VTU notes 4 Marks (Dec/Jan 2014, Jun / July2013)

000
Explain Foreign key and its importance.?: Database Management Systems - 10CS54 VTU notes 8 Marks (Jun / July 2013)(10 Marks Jan 2016)

001
How an Intersection Operator can be implemented using Union and Minus operator? : Database Management Systems - 10CS54 VTU notes 8 Marks (Jun/July 2013/June 2016)

000
Write queries in Relational Algebra? Database Management Systems - 10CS54 VTU notes 8 Marks (Dec /Jan 2013/June 2016)

001
Briefly discuss how the different update operations on a relation deal with constraint violations? : Database Management Systems - 10CS54 VTU notes 8 marks (June/July 2015)

001
How does SQL inplement the entity integrity constraints of relational Data Model? Database Management Systems - 10CS54 VTU notes 4 Marks (Dec/Jan 2014, Jun / July2013)(8 marks Dec 14/Jan 15)

001
How does SQL inplement the entity integrity constraints of relational Data Model? Database Management Systems - 10CS54 VTU notes 4 Marks (Dec/Jan 2014, Jun / July2013)(8 marks Dec 14/Jan 15)

000
the basic constraints that can be specified, when you create a table in SQL. Database Management Systems - 10CS54 VTU notes 4 Marks (Jun / July2014/June 2016)

001
Explain how groupBy clause works?What is the difference between WHERE and Having? Database Management Systems - 10CS54 VTU notes 8 Marks (Dec/Jan 2014 & June/July 2015)

001
Explain all possible options that are specified Database Management Systems - 10CS54 VTU notes 8 Marks (Jun/July 2013, Jun / July2014)

005
Write queries in SQL for the following Database Management Systems - 10CS54 VTU notes 8 Marks (Dec /Jan 2013, Dec/Jan 2014/June 2016)

001
Given the schema for the following Database Management Systems - 10CS54 VTU notes 12 Marks (Dec 14/Jan 15)

001
Explain insert, delete and update statements in SQL with example. Database Management Systems - 10CS54 VTU notes 8 Marks (Dec/Jan 2013 & June/July 2015)

001
Write a note on aggregate functions in SQL and Views in SQL with examples. Database Management Systems - 10CS54 VTU notes 4 Marks (Jun / July2014 & June/July 2015)

001
How is a view created and dropped? Database Management Systems - 10CS54 VTU notes (Dec 11/Jan 12)(6 marks Dec 14/Jan 15)

001
What is embedded SQL? With an example explain how would you Connect to a database, fetch records and display Database Management Systems - 10CS54 VTU notes . (Dec 11/Jan 13/ Jan 2014) (10 marks Dec 14/ Jan 15)

000
Explain the syntax of a SELECT statement in SQL. Database Management Systems - 10CS54 VTU notes (MAY/JULY 2013/ 2014) (4 Marks Dec 14/Jan 15)

001
List the approaches to DB Programming. Database Management Systems - 10CS54 VTU notes . (Dec /Jan 11/ Jan 2014)

001
What is Impedence Mismatch problem? Database Management Systems - 10CS54 VTU notes (Dec 12/Jan 13/Jan 2016)

002
Discuss the significance of assertion? Database Management Systems - 10CS54 VTU notes (DEC/JAN 2013/ JAN- 2014)

001
What is Impendence Mismatch?Database Management Systems - 10CS54 VTU notes (DEC/JAN 2013/June 2016)

000
What is the need for normalization?.Database Management Systems - 10CS54 VTU notes (JUN/JULY 2013/Jan 2016)

001
Explain informal design guidelines for relation schemas. Database Management Systems - 10CS54 VTU notes (Dec /Jan 12/Jan 2016)

001
what is the need for normalization ? Database Management Systems - 10CS54 VTU notes ( Jan 2013/June 2016)

001
Explain any Two informal quality measures employed for a relation schema Design? Database Management Systems - 10CS54 VTU notes ( Jan 2013/June 2016)

001
Consider the following relations: Car_sale (car_no, datesold, salemanno, commission%,discount). Assume a car can be sold by multiple salesman and hence primary key is {car-no, salesman} additional dependencies are: Date-sold discount and salesmanno. Commission? Database Management Systems - 10CS54 VTU notes (JAN -2014)

000
Differentiate between Prime and Non-prime attributes? Database Management Systems - 10CS54 VTU notes (DEC/JAN 2013/June 2016)

001
Explain lossless join property. Database Management Systems - 10CS54 VTU notes (Dec /Jan 12/Jan 2016)

001
) Explain lossless join property Database Management Systems - 10CS54 VTU notes (MAY/JULY 2013/Jan 2016)

001
What is Multivalve Dependency Database Management Systems - 10CS54 VTU notes (Dec /Jan 11/Jan 2016)

001
Which Normal form is based on a concept of MVD?Database Management Systems - 10CS54 VTU notes (Jan 2013/July 2013/Jan 2014)

001
Explain Fifth Normal Form Database Management Systems - 10CS54 VTU notes (JUN/JULY 2013/June 2016)

001
Explain properties of a transaction ?Database Management Systems - 10CS54 VTU notes (JUN/JULY 2015)

001
What is a schedule? . Database Management Systems - 10CS54 VTU notes (JUN/JULY 2013/Jan 2016)

001
Write short notes on Database Management Systems - 10CS54 VTU notes (Jan 2013/Jan2014/June 2016)

001
Explain the problems that can occur when concurrent transaction are executed give examples. Database Management Systems - 10CS54 VTU notes (JULY 2013/ Jan 2014/July 2015)

001
What is Serializibility?How can seriaizability?Justify your answer? Database Management Systems - 10CS54 VTU notes (Dec 11/July 13/ JAN 2014)

001
. Write a short Notes Database Management Systems - 10CS54 VTU notes (Dec /Jan 11/Jan 2016)

001

Not the question you are looking for? Ask it here!

Join eduladder!