Sonali Bank PLC
Post: Assistant Database Administrator
Date: 23.02.24
The invention of the transistor revolutionized electronics and computing.
• It replaced bulky and unreliable vacuum tubes, making devices much smaller and more efficient.
• Transistors consume less power and generate less heat, increasing reliability.
• It enabled the development of modern computers, smartphones, and digital systems.
• It made possible the creation of integrated circuits (ICs) and microprocessors.
• It contributed to the rapid growth of the information technology industry.
Conclusion:
Without the transistor, today’s advanced technology, including computers, mobile devices, and the internet, would not exist. Hence, it truly changed the world.

| Inputs | Outputs | |||
|---|---|---|---|---|
| A | B | Cin | S (Sum) | Cout (Carry) |
| 0 | 0 | 0 | 0 | 0 |
| 0 | 0 | 1 | 1 | 0 |
| 0 | 1 | 0 | 1 | 0 |
| 0 | 1 | 1 | 0 | 1 |
| 1 | 0 | 0 | 1 | 0 |
| 1 | 0 | 1 | 0 | 1 |
| 1 | 1 | 0 | 0 | 1 |
| 1 | 1 | 1 | 1 | 1 |
S= A⊕B⊕Cin
Cout= AB+Cin(A⊕B)
To ensure secure communication between a client application and a database server, the following measures should be taken:
- Encryption (SSL/TLS): Use SSL/TLS protocols to encrypt data during transmission.
- Authentication: Verify user identity using strong authentication methods (username/password, MFA).
- Authorization: Ensure proper access control so users can only access permitted data.
- Use Secure Connections: Avoid plain-text connections; always use secure database connections (e.g., HTTPS, secure ports).
- Firewall Protection: Restrict database access only to trusted IP addresses.
- Regular Updates: Keep database software and security patches up to date.
- VPN: Use Virtual Private Network for secure remote access.
Client application এবং database server-এর মধ্যে নিরাপদ যোগাযোগ নিশ্চিত করতে নিচের বিষয়গুলো অনুসরণ করা উচিত:
- Encryption (SSL/TLS): Data transmission-এর সময় SSL/TLS ব্যবহার করে data encrypt করা।
- Authentication: শক্তিশালী user verification (username/password, MFA) ব্যবহার করা।
- Authorization: User যেন শুধুমাত্র অনুমোদিত data access করতে পারে তা নিশ্চিত করা।
- Secure Connection: Plain-text connection ব্যবহার না করে secure connection ব্যবহার করা।
- Firewall Protection: শুধুমাত্র trusted IP থেকে database access দেওয়া।
- Regular Update: Database software এবং security patch update রাখা।
- VPN ব্যবহার: Remote access-এর জন্য secure VPN ব্যবহার করা।
Normalization in Database:
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It divides large tables into smaller related tables and defines relationships between them.
Goals of Normalization:
• Eliminate duplicate data
• Ensure data consistency
• Improve database structure
Common Normal Forms:
• 1NF → Remove repeating groups
• 2NF → Remove partial dependency
• 3NF → Remove transitive dependency
Before Normalization (Unnormalized ER/Table):
Problem:
• Data redundancy (same student & course repeated)
• Update anomaly
• Insertion/deletion problem
After Normalization (ER Diagram):
• STUDENT and COURSE are separate tables (normalized)
• ENROLLMENT table removes redundancy and maintains relationship
• No redundancy
• Better structure
• Easy update, insert, delete

Logic Circuit:
The primary motivation for moving from classful IP addressing to classless IP addressing (CIDR) was to use IP addresses more efficiently
- Address Wastage: Classful addressing allocated fixed-size blocks, leading to large wastage of IP addresses.
- Flexibility: CIDR allows flexible allocation of IP addresses based on actual need.
- Routing Efficiency: CIDR reduces the size of routing tables by using route aggregation.
- Scalability: Helps support the rapid growth of the internet.
- Better Utilization: Ensures optimal use of available IP address space.
Classful IP addressing থেকে CIDR (classless)-এ যাওয়ার মূল উদ্দেশ্য ছিল IP address-এর সঠিক ও efficient ব্যবহার নিশ্চিত করা
- Address Wastage: Classful পদ্ধতিতে fixed block দেওয়ায় অনেক IP address অপচয় হতো।
- Flexibility: CIDR প্রয়োজন অনুযায়ী IP address বরাদ্দ করতে দেয়।
- Routing Efficiency: Route aggregation-এর মাধ্যমে routing table ছোট হয়।
- Scalability: Internet দ্রুত বড় হওয়ার সাথে মানিয়ে নিতে সাহায্য করে।
- Better Utilization: IP address-এর সর্বোত্তম ব্যবহার নিশ্চিত করে।
#include <stdio.h>
int main() {
int n, i;
float x, sum = 1, term = 1;
printf("Enter value of x: ");
scanf("%f", &x);
printf("Enter number of terms: ");
scanf("%d", &n);
// Calculate series
for (i = 1; i <= n; i++) {
term = term * x / i; // x^i / i!
sum = sum + term;
}
printf("Value of e^x = %.4f\n", sum);
return 0;
}
