Final Practical Python Programs and SQL Queries

This repository contains Python programs developed for my final practical file in CBSE Class 12th. These programs showcase my understanding and application of various concepts covered during the course.

Usage

No extra installations are needed to run the python programs. However, mysql-connector-python module is required to run the python-sql connectivity programs.

Python Programs

1. Factorial Calculator

• This program calculates the factorial of a user-input number using functions.

2. Prime Number Checker

• This program checks if a user-input number is prime or not.

3. Fibonacci Series

• Calculates the nth term of the Fibonacci series.

4. Random Number Generator

• Generates random numbers between 1 and 6.

5. Variable-Length Arguments

• Demonstrates variable-length arguments to calculate the product and power of the first 10 numbers.

6. Days to Weeks Converter

• Accepts the number of days, converts it to weeks, and handles errors including the finally clause.

7. Word Search in String

• Searches for a user-provided word in a given string or sentence.

8. File Content Display

• Reads and displays file content line by line with words separated by '*'.

9. Uppercase and Lowercase Counter

• Reads file content and displays the total number of uppercase and lowercase characters.

10. Employee Database

• Creates a binary file to store Employee Name and Employee Code, allowing the user to display employee names based on the entered code.

11. Student Database

• Creates a binary file to store RollNo, Name, and marks of students, allowing the user to update marks based on the entered RollNo.

12. File Content Filter

• Reads file content line by line and writes it to another file, excluding lines containing the letter 'o'.

13. Employee Salary Updater

• Creates a binary file with emp id, name, and salary, provides a function to update the salary based on employee id.

14. Cursor Position

• Prints cursor position and text according to specific specifications.

15. Stack Implementation

• Implements a stack in Python using a list.

SQL Queries

1. Movie Database

• Creates a database MOVIE_DATABASE with a table MOVIE and performs various operations on it.

2. Movie Queries

• Performs queries on the MOVIE table to retrieve information about movies.

3. Movie Yearly Statistics

• Retrieves yearly statistics from the MOVIE table.

4. Movie Updates

• Updates records in the MOVIE table.

5. Review Queries

• Performs queries on the Review table based on movie ratings and collection.

Python-SQL Connectivity Programs

1. Database Creation and Listing

• Creates a database named "Store" and displays the list of databases available in MySQL.

2. Products Table Creation

• Creates a table named "Products" under the "Store" database with columns for Product name, category, price, and discount.

3. Product Records Insertion

• Description: Inserts records into the "Products" table and displays all records.

4. Price Increase for 'a'-Containing Products

• Increases the price of products whose names contain the alphabet 'a' and displays the number of updated records.

Running the Programs

To run a specific program, navigate to its directory and execute the following command:

python program_name.py

Replace program_name.py with the name of the Python file you want to run.

Running the SQL Queries

1. MySQL Command-Line:

   • Open a terminal or command prompt.

   • Connect to your MySQL server using the following command, replacing [username] with your MySQL username and [password] with your password:

     mysql -u [username] -p

   • Enter your password when prompted.

2. Execute SQL Script:

   • Run the SQL script using the following command, replacing [path/to/sql/script.sql] with the path to your SQL script:

     source /path/to/sql/script.sql

Warning

The Review table creation queries needed to run the last sets of queries is not provided in the script.

License

This repository is licensed under the MIT License.

Author

Jairaj K. Bhuyan (GitHub: Smoki-Cool)