Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 B.Com B Com.IS - BM 0012 - Database Management and Oracle - Assignments for fall session - Question Paper

ASSIGNMENT
Course: B Com
Subject Code: BM 0012
(4 credits)
Set 1
Marks 60
SUBJECT: Database Management and Oracle

Note: every ques. carries 10 marks

1.Explain what is meant by Data Flow Diagrams? provide Examples.
2.What is meant by Schema ? discuss the 3 level schema architecture?
3.What is meant be relational Database? discuss constraints and data integrity.
4.Explain DDL-Data Definition Language and the DDL statements – Create, Drop and Alter.
5.Define functional dependency. discuss the different kinds of Normalization.
6.Explain in detail the command used in SQL *Plus. How can rows be inserted and deleted in a table.
ASSIGNMENT
Course: B Com
Subject Code: BM 0012
(4 credits)
Set 2
Marks 60
SUBJECT: Database Management and Oracle

Note: every ques. carries 10 marks

1.What are the characteristics of DBMS?
2.Explain with examples Data models and ER diagram with relationships.
3.What are the different operators used in relational algebra?
4.What is a DML? discuss DML in detail. elaborate aggregate functions and value functions?
5. elaborate Data Storage Devices? discuss in detail the different performance measures.
6.Write detailed notes on the subsequent : (a) Methods (b) Collectors (c) Large Objects (d) Data Dictionary (e) Remote Data Access

Earning:   Approval pending.