Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2007 M.Sc Information Technology MT0034 – DBMS and SQL Server -2009 fall session - Assignment s - Question Paper

August 2009
Master of Science in info Technology (MScIT-NEW) – Semester 1
MT0034 – DBMS and SQL Server – four Credits
(Book ID: B0068 & B0145)
Assignment Set – one (40 Marks)

Answer All the ques.

Note: every ques. carries 10 Marks

B0068:

1. Discuss the advantages of relational model compared to hierarchical and network models

2. Discuss the kinds of privileges at the account level and those at the relational level

3 With an example of your own, discuss all the operators of relational algebra


B0145:

4. discuss the subsequent with an example
• Table Creation
• Altering a Table













August 2009
Master of Science in info Technology (MScIT-NEW) – Semester 1
MT0034 – DBMS and SQL Server – four Credits
(Book ID: B0068 & B0145)
Assignment Set – two (40 Marks)

Answer All the ques.

Note: every ques. carries 10 Marks

B0068:


1. What are the services given by a data base system?

2. Explain the purpose data modeling. elaborate the basic constructs of E-R Diagrams?

3. explain the subsequent kinds of joining tables

? EQUIJOINS
? NATURAL JOINS
? NON-EQUIJOINS

B0145:

4. Write about:
• SQL Server 2005 System Tables and Views
• Information Schema

Earning:   Approval pending.