Osmania University (OU) 2009 B.Com Transaction Processing - / - Question Paper

I. ans any 5 ques. in not exceeding 20 lines every five x four = 20 Marks

1.What are the Data Models?

2.What is Normalization?

3.Define Table and Schema.

4.List out the DBA goals.

5.What are the uses of Distributed Database System?

6.What are the risks associated with database development?

7.What do you know about Relational Algebra?

8.How do you implement Logical Relationships?

II. ans the subsequent ques. in not exceeding 4 pages every using internal option five x 10 = 50M

9. (a).What is File Oriented System? elaborate its advantages?
or
(b).What are Database System Components? discuss.

10.(a).Write a note on (i) Integrity Constraints (b) Functional Dependency
or
(b).What are the differences ranging from Conceptual Objects and Physical Objects?

11.(a).Define a view and write operations on a view in SQL.
or
(b).What is client/server database? discuss about Server Data Manipulation.

12.(a).List and discuss Disk Performance factors.
or
(b).Explain the procedure of Mapping logical data structures to physical data structures.

13.(a).Write about DBMS functions and capabilities.
or
(b).Explain about valuation Models.

Earning:   Approval pending.