DBMS Project
Installation Steps
Download the DBMS software from the official website.
Run the installer and follow the on-screen instructions.
Choose the installation directory and click 'Next'.
Select the desired components to install (e.g., server, client, plugins).
Configure the database settings, such as username and password.
Complete the installation process and click 'Finish'.
Hardware Requirements
Processor: Intel Core i5 or equivalent
RAM: 8GB or higher
Storage: 500GB SSD or higher
Operating System: Windows 10 or macOS Mojave
Network Interface Card: Ethernet or Wi-Fi
Display: 15-inch Full HD monitor
Keyboard and Mouse: Standard wired or wireless peripherals
-- Table for authors
CREATE TABLE authors (
author_id INT AUTO_INCREMENT PRIMARY KEY,
author_name VARCHAR(100) NOT NULL
);
-- Table for books
CREATE TABLE books (
book_id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(100) NOT NULL,
author_id INT,
publication_year YEAR,
FOREIGN KEY (author_id) REFERENCES authors(author_id)
);
-- Table for book copies
CREATE TABLE book_copies (
copy_id INT AUTO_INCREMENT PRIMARY KEY,
book_id INT,
copy_number INT NOT NULL,
availability ENUM('available', 'borrowed') DEFAULT 'available',
FOREIGN KEY (book_id) REFERENCES books(book_id)
);
-- Table for borrowers
CREATE TABLE borrowers (
borrower_id INT AUTO_INCREMENT PRIMARY KEY,
borrower_name VARCHAR(100) NOT NULL,
email VARCHAR(100)
);
-- Table for loans
CREATE TABLE loans (
loan_id INT AUTO_INCREMENT PRIMARY KEY,
copy_id INT,
borrower_id INT,
loan_date DATE,
return_date DATE,
FOREIGN KEY (copy_id) REFERENCES book_copies(copy_id),
FOREIGN KEY (borrower_id) REFERENCES borrowers(borrower_id)
);
Computer Network and Data Communication Project
The computer network and data communication project focuses on setting up a communication system
model and transferring files between computers. It involves the following elements:
Network devices
IP addressing
File transfer process
Network Devices
The communication system model includes various network devices such as routers, switches, and
modems. These devices enable the transmission and reception of data between computers.
IP Addressing
Static and dynamic IP addressing methods are used to assign unique addresses to each computer in the
network. Static IP addressing involves manually assigning an IP address, while dynamic IP addressing
uses DHCP to automatically assign IP addresses.
File Transfer Process
To transfer files from one computer to another, third-party software can be used. The process involves
establishing a connection between the sender and receiver, initiating the file transfer, and ensuring the
successful completion of the transfer.
Web Technology II
Server-side Scripting (PHP)
<?php
// Sample code for calculating billing
$quantity = 5;
$price = 10;
$total = $quantity * $price;
echo 'Total bill: $' . $total;
?>
Client-side Scripting (JavaScript)
// Sample code for event handling
function showAlert() {
alert('Button clicked!');
// Sample code for user login portal
function login() {
var username = document.getElementById('username').value;
var password = document.getElementById('password').value;
if (username === 'admin' && password === 'password') {
alert('Login successful!');
} else {
alert('Invalid username or password.');
Sample User Login Portal
<!DOCTYPE html>
<html>
<body>
<label for='username'>Username:</label>
<input type='text' id='username'><br><br>
<label for='password'>Password:</label>
<input type='password' id='password'><br><br>
<button onclick='login()'>Login</button>
<script src='script.js'></script>
</body>
</html>
Output Screenshot
C Programming II
Modular Programming
Modular programming is a software design technique that emphasizes dividing a program into separate,
self-contained modules.
Each module focuses on a specific task or functionality, making the program easier to understand,
debug, and maintain.
Features of Modular Programming
Reusability: Modules can be reused in different programs, saving development time and effort.
Encapsulation: Modules encapsulate data and functions, providing abstraction and protecting data from
unauthorized access.
Maintainability: Modular programs are easier to maintain and update, as changes in one module do not
affect other modules.
Program: Reverse and Palindrome
This program reads a number from the user and reverses it.
It then checks whether the reversed number is a palindrome or not.
A palindrome number is the same when read forwards and backwards.
Program: Greatest Among 10 Numbers
This program finds the greatest among 10 different given numbers.
It compares each number with the current greatest number and updates it if a larger number is found.
Calculation Problem: 3x3 Matrix
Solve a calculation problem involving a 3x3 matrix.
Perform matrix operations such as addition, subtraction, multiplication, or finding the determinant.
Program: Student Data Management
This program displays and stores data of 100 students using structure.
It allows users to input student details such as name, roll number, and marks.
The data is then stored and can be accessed for further processing or analysis.
Sorting Data
Demonstrate data sorting in ascending and descending order of any 10 given inputs.
Use sorting algorithms such as bubble sort, selection sort, or insertion sort to arrange the data in the
desired order.
File Handling
Demonstrate different modes of file handling in C.
Show how to open, read, write, and close files using different file handling functions.
Discuss file permissions, error handling, and best practices for file operations.
C Programming II
Modular Programming
Modular programming is a software design technique that emphasizes dividing a program into separate,
self-contained modules.
Each module focuses on a specific task or functionality, making the program easier to understand,
debug, and maintain.
Features of Modular Programming
Reusability: Modules can be reused in different programs, saving development time and effort.
Encapsulation: Modules encapsulate data and functions, providing abstraction and protecting data from
unauthorized access.
Maintainability: Modular programs are easier to maintain and update, as changes in one module do not
affect other modules.
Program: Reverse and Palindrome
This program reads a number from the user and reverses it.
It then checks whether the reversed number is a palindrome or not.
A palindrome number is the same when read forwards and backwards.
Program: Greatest Among 10 Numbers
This program finds the greatest among 10 different given numbers.
It compares each number with the current greatest number and updates it if a larger number is found.
Calculation Problem: 3x3 Matrix
Solve a calculation problem involving a 3x3 matrix.
Perform matrix operations such as addition, subtraction, multiplication, or finding the determinant.
Program: Student Data Management
This program displays and stores data of 100 students using structure.
It allows users to input student details such as name, roll number, and marks.
The data is then stored and can be accessed for further processing or analysis.
Sorting Data
Demonstrate data sorting in ascending and descending order of any 10 given inputs.
Use sorting algorithms such as bubble sort, selection sort, or insertion sort to arrange the data in the
desired order.
File Handling
Demonstrate different modes of file handling in C.
Show how to open, read, write, and close files using different file handling functions.
Discuss file permissions, error handling, and best practices for file operations.
