Software is a set of
instruction to perform a particular task
Database is collection of tables.
Table is a collection of columns which stores information in the form of rows. which refers to a records.
RDBMS or DBMS
(Relational Database Management System or Database Management System)
Is a software which
is use to manage data.
Operations like
Adding new records and modifying old records and delete the old records are
performed in Database
Various Databases
are like Oracle, Microsoft, MySql.
Microsoft Access is
a graphical tool to create database and manage tables in a database.
Simplest Example of a Database operations is a mobile phone Contacts
Mobile-> Database
Contacts-> table
Records of our friends
firstname
lastname
middlename
mobileno
homeno
email
dob
address
all the above are the columns of a contact table
task on the table
new
modify
delete
How to open MS Access.
Start -> All Programs -> Microsoft Office -> Access
Case Study:
I want to store information about the details of a school.
Information we need to store in a school database.
1. Students
2.Staff
3.Class
4.Exam
5.Subject
Database Name : SchoolDB
Tables in a SchoolDB Database
1. Table Name: Students
2. Table Name: Staff
3. Table Name: Class
4. Table Name: Exam
5. Table Name: Subject
Columns in Students Table:
RollNo.
FirstName
LastName
MiddleName
MobileNo.
HomeNo
FatherName
Mothers Name
Email
DOB
Age
Address
ClassName
LastClassScore
LastSchoolName
FeePaid
Section
Columns in Staff Table:
FirstName
LastName
MiddleName
MobileNo.
HomeNo
Email
Address
Qualification
Post
Exp
Salary
LastSchoolName
Columns in Class Table:
ClassID
Classname
fee
Columns for Exam Table
ClassID
SubjectID
Rollno
Marks
Columns for Subject Table
SubjectID
SubjectName
ClassID
