United Institute of Management
MCA 2nd Semester
Database Management System [KCA-204]
Individual Assignment – Unit 1
1- What is Data Model? List the types of Data Model used.
2- Write down the basics for relational model. How E/R diagrams can be converted to relation designs?
3- What is Data independence and how does a DBMS support it.
4- Differentiate between simple attributes and composite attributes.
5- Describe evolution of database system.
6- What do you mean by DBMS?
7- Define the super key, candidate key and foreign key.
8- Discuss various element of E-R Model.
9- Describe various types of keys used in DMBS.
10- What is ER model? Describe important types of ER diagram notations.
11- What are the characteristics that distinguish a Database management System from traditional file
processing system?
12- Draw the Architecture of a DBMS and briefly explain functions of each component.
13- Define the following terms: Database system, DBA, end user and Database catalogue.
14- Differentiate between Physical level and Logical level Independence.
15- Define Instance and Schema.
16- Explain about External, Conceptual and Internal Schemas.
17- Differentiate between the Generalization and Specialization.
18- Design ER diagram for school admission process. Assume entities and their attributes.
19- Identify various types of DBMS languages and explain their applications.
20- Describe DBMS & its advantages and disadvantages.
21- Explain Database system and file system.
22- Who is Database Designer? Describe the differences between database designer and database
administrator.
23- What is ER Diagram? Draw a suitable ER diagram for any application having at least five entities.
24- Differentiate between File Oriented System and Database system.
25- Explain advantages and disadvantages of Data Independence.
26- Demonstrate the basic elements of a relational database management system.
27- How compilation of queries is done?
28- Write the ways to declare key constraints.
29- Discuss evolution of Database system.
30- Discuss various issues and models for resilient operations.
31- Explain keys, foreign keys and constraints on attributes and tuples.
32- Discuss relation schema, view and database modifications.
33- Differentiate between simple attributes and composite attributes.
34- Define multi valued dependency.
35- Explain the concept of referential integrity and foreign key with suitable example.
36- What are Relational Model Mapping Cardinalities? Give example for each cardinalities used in
DBMS.
37- Explain E-R Diagram with suitable example.
38- What is RDBMS?
39- Explain Data models.
40- Define Data dictionary.
41- Define Schema.
42- Describe primary key.
43- Describe foreign key.
44- Describe candidate key.
45- Explain data integrity.
46- Illustrate referential integrity.
47- Define relational schema.
48- What is data abstraction?
49- Define the following terms: Field & Record
50- What is data redundancy?
51- Describe DCL with examples.
52- Describe DDL with examples.
53- Describe DML with examples.
54- Explain various data types in SQL.
55- What is the role of Data Administrator?
56- What do you mean by Data processing?
57- How is E-R data model useful?
58- What do you mean by instance & schema?
59- What are various component of Database System?
60- What do you mean by DBMS? Explain its functioning.
61- Design and implementation of payroll processing system.
62- Design and implementation of Library Information System.
63- Design and implementation of Student Information System.
64- Design and implementation of Bank Management Information System.
65- Explain about External, Conceptual and Internal Schemas.
66- Differentiate between the Generalization and Specialization.
67- Explain Database system and file system.
******
