Summary of Lecture 6 Summary of Lecture

Summary of Lecture 6

Summary of Lecture 6

Today’s Topics

Summary of Today

File Based Systems

Different Files on a Desktop

What is Data Duplication? Example: A Person Name and address may be stored in several different files.

Database Systems

Some popular DBMS Softwares

Why Database System?

Advantages of using DBMS

Can you find redundancy?

Data Generated Data

Concurrent Access

Security

Some other advantages

A Microsoft Access Table

Employee Entity Relationship Diagram is used to conceptually represent Relational database.

Database Systems in work

A Data Entry Form Example of National Database

Hospital Database System

COMSIS

COMSIS

Payroll System

Airline reservation system

PIA Seats Availability database search

Logistic Database

Fed. Ex Pakistan online database tracking

Database Design Terms

Table

Data Types

Primary Key

Primary Key Setting in Access It can be set by right clicking on the Field Name.

Foreign Key

Checks or Constraints

Checks

Query

In MS Access Query can be created using a “Query Wizard”

Forms

New Student Data Entry Form

Reports

Report Example

How databases are developed?

Feasibility study

System analysis

System design

System design

Coding

Testing and Implementation

Testing and Implementation

Testing and Implementation

Maintenance

Summary of today