Unit II: 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

Unit I: Operating System Overview - Database Management System

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

1. Basic Terminologies
2. Introduction to Database Management System (DBMS)
3. Advantages of DBMS
4. Brief History of Database Management System Approach
5. File-Based Model
6. Hierarchical Data Model
7. Network Data Model
8. Relational Database
9. Cloud Database
10. NoSQL Database
11. Object-Oriented Databases
12. Graph Databases
13. Application Areas of DBMS
14. Components of a Database Management System
15. Hardware, Software, Data, Procedures, Database Access Languages, Users
16. DBMS vs. File System
17. Difference between DBMS and RDBMS
18. Data Model Schema and Instance
19. Three Schema Architecture/ Views of Data – Data Abstraction
20. Internal Schema/Physical Level
21. Conceptual Schema/Logical Level
22. External Schema/User View Level
23. Goal of 3 Level/Schema of Database
24. Advantages Database Schema
25. Disadvantages Database Schema
26. Data Independence
27. Types of Data Independence
28. Database Language
29. Types of Database Languages
30. Data Definition Language (DDL)
31. Data Manipulation Language (DML)
32. Data Control Language (DCL)
33. Transaction Control Language (TCL)
34. Database Administrator
35. Function of DBA (Database Administrator)

Unit VIII: Generics - Java Programming

In this unit named “Generics – Java Programming” readers and viewers will get information regarding the following topics:

1. Introduction to Generics
2. Properties of Generics
3. Generics Class with Parameters
4. General Form of a Generic Class
5. Creating a Generic Method
6. Creating Generic Constructor
7. Creating Generic Interface
8. Polymorphism in Generics

We are very grateful to Madan Raj Pandey Sir, who is a lecturer at Dhangadi Engineering College for this article "Generics - Java Programming".

Unit VII: Java Database Connectivity (JDBC) – Java Programming

In this unit named “Java Database Connectivity (JDBC) – Java Programming” readers and viewers will get information regarding the following topics:

1. Database Connectivity (JDBC)
2. ODBC (Open Database Connectivity)
3. JDBC Components
4. JDBC API
5. JDBC Driver Manager
6. JDBC Test Suite
7. JDBC-ODBC Bridge
8. Types of JDBC Drivers
9. JDBC-ODBC Bridge Driver (Type 1)
10. Native-API (Type-2) Driver
11. Network-Protocol (Type 3) Driver
12. Native Protocol (Type 4) Driver
13. Writing JDBC Application
14. Types of Statement Objects
15. Statement
16. PreparedStatements
17. CallableStatement
18. ResultSet
19. Types of ResultSet
20. CRUD Operations in Database
21. JDBC and AWT
22. Connection Pooling

We are very grateful to Madan Raj Pandy Sir, who is a lecturer at Dhangadi Engineering College for this article "Java Database Connectivity (JDBC) – Java Programming"

Unit VI: Networking with Java – Java Programming

In this unit named “Networking with Java – Java Programming” readers and viewers will get information regarding the following topics:

1. Networking Basics
2. Networking Terminology
3. Sockets
4. Ports
5. Proxy Server
6. Internet Address URL
7. URL Connection
8. java.net
9. Java Networking Classes
10. Java Networking Interfaces
11. Implementing TCP/IP based Server and Client
12. TCP/IP Server Socket
13. TCP/IP Client Socket
14. Datagram in Java Programming
15. DatagramPacket
16. DatagramSocket
17. Java Datagram Programming Model Steps

We are very grateful to Madan Raj Pandey Sir, who is a lecturer at Dhangadi Engineering College for this article "Networking with Java - Java Programming".