Assignments [ D.B.M.S. ] sem. 4 [3341605]

PROGRESSIVE ASSESMENT

Subject Name :Database Management

Subject Code::3341605

Faculty Name : M.A.Mishra

Start Date ::2/1/2018

End Date ::18/1/2018

Assignment ::1

1.      Define DBMS.
2.      Define following terms. A) Data B) Information C) Database D) Files E) Fields F) Records.
3.       Explain Data Abstraction.
4.      Explain Data Independence. 
5.       Functions of DBMS.
6.       Responsibilities of DBA.

Assignment ::2

1. What Do You Mean by constraint? What is purpose of it?
2.  List different type of Constraint .
3.  What is use of NOT NULL Constraint?
4.   What is CHECK Constraint?
5.   What is use of default values?
6.   What is unique key ? List properties of UNIQUE Constraint.
7.   What is primary  key ? List properties of PRIMARY KEY Constraint.
8.   List properties of FOREIGN KEY Constraint.
9.  List Features of MS Access.
10.   List drawbacks of MS Access
11.   Explain different datatype provided by Access.
12.   What is use of forms? Explain different type of form.
13.   What is a report ? what is use of it?