Question
Using Structures write an interactive program in C language to create an application
program for a small school to maintain the Student_’s database. This application should
be having menu options like (10 Marks)
• Creating a New Record
• Reading/Listing of Records
• Modify the record
•Delete the record
Each Student_ record should have Student_Name, Student_Roll_No., Student_Class, Student_Fees, Date of Admission, etc.). The application should be designed user-friendly.
To develop an interactive application in C for maintaining a small school’s student database, we can use structures to manage student records. This C program will implement a menu-driven approach to perform operations like creating new records, displaying records, modifying records, and deleting records.
### Step 1: Define the Structure
We will define a structure `Student` to hold all the required student details:
```c
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#define MAX_STUDENTS 100
// Defining structure for student
struct Student {
char name[50];
int rollNo;
char className[20];
float fees;
char admissionDate[20];
};
// Function prototypes
void createRecord(struct Student students[], int *count);
void listRecords(struct Student students[], int count);
void modifyRecord(struct Student students[], int count);
void deleteRecord(struct Student students[], int *count);
int findStudentIndex(struct Student students[], int count, int rollNo);
```
### Step 2: Implement the Menu and Operations
The program will allow the user to choose an option from the menu. Based on the choice, it will call the respective function.
```c
int main() {
struct Student students[MAX_STUDENTS];
int count = 0; // To track the number of students in the database
int choice;
while (1) {
// Displaying the menu
printf("\nSchool Student Database System\n");
printf("1. Create a New Record\n");
printf("2. List all Records\n");
printf("3. Modify a Record\n");
printf("4. Delete a Record\n");
printf("5. Exit\n");
printf("Enter ____________ ____ _______ ____________ _____________ ________ _____________ _______ ____ __________ ____.
_________ ___ ___ _____________ _______ ________.
___ ____________ ______ __________ __________ ___ _____________ ___ __________ ________ ______ _________ _________.
_______ __________ _________ _______ _____________ ________ __________ ______.
__________ ____ ____ _________ ___ _________ __________ __ _____________ ____ __________ _____ ________.
_____ _____ ____________ _____ ___________ _____________ __________ __ _____________ _____ ___ _____________.
_______ __ _________ ___________ __ ____ __________ _____________.
_____________ _____________ ____________ _____ ______ __________ _____ ____ _____ ________ ________ __.
___________ ______ ______ ___________ ___ ____________ __ _________ ____ _______ ___ _____ _______.
______ ___________ __________ _______ ____________ __________ _________ __________ __ _________.
_____________ ____________ _______ ______ _________ ___ _____ _____________ __ _______ __.
________ __________ ________ ________ _____________ ____________ ________ _____________ ________ _____ ____________.
________ ______ ___ ________ _____________ _____ ___________.
______ ________ ____ _____________ _____________ ___ ___________ __ __________ _____________ __________ ________ _________ _____________.
____ _________ __________ ______ ________ ___________ ___________ _____.
_____________ _________ _____ _____ ____ __ _____ _____________ ___ __.
__________ _________ _____ ______ _____ __________ ___________ ___ ________.
____ ________ _________ ______ ______ ______ ___ ___________ ____ _____ ___________ _________ _________ _______.
_____________ ___________ _______ _____________ _____________ ___________.
______ ___________ ___ _____________ _______ _____________ _________ _________.
__ ____ _____ ___________ ___________ ____________ ____ _____ ____ _______.
____________ __________ __ ______ ____ ____________ __ __________.
____ ___ __ __________ ____________ ____________ _________ __________ _________ ______ ______.
______ ____ ____ _____________ ____ _____________ ________ ___.
____________ _______ _____________ _______ _________ __.
____ ______ __ ____ __________ ___ ______ _____ _____.
_______ _____________ ________ _______ _______ _____________ ______ _________ ____ ______ _____ _______.
__________ __________ _____________ ________ ___ ____________.
_________ ___________ ________ ___ ________ __________ _____________.
__________ ___________ ___________ _____________ __ ________ _____________ ______ _____________ _____________ __________ _____________ ___.
____ ________ ____ __ ________ __________ ___ ______ ____________ _____________ __________.
__________ __________ _____________ _________ __ ____ __ ________ _____.
___________ __________ ___________ ___________ __________ __________ ____ ___ ______ ____ _____________ _____________ ________.
_____ ___________ _______ _______ ________ _____.
_____ ___ ____________ ___ _______ ___________ ______ ____ _____ ___ _____________ ______.
__________ ___________ ___________ ______ _____________ _____ ___________ __ ___________ ___________ ________.
___ ___________ ______ _____ ___________ ____ __________.
__ __________ ___________ _________ ___ _____ ____ _______ ______ ____________ _____________ _____ _________.
______ ________ ___________ __________ __ ___________ _____________ _________ ________ __ ________ _________ ______ __.
_____________ ____ __ _______ ___ ________ ________ _______.
_______ ___ _____________ ______ ___ _____ _____ ___________ ______ _____ ___.
_______ _____ ____________ _____________ ______ ___ ______ _________ _________ _____ _______ _____________ ______ __.
_____ ___ _____________ _____________ ________ ______ ____________ ___________ _____________.
____________ __________ ____ _________ ___ ____________ ____________ ______ _______ ____________.
_____________ _________ ________ _____ __ ____ ____________ ___ ____ ______ ______ ____.
___ __ _________ ___________ __ ___ ____ ___ ____ ________.
_________ ___________ _____ __ ________ _____________ ____ __ __ ____ __ __________.
____ _______ ___ __________ ________ ________ _________ ____________ ____________ ___________ _____ ___.
_______ ______ ___________ ______ _____ _______ __________ _____ ___________.
___ __ ____ _____________ ______ ___________ _________ _________ ____ ______ _____________ ______ ___________ ________ _______.
_____________ ____________ ___________ ______ ____ __ ______ __ ____________ ____ _____________ __________ __ _____.
___________ ____________ __ ________ ___ ____________ _____ _________ _____________ _______.
________ _____ ___ ___ ___ ________ _______ ___________ _____ __________ __ _____________ ______ ______ ____________.
_____________ _________ _________ ______ ________ ___________ __.
_____ ____________ ____ _____________ ________ ____.
____ _______ _____________ __ _____ _________ ____.
______ ________ __________ __ __ _____ _________ ______ _____ _______ __________ ________ ___ _________ _____.
_________ ___ ____ ______ ____________ ____ ____.
___ _____________ _____ ______ ________ ______ __________ __________ _______ ___ ____________.
__________ ___ ____________ ____________ _____ ________ ___________ __________ ___ __________ __ ____________ _______.
_____ _________ _________ ____ ______ _____ ____________ ___ __ _____________.
__ ____________ ___________ _____________ ________ ____ _____________ _________ __________ ______ ___________ __ _______.
____ __ ________ ___ _____________ ___.
_____________ __ _______ ________ ___________ _____ _____.
___ ___ __ _____________ ___________ _____ __________ ____________ _________ __ _____________ __ _________ ___ ________.
____________ ______ _________ _________ ________ _______ _________ ___________ ___ ____________ _____________ __________ ______ ___________ __________.
____ __________ ___ ___________ _____ _________ ___________.
____ _______ _______ ________ _______ _________ ___________ ________ ___________ ____ ____________ _____ ___.
_______ __ _________ _____________ _________ ____________ ______ _______.
______ __ ____ ______ __ _____ _________ _____ __ ____ ________.
_____________ ____________ _____ ___________ _______ _______ _____.
_________ ____ ____________ __ ______ ___________ ___ ______ __ __ __________ __ ____________.
_____ ________ ___ __________ ____________ __________ __________.
_____________ _____________ _______ _____ _________ ____ _______ ____________.
___________ ________ _____________ _____________ ________ _____________ _______ ____________ _____ ____________.
________ __________ ______ _____ _____________ ______ ____ _________ _____________ ______ __________ _____.
_____________ ______ __ ______ _____ ___ ____ _____________ ____________ ________ ___ ______ ______ ________ ____.
____ ______ ____________ _______ _______ _________ __________ ____________ _________ ___________ ___________ ___ __.
__ __________ ___________ _____________ _______ __________ ______ _________ _____________ ________ ____ ______ ________ ___________ ____________.
_________ ____________ _______ __ _______ _____ ____________ ___ __________.
___ _____________ _________ _______ ____ ___________ ___ ________ __________ ______ __________ _______ __________.
__ ____________ __ ____________ _____________ ______ ________ _______ __________ ____________ __ ___________ ___ ____________.
_____ ___ _____ __________ _____ _________ _________ ___ ____________ __________ _____ _____________ ___________ _______ ________.
_______ __________ ____________ _______ _________ ____________ ______ _________ ___ ______.
_______ ___ __ ____ ______ __ __________ __________ ________ ____ ___________.
___ ____________ _____________ ___________ _________ _____________ _________ ___________ ___.
________ _____________ ____ _____________ ____________ _______ ___________.
__ _____ _____ _________ _____ _____________ __ _____________ _________ _______.
____ ________ _________ ___________ ____________ _____ ____________ _____________ _______ ______.
______ ___________ ____ ____________ ________ ________ _____________ ____________.
____ ___ ______ ___ _____________ ____.
_______ _____ _________ _________ ____________ ___ ____________ ____ ___ __________ __________ _______ ____________.
__ ________ ______ _________ ____________ ________ ________ ________.
_____ __________ ____ __ ____ ___________ ____ _____ ________ _________.
___ ___________ _____ ____________ _____ _____________ ________ ____ ____________ __________ _____ _________ ________ __.
__________ __ ___ __ __ _______ ____________ ____ ________ __.
___ ____________ ___ _________ _____ _____________ ____________ _____ ____ ___ ____________ _________ _______ __.
____________ _____________ ___________ ___ ___________ _____________ ____ __ ________ _______.
__ ___________ ____ _____ ___________ ___.
_____ ____ ________ __ ___ ____ __________ ________ _____________ __________ ____________ ____________ _____________ ___________.
__________ ___________ ________ ____________ _____________ ____ _____________.
__ _____ _____________ ___________ _________ ___ __________ ____ _____________ ___________.
________ ____________ _____ ____________ ___ _____________ ____________ _____ ____________ _______ ____ ___________.
_________ __ ___________ __________ ____ ____ ___ ____ _____________.
_______ _______ ___________ ___________ __________ _____________ _______ _____ _________.
____________ ____ ____________ ______ _________ __________ ________ __ __ ____ _____.
___ ____ ______ ____ ___ ___ _______ ______.
___________ ________ _________ _____ ______ _______ _________ ____________.
_________ ________ ___________ ___ _________ __ ____________ _______.
__ ____________ ____________ ____ _______ __________ _________ ________ __________ ___________ ____ _______ ________.
__________ ___ ______ ____ ___________ __________ __ ______ _______.
_______ ________ ____ _____ ___________ __________ ____ _______ __________.
___ _________ _____________ ________ _____________ __ _____.
_____ _________ __________ __ ____.
Click Here to Order Full Assignment on WhatsApp
Download any Dataset, then write a python code to read the downloaded dataset of your choice (April be CSV file) and print all features i.e. columns of the dataset. Determine the descriptive statistics i.e. Mean Median, Maximum, Minimum ,Range, Count, Variance, Standard Deviation etc. of the numeric features like age, marks, income etc., which April be present in the dataset.
Write Program to perform following tasks (10 Marks)
a. Create a database PRODUCT_SELECTION_DB
b. Set connection with mysql.connector.connect.
c. Create a table PRODUCT _SELECTION in database PRODUCT_SELECTION_DB with
following data PRODUCT_NAME,PRODUCT_PRICE, MANUFACTURER, EXPIRY_DATE.
d. change table structure / (add, edit, remove column of a table) at run time
i. add a column address in the PRODUCT_SELECTION table.
ii. execute SQL INSERT statement to create a record into PRODUCT _SELECTION table
iii. run the query to updates all the records having EXPIRY_DATE as 31-Dec-2022 and
increase PRICE of all the PRODUCTS by 10% of PRODUCT_PRICE.
iv. delete all the records from PRODUCT _SELECTION Table where EXPIRY_DATE is
before 31-Dec-2022.
Using Structures write an interactive program in C language to create an application
program for a small school to maintain the Student_’s database. This application should
be having menu options like (10 Marks)
• Creating a New Record
• Reading/Listing of Records
• Modify the record
•Delete the record
Each Student_ record should have Student_Name, Student_Roll_No., Student_Class, Student_Fees, Date of Admission, etc.). The application should be designed user-friendly.
Write program in C, for the following :
a) To find the sum of digits in an N digit number entered by the user, and print weather the final sum of digits is even or odd
b) To replicate strcpy() function of string.h header file
c) To convert decimal number enetered by the user into its equivalent Binary number.
d) To find the Largest and Smallest number in an unsorted array of integers, entered by the user.
e) To find count vowels and consonants present in any sentence entered by the user
Click to Contact Us
Call - 9199852182 Call - 9852900088 myabhasolutions@gmail.com WhatsApp - 9852900088