AIOU-Course: Database-I (3410) Semester: Autumn 2018 Level: BS (CS)

Course: Database-I (3410)    Semester: Autumn 2018

Level: BS (CS)    Total Marks: 100

        Pass Marks: 50   

ASSIGNMENT No. 2

        Total Marks: 100

        Pass Marks: 50

Note: All questions are compulsory. Each question carries equal marks.

Q. 1    (a)    Briefly explain the term normalization. And apply normalization on a real life example. 
Also write down the importance of normalization.

    (b)    What is an anomaly?  Explain inset, delete and update anomaly with a suitable example.  (20)

Q. 2    (a)    Differentiate data administrator and database administrator. Also write down the 
responsibilities of each in detail.    (20)

    (b)    Write down the steps to create a simple form application to maintain information of 
employees of a company.   

Q. 3    Describe the following SQL commands with a suitable example:    (20)

    Select, Where clause, order By, Insert Into, Update and Delete, Like, Between, SQL Joins 
(Inner, Left, Right, Full, Self), Union, Group By, Having and Select Into

Q. 4    (a)    What do you mean by a report object navigator and object type? Give list of different 
object types and their description.    (20)

    b)    What are the advantages of using the forms?

Q. 5    (a)    What are different joins available in SQL? Explain any three of them with examples.  (20)

    (b)    What are the advantages of join?

click for assighnment autumn 2018 here
3410 1st assighnment