Keshav

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 21

BAL MANDIR SR. SEC.

SCHOOL

INFORMATION PRACTISES

ACADEMIC YEAR: 2024-2025

TOPIC: DATA MANAGEMENT SYSTEM

SUBMITTED BY- KESHAV SHARMA

CLASS- XII D

BOARDS ROLL NO-

PARTNER NAME- DEV & NAREN


INDEX
S.NO CONTENT PAGE NO.
INDEX 2
1
2 CERTIFICATE 3

3 ACKNOWLEDGEMENT 4

4 PREFACE 5

5 OBJECTIVE 7

6 DMSv1100 V/S 8
MANUAL SYSTEM
7 INPUT/OUTPUT 9
REQUIRMENTS
8 HARDWARE & 10
SOFTWARE
REQUIRMENTS
9 DATABASE(CSV FILES) 13

10 SOURCE CODE 15

11 OUTPUT 24

12 REFRENCE 30
CERTIFICATE
This is to certify that Keshav
Sharma, student of class 12-D has
successfully completed the project
on Database Management System
whose topic is PanditJi Associates
under the guidelines of the MRS.
DEEPIKA MA’AM (Information
Practices teacher) during the year
2024-25 as per guidelines given by
CBSE.

SIGNATURE_________
AKNOWLEDGEMENT
I would like to express my special
thanks of gratitude to my computer
science teacher MRS DEEPIKA MA’AM
who gave me the golden opportunity,
for her guidance and constant
supervision as well as providing
necessary information regarding the
project and also for their support in
completing the project. Also, this
project helped me to enhance my
knowledge. I would like to express my
gratitude towards my parents and my
friends who gave me their valuable
suggestions and guidance for
completion of my project. Again, I
would like to thank all the above
mention people.
Reason for choosing this topic
• To manage information about the companies

• To keep record of their past performances.


• To compare one company from the others in
different aspects.
• Easy to identify each company with their
different company code.

Objective
• Simple and easy to operate.
• Increased efficiency.

• Search, add, update and view company’s


information.
• Customized reports for better management.

• Save Time
How data management
system more beneficial
then manual system?
Data Management System helps to reduce
the manual work to manage information
about
companies. This software helps to manage
the entire records of the companies. In
addition, it
allows streamlined management of fine
details
such as company’s name, number of
employees in the companies, net worth,
global positioning.
It enables the selector to know anything
about the company instantly. But for safety
purpose the software does not contain
company’s private information.
Input/output requirements
 Operating system

Windows 7 is a major release of the windows


operating system developed by Microsoft. It was
launched on July 22, 2009 and became
generally available on October 22, 2009. It is the
successor to windows vista, released nearly three years
earlier.

Overview of python 3.7


Python is an interpreter, object oriented, highlevel
language with dynamic semantics. It was developed by
Guido Van Rossum.
Python is simple, easy to learn syntax
emphasized readability and therefore reduce the cost
of program maintenance.
Python supports modules and packages, which
encourage program modularity and code reuse.
Features of python
• High level
• Object oriented
• Simple
• Interpreted
• Open software
• Expressive language
• GUI programming
• Large Standard library

Python library- python pandas


Pandas is an open-source library that is made mainly for
working with relational or labeled data both easily and
intuitively. It provides various data structures and
operations for manipulating numerical data and time
series. This library is built on top of the NumPy library.
Pandas is fast and it has high performance &
productivity for users.

Python Library-matplotlib
Matplotlib is a cross-platform, data visualization and
graphical plotting library for Python and its numerical
extension NumPy. As such, it offers a viable open
source
alternative to MATLAB. Developers can also use
matplotlib’s. APIs (Application Programming Interfaces)
to embed plots in GUI applications
C.s.v file
A CSV (comma-separated values) file is a text file that
has a specific format which allows data to be saved in

a table structured format.

Database csv file


SOURCE CODE
from ast import Break import
matplotlib.pyplot as plt
import pandas as pd
import numpy as np

df1=pd.read_csv("C:\\Users\\lenovo\\Desktop\\
companies data.csv")
print(df1)

s=("Main Menu")
while(True):
print("Main Menu")
print("1. Display records of top MNCs")
print("2. Fetch data")
print("3. Update values")
print("4. Looking for a particular
section?”)
print("5. Want some comparison?")
print("6. EXIT")
break
Ch=int(input
if Ch==1:
print(df1)
elif Ch==2:
while(True):
print("Database")
print("1.Top Companies")
print("2.BottomCompanie
s")
print("3. Specific number of companies from the top")
print("4. Specific number of companies form bottom")
print("5. Exit")

Ch2=int(input(“Enter Choice”))
if Ch2==1:
print(df1.head())
elif Ch2==2:
print(df1.tail())
elif Ch2==3:
n=int(input(“Enter how many companies you want to
display from the top”))
print(df1.head(n))
elif Ch2==4:
n=int(input(“Enter how many companies you want to
display from the bottom”))
print(df1.tail(n))
elif Ch2==5:
break
elif Ch==3:
while(True):
print(“Working on columns Menu”)
print(“1. Insert a new column data”)
print(“2. Delete a specific column”)
print(“3. Exit”)

Ch3=int(input(“Enter Choice Number”))


if Ch3==1:
print(“Enter details”)
h=input(“Enter column name”)
det=eval(input("Enter details corresponding to all
subjects : (enclosed in []"))
df1[h]=pd.Series(data=det, index=df1.index)
print(df1)
print("column inserted")
elif Ch3==2:
a=input("Enter column name which need to be
deleted ")
df1.drop([a], axis=1,inplace=True)
print(df1)
print("column deleted")
elif Ch3==3:
break
elif Ch==4:
while(True):
print("Search Menu")
print("1. Search for details of a specific company")
print("2. Search details for a specific column")
print("3. Exit")

Ch4=int(input("Enter Choice Number"))


if Ch4==1:
st=int(input("Enter index no. of the company
whose details you want to see"))
print(df1.loc[st])
elif Ch4==2:
col=input("Enter column whose detail you want to
see")
print(df1[col])
elif Ch4==3:
break
elif Ch==5:
while(True):
print("Data visualization menu")
print("1. Line plot for Employee Comparison")
print("2. Vertical Bar Plot For Net worth Comparison")
print("3. Horizontal Bar plot For Global position
Comparison")
print("4. Exit")

Ch5=int(input("Enter Choice Number"))


if Ch5==1:
Comp=['Microsoft', 'Meta', 'Amazon', 'Google',
'Tesla', 'Tata', 'Relian ce', 'Infosys', 'SpaceX', 'Netflix']
Emp=[221000,58604,1468000,150028,110000,935
000,342982,2 76319,12000,11300]
plt.title("No. of employees in top MNCs")
plt.xlabel("Company name")
plt.ylabel("No. of employees in lakhs")
plt.plot(Comp, Emp,color='y',)
plt.show()
break
elif Ch5==2:
Comp=['Microsoft', 'Meta', 'Amazon', 'Google',
'Tesla', 'Tata', 'Relian ce', 'Infosys', 'SpaceX', 'Netflix']
Net=[2135,36,1053.5,1420,710.78,260,229,79.06,2
,131.6]
plt.title("Net worth of top MNCs")
plt.bar(Comp, Net,color='b')
plt.xlabel("COMPANY NAME")
plt.ylabel("NET WORTH IN BILLION DOLLARS")
plt.show()
break
elif Ch5==3:
Comp=['Microsoft', 'Meta', 'Amazon', 'Google',
'Tesla', 'Tata', 'Relian ce', 'Infosys', 'SpaceX', 'Netflix']
Gpos=[21,27,1,2,103,78,104,50,378,245]
plt.plot(Comp,Gpos,color='r')
plt.title("Horizontal Bar Graph representing
company information")
plt.xlabel("COMPANY NAME")
plt.ylabel("GLOBAL POSITION")
plt.show()
elif Ch5==4:
break
elif Ch==6:
Break
OUTPUTS

You might also like