Unit II: Designing a Database – Database Management System

BCA 4th Semester DBMS (Database Management System) Notes Pdf, Designing a Database – Database Management System

Designing a Database – Database Management System

In this unit named Designing a Database – Database Management System” readers and viewers will get information regarding the following topics:

  1. Introduction to Designing a Database
  2. Database Development Life Cycle
  3. ER-Diagram
  4. Why Use ER Diagrams?
  5. ER Diagrams Symbols & Notations
  6. Components of ER Diagram
  7. Entity
  8. Entity Set
  9. Difference between Strong Entity Set and Weak Entity Set
  10. Attribute
  11. Relationship
  12. Degree of Relationship/Types of Relationship
  13. Participation Constraints
  14. Mapping Constraints/Cardinality Ratios
  15. Notation Styles That Express Cardinality
  16. Extended ER Features
  17. Generalization
  18. Specialization
  19. Aggregation
  20. Construction of ER-Diagram (Practice)
  21. UML Class Diagram
  22. Benefits of Class Diagram
  23. Essential Elements of A UML Class Diagram
  24. Example of UML Class Diagram
  25. Use Case Diagram
  26. Why Use-Case Diagram?
  27. Use-Case Diagram Notations
  28. An Example of a Use-Case Diagram
  29. Activity Diagram
  30. Components of Activity Diagram
  31. Why use Activity Diagrams?
  32. Activity Diagram Notations
  33. Example of Activity Diagram
  34. Sequence Diagram
  35. Basic Symbols and Components
  36. Benefits of Sequence Diagrams
  37. Sequence Diagram Example
  38. Difference between Entity and Object

This article Designing a Database – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester DBMS (Database Management System) Notes:

Unit I: Operating System Overview - Database Management System

Unit III: Data Normalization - Database Management System

Unit IV: Queries In Database - Database Management System

Unit V: Advanced Queries In Database - Database Management System

Unit VI: Developing Stored Procedures - Database Management System

Unit VII: Creating DML Triggers - Database Management System

Unit VIII: Physical Design - Database Management System

Unit IX: Database Application Types - Database Management System

Unit X: Distributed Database System - Database Management System

Unit XI: Object Oriented Database - Database Management System

No comments

Post a Comment

Share your honest opinion and feedback about this website, through the comment box.

Don't Miss
© 2019 - All Rights Reserved
Lots of BCA Notes (Pokhara University)