Dbms

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Dbms as PDF for free.

More details

  • Words: 583
  • Pages: 24
DATABASE MANAGEMENT SYSTEM PRACTICAL FILE

BY:

AASTHA GROVER BBS 2C ROLL NO.: 4728

TABLE OF CONTENTS

1. TABLES………………………………………………………………4

(DESIGN VIEW + OUTPUT)

2. RELATIONSHIP ……………………………………………….…10

3. FORMS………………………………………………………………11

4. QUERRIES…………………………………………………………15

5. REPORT……………………………………………………………22

2|Page

3|Page

TABLES

4|Page

TABLE 1 DESIGN VIEW

5|Page

RECORDS Train No DL101 MH102 CH103 UP104 DL105 MH106 CH107 UP108 DL109 MH110 CH111 UP112 DL113 MH114 CH115

6|Page

Train Type Rajdhani Shatabdi Local Express Deluxe Express Deluxe Express Local Express Shatabdi Rajdhani Rajdhani Shatabdi Local Express Deluxe Express Rajdhani Shatabdi Deluxe Express

Table1 Departing Station Delhi Mumbai Chandigarh Faridabad Delhi Mumbai Chandigarh Faridabad Delhi Mumbai Chandigarh Faridabad Delhi Mumbai Chandigarh

Arriving Station Jalandhar Patna Delhi Agra Gujarat Pune Ludhiana Andhra Jammu Dwarka Patiala Jaipur Assam Mathura Pune

TABLE 2 DESIGN VIEW

7|Page

RECORDS Train No DL101 MH102 CH103 UP104 DL105 MH106 CH107 UP108 DL109 MH110 CH111 UP112 DL113 MH114 CH115

8|Page

Table2 Departure Date 2/2/2009 3/3/2009 1/13/2009 12/12/2009 5/25/2009 6/11/2009 2/28/2009 4/30/2009 10/27/2009 7/7/2009 8/24/2009 9/15/2009 11/11/2009 1/1/2009 6/30/2009

Seats Booked 1000 500 600 750 1500 1200 1100 650 790 832 911 1010 250 2000 1000

TABLE 3 DESIGN VIEW

RECORDS Table3 Train Type

9|Page

Seating Capacity

Train Picture

Deluxe Express

1500

Picture

Local Express

1000

Picture

Rajdhani

2500

Picture

Shatabdi

10 | P a g e

2200

Picture

RELATIONSHIPS

Between Table 1 & Table 2 ------  One to One Relationship

Between Table 1 & Table 3 -------  One to Many Relationship

11 | P a g e

FORMS OUTPUT

12 | P a g e

FORM 1 FOR TABLE 1

13 | P a g e

FORM 2 FOR TABLE 2 WITH COMBO BOX

14 | P a g e

FORM 3 FOR TABLE 3 WITH LIST BOX

15 | P a g e

QUERRIES

16 | P a g e

RELATIONSHIP QUERRY 1 TO KNOW THE TRAINS DEPARTING FROM Delhi or Mumbai DESIGN VIEW

OUTPUT Query1 Train No

17 | P a g e

Departing Station

DL101

Delhi

DL105

Delhi

DL109

Delhi

DL113

Delhi

MH102

Mumbai

MH106

Mumbai

Query1 Train No

Departing Station

MH110

Mumbai

MH114

Mumbai

RELATIONSHIP QUERRY 2 To know the train number & seating capacity of an express train with letter ‘L’ in its name. DESIGN VIEW

OUTPUT Query2 Train Type Local Express 18 | P a g e

Seating Capacity

Train No

1000 CH111

Query2 Train Type

19 | P a g e

Seating Capacity

Train No

Local Express

1000 MH106

Local Express

1000 CH103

RELATIONSHIP QUERRY 3 TO KNOW THE TRAIN EITHER STARTING FROM DELHI OR REACHING DELHI DESIGN VIEW

OUTPUT Query4 Train No Departing Station Arriving Station

20 | P a g e

Train Type

DL113

Delhi

Assam

Rajdhani

DL109

Delhi

Jammu

Rajdhani

DL105

Delhi

Gujarat

Deluxe Express

DL101

Delhi

Jalandhar

Rajdhani

CH103

Chandigarh

Delhi

Local Express

INDIVIDUAL QUERRY FOR TABLE 1 TO KNOW THE SPEIFIC TRAIN BETWEEN DELHI & JAMMU

DESIGN VIEW

OUTPUT Query3 Train No DL109

21 | P a g e

Departing Station Delhi

Arriving Station Jammu

INDIVIDUAL QUERRY FOR TABLE 2 TO KNOW THE TRAINS TRAVELLING BETWEEN QUARTER 3 OF 2009 DESIGN VIEW

OUTPUT Query5 Train No

22 | P a g e

Departure Date

Seats Booked

UP108

4/30/2009

650

MH106

6/11/2009

1200

DL105

5/25/2009

1500

CH115

6/30/2009

1000

INDIVIDUAL QUERRY FOR TABLE 3 TO KNOW THE TARIN STARTING WITH LETTER L OR HAVING A SEATING CAPACITY GREATER THAN 2000 DESIGN VIEW

OUTPUT Query6 Train Type

Seating Capacity

Rajdhani

2500

Shatabdi

2200

Local Express

1000

23 | P a g e

REPORTS

24 | P a g e

Related Documents

Dbms
October 2019 29
Dbms
June 2020 22
Dbms
November 2019 10
Dbms
May 2020 4
Dbms
April 2020 11
Dbms
June 2020 6