MCA MAGADH UNIVERSITY QUESTION (2008-2011) (Third semester) DATABASE MANAGEMENT SYSTEMS

MCA MAGADH UNIVERSITY QUESTION (2008-2011) (Third semester) DATABASE MANAGEMENT SYSTEMS
MCA MAGADH UNIVERSITY QUESTION (2008-2011) (Third semester) DATABASE MANAGEMENT SYSTEMS

                                                                         2008-2011
                                                                      Full Marks: 80
                                                                      Time: 4 hours
                                                            Answers any five questions

1. (a) What are database system? Describe its characteristics. What are the functions of DBMS.
    (b) Explain the architecture of DBMS.

2. Write the limitations of E-R model. Construct an E-R diagram for a Hospital information system.

3. List the operations of relational algebra. Differentiate between cartesian Product and natural join operations used in relational algebra.

4. Consider the following tables:
     Employee (Emp_ id, Name, Phone _ number)
     Company (Emp_id, Company_ name, salary)
    (a) Write SQL command to create tables for Employee and company respectively.
    (b) Write SQL command to insert records into each table.
    (c) Write an SQL  query to display Employee name and Company name.
    (d) Write an SQL query to display Employee name, Employee phone_ number and salary  of all the employee whose salary > 2000.

  5. What are key and non- key attributes? Define primary key, candidate key and foreign key. Explain all keys with suitable example.

  6. a) What are functional dependencies? With a suitable example, explain the importance  of functional dependencies in database design.
     b) Explain 2NF and 3NF with suitable example.

7. What is transaction management? What are the ACID  properties of a transaction? why are these properties important? Give an example for each property.

8. a) What is database recovery? Why are backups important?
    b) Explain various recovery techniques during transaction in detail.

9. Illustrate the differences between hierarchical and network data models. Explain why relational data model is a better choice over the two.

10. State and explain the object - oriented data model using a suitable example.

11. What are the types of knowledge discovery during data mining? Explain with suitable example.

12. Write short notes on any four of the following:
      (a) Data Warehousing
      (b) HSAM
      (c) Views
      (d) Query processory
      (e) Data Manipulation Language (DML)
      (f) Data Definition Language (DDL)

Comments

Post a Comment

Popular posts from this blog

MCA MAGADH UNIVERSITY QUESTION (2015-2018) (Semester-iii) Database Management Systems

Image
MCA MAGADH UNIVERSITY QUESTION (2015-2018) (Semester-iii) Database Management Systems                                                                         2015-2018                                                                      Full marks: 80                                                                      Time: 4 hours                                                   The questions are of equal value                                                       Answer any five questions 1. Define database. What are its characteristics? Explain the different types of database users. 2. Explain ANSI SPARC architecture of database. Define mapping and explain the mapping between the three levels of database. 3. Describe the features of Oracle as an RDBMS package. 4. Explain the notational conventions used in the E-R model. Construct and E-R model for student administration system. Students who apply for a course are registered in the system. short listed candidates
Read more

MCA MAGADH UNIVERSITY QUESTION (2010-2013) (Fifth Semester) Artificial Intelligence and Application

Image
MCA MAGADH UNIVERSITY QUESTION (2010-2013) (Fifth Semester) Artificial Intelligence and Application                                                                         Time: 4 hours                                                                        Full Marks: 80                                                         The questions are of equal value.                                                             Answer any five questions. 1. Define artificial intelligence. Explain the importance of AI and also explain the related fields of AI. 2. Explain how the alpha-beta algorithm is a better way to search game trees. These two algorithms depend on certain assumptions about how the game is played? What are they? 3. What important knowledge products are currently being marketed like other commodities? What are some new knowledge products likely to be sold within the next ten years? 4. Write a LISP program to convert centigrade temperatures to Fahrenheit. 5. Exp
Read more

BCA MAGADH UNIVERSITY QUESTION (2011)

Image
BCA MAGADH UNIVERSITY QUESTION (2011)                                                                                 2011                                                                        Full Marks: 75                                                                         Time: 3 hours                                                         The questions are of equal value                                                 Answer five questions including Question 1                                                           Which is Compulsory 1. Choose the correct Answers:      (a) The OS that allows only one Program to run at a time is           (i) Batch Processing           (ii) real time           (iii) Multasking           (iv) None of these   (b) The directory structure used in windows is         (i) hierarchical         (ii) Flat         (iii) both (i) and (ii)         (iv) None of these  (c) An imaginary memory supported by the OS in conjunction wi
Read more