Wednesday, October 09, 2013

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







No comments: