BCA 206

DATABASE MANAGEMENT SYSTEM CONCEPTS

Assignment – 3

          1.   Explain ER Modeling Concepts.

                             i.Conceptual Model

                            ii.Internal Model

                          iii.External Model

                          iv.Physical Model

        2.   What are the Requirements of ER Model?

       3.   Explain ER Model Components & Their Symbols.

      4.   Explain All Classes of Attributes With Example. 

      5.   Explain Relationship Degrees With Example.  

      6.   Explain Connectivity & Cardinality With Example.

      7.   Explain Weak Entity With Example.

      8.   Explain Recursive & Composite Entity With Example.

Assignment – 4

1.     Explain Normalization.

2.     Explain 1NF, 2NF, & 3NF Normalization With Example.

3.     Explain BCNF & 4NF Normalization.

     4.     Explain Denormalization. 

Download Previous Year Question Paper

Chapter 1 File System & Database

Download Chapter 1 File System & Database PPT Download

Chapter 2 - Relational Database Models

Download Chapter 2 Relational Database Models.PPT

Chapter 3 - ER Modeling

Download Chapter 3 ER Modeling PPT

Download ER Diagram Samples

Download ER Diagram Question Answers

Chapter 4 Database Normalization

Download Chapter 4 Normalization PPT