Database Intro

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