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