Basics of Computer

Q.1:  a) What is Database? What are advantages of modern database?

b) Differentiate between data and information also explain different
types of data.

Q.2:   a) What are the elements of ERD model?

b) What is a relationship explain its various types with the help
of appropriate examples.

Q.3:   a) What is normalization? What kind anomalies are removed by
normalization

b) Explain 1st, 2nd and 3rd normal form.

Q.4: Define DML. Also explain Insert, Update and Delete query with the
help of syntax and examples
Q.5: What is constraint? Explain Nout Null Constraint, Primary Key
and Unique Constraint with the help of examples.
Q.6: a) What is the difference between Group by clause
and order by clause.

b) Define key, Explain Foreign key help of examples.

Q.7: Explain the following functions with syntax and suitable examples.

a. Round
b. Trunc
c. LTRIM
d. RTRIM

Q.8: Write short notes on the following.

i) DBMS
ii) Data Control Language.