Course: Database-I (3410) Semester: Autumn 2018
click for assighnment autumn 2018 here
3410 1st assighnment
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.
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)
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.
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
(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)
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
Post a Comment