Model Question Paper of Web Database and information system

                             Web Database and information system                        

      Full Marks: 60                       Course no: CSC-409                                        Pass Marks: 24

             Attempt any ten questions                                                                  (6*10=60)                    
                 1.      A college office maintains data about the following entities:
                     (a)courses including course number, title and credits;
                     (b) course offerings, including course number, year, semester, section number,                                           instructor(s),timings, and classroom;
                     (c) students, including student-id, name, and program; and 
                     (d) instructors, including identification number, name, department, and title.

  Construct an E-R diagram for the college’s office. Document all assumptions that       make about the mapping constraints.

2.       Explain the basic relational algebra operations with symbols and examples.

3.      Consider the database given by the following schema

Customer (cust_no,sales_person_no,city)

Sales_person (sales_person_no,sales_person_name,join_date)

Write SQL statements for each of the following queries

a.      Display the list of all customers by cust_no. with the city in which each is located.

b.      List the name of the sales person who have account in Mahendranagar.

4.      What is an integrity constraint? Explain referential integrity with example…

5.      Describe the term MVD in the context of RDBMS with example.

6.      What do you mean by object structure and object class? How inheritance is implemented in object oriented data model? Explain with example.

7.      What are the new challenges in implementing ORDBMS? Explain briefly.

8.      Explain document type definition (DTD) with example in reference to XML standard.

9.      What is RAID? What are different RAID levels? Explain briefly.

10.  Differentiate between client-server and distributed database architecture.

11.  What is java servlet? Write a servlet code that creates communication between web server and application program of your choice.

12.  What are the main issues involved in the storage and retrieval of data for data support system (DES)?