You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
p
PRINTFILE operation has been chosen
Enter All to disaply all tables or Enter table name to display:
all
People.db
-------------------------------------------
| SSN | Name |
-------------------------------------------
Books.db
----------------------------------------------------------------
| Author | Title | CallNo |
----------------------------------------------------------------
| Burnett | The Scret | MN234 |
----------------------------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
n
------------------------------------------------------------
Redirecting to Home Page..
------------------------------------------------------------
------------------------------------------------------------
You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
i
INSERT operation has been chosen
-----------------------------------------------------------------
Choose Table name:
Books
-----------------------------------------------------------------
Enter Author:
Wesley
-----------------------------------------------------------------
Enter Title:
Journal
-----------------------------------------------------------------
Enter CallNo:
PQ945
------------------------------------------------------------
************Record is inserted Successfully********************
------------------------------------------------------------
If you would like to create more tables, Type 'Yes' or 'No' (y/n):
y
------------------------------------------------------------
-----------------------------------------------------------------
Choose Table name:
Pushkin
------------------------------------------------------------
Table name doesn't exist. So, Please try AGAIN
------------------------------------------------------------
-----------------------------------------------------------------
Choose Table name:
Evgeny
------------------------------------------------------------
Table name doesn't exist. So, Please try AGAIN
------------------------------------------------------------
-----------------------------------------------------------------
Choose Table name:
KL2344
------------------------------------------------------------
Table name doesn't exist. So, Please try AGAIN
------------------------------------------------------------
-----------------------------------------------------------------
Choose Table name:
Books
-----------------------------------------------------------------
Enter Author:
Pushkin
-----------------------------------------------------------------
Enter Title:
Evgeny
-----------------------------------------------------------------
Enter CallNo:
MN234
------------------------------------------------------------
************Record is inserted Successfully********************
------------------------------------------------------------
If you would like to create more tables, Type 'Yes' or 'No' (y/n):
n
------------------------------------------------------------
Redirecting to Home Page..
------------------------------------------------------------
------------------------------------------------------------
You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
p
PRINTFILE operation has been chosen
Enter All to disaply all tables or Enter table name to display:
all
People.db
-------------------------------------------
| SSN | Name |
-------------------------------------------
Books.db
----------------------------------------------------------------
| Author | Title | CallNo |
----------------------------------------------------------------
| Burnett | The Scret | MN234 |
----------------------------------------------------------------
| Wesley | Journal | PQ945 |
----------------------------------------------------------------
| Pushkin | Evgeny | MN234 |
----------------------------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
y
------------------------------------------------------------
Enter All to disaply all tables or Enter table name to display:
Books
Books.db
----------------------------------------------------------------
| Author | Title | CallNo |
----------------------------------------------------------------
| Burnett | The Scret | MN234 |
----------------------------------------------------------------
| Wesley | Journal | PQ945 |
----------------------------------------------------------------
| Pushkin | Evgeny | MN234 |
----------------------------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
yes
------------------------------------------------------------
Enter All to disaply all tables or Enter table name to display:
Books
Books.db
----------------------------------------------------------------
| Author | Title | CallNo |
----------------------------------------------------------------
| Burnett | The Scret | MN234 |
----------------------------------------------------------------
| Wesley | Journal | PQ945 |
----------------------------------------------------------------
| Pushkin | Evgeny | MN234 |
----------------------------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
n
------------------------------------------------------------
Redirecting to Home Page..
------------------------------------------------------------
------------------------------------------------------------
You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
i
INSERT operation has been chosen
-----------------------------------------------------------------
Choose Table name:
People
-----------------------------------------------------------------
Enter SSN:
12345678
-----------------------------------------------------------------
Enter Name:
Duff
------------------------------------------------------------
************Record is inserted Successfully********************
------------------------------------------------------------
If you would like to create more tables, Type 'Yes' or 'No' (y/n):
y
------------------------------------------------------------
-----------------------------------------------------------------
Choose Table name:
8766543356
------------------------------------------------------------
Table name doesn't exist. So, Please try AGAIN
------------------------------------------------------------
-----------------------------------------------------------------
Choose Table name:
Butler
------------------------------------------------------------
Table name doesn't exist. So, Please try AGAIN
------------------------------------------------------------
-----------------------------------------------------------------
Choose Table name:
People
-----------------------------------------------------------------
Enter SSN:
987654367
-----------------------------------------------------------------
Enter Name:
Butler
------------------------------------------------------------
************Record is inserted Successfully********************
------------------------------------------------------------
If you would like to create more tables, Type 'Yes' or 'No' (y/n):
n
------------------------------------------------------------
Redirecting to Home Page..
------------------------------------------------------------
------------------------------------------------------------
You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
p
PRINTFILE operation has been chosen
Enter All to disaply all tables or Enter table name to display:
People
People.db
-------------------------------------------
| SSN | Name |
-------------------------------------------
| 12345678 | Duff |
-------------------------------------------
| 987654367 | Butler |
-------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
y
------------------------------------------------------------
Enter All to disaply all tables or Enter table name to display:
Books
Books.db
----------------------------------------------------------------
| Author | Title | CallNo |
----------------------------------------------------------------
| Burnett | The Scret | MN234 |
----------------------------------------------------------------
| Wesley | Journal | PQ945 |
----------------------------------------------------------------
| Pushkin | Evgeny | MN234 |
----------------------------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
y
------------------------------------------------------------
Enter All to disaply all tables or Enter table name to display:
all
People.db
-------------------------------------------
| SSN | Name |
-------------------------------------------
| 12345678 | Duff |
-------------------------------------------
| 987654367 | Butler |
-------------------------------------------
Books.db
----------------------------------------------------------------
| Author | Title | CallNo |
----------------------------------------------------------------
| Burnett | The Scret | MN234 |
----------------------------------------------------------------
| Wesley | Journal | PQ945 |
----------------------------------------------------------------
| Pushkin | Evgeny | MN234 |
----------------------------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
n
------------------------------------------------------------
Redirecting to Home Page..
------------------------------------------------------------
------------------------------------------------------------
You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
r
REMOVE operation has been chosen
Enter the table to perform remove operation:
Books
[[Author, Title, CallNo], [Burnett, The Scret, MN234], [Wesley, Journal, PQ945], [Pushkin, Evgeny, MN234]]
Enter Author:
Burnett
Enter Title:
The Secret
Enter CallNo:
MN234
------------------------------------------------------------
Values not found. So, Please try AGAIN
------------------------------------------------------------
Enter the table to perform remove operation:
Books
[[Author, Title, CallNo], [Burnett, The Scret, MN234], [Wesley, Journal, PQ945], [Pushkin, Evgeny, MN234]]
Enter Author:
Burnett
Enter Title:
The Scret
Enter CallNo:
MN234
[[Author, Title, CallNo], [Wesley, Journal, PQ945], [Pushkin, Evgeny, MN234], [#Burnett, The Scret, MN234]]
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
n
------------------------------------------------------------
Redirecting to Home Page..
------------------------------------------------------------
------------------------------------------------------------
You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
p
PRINTFILE operation has been chosen
Enter All to disaply all tables or Enter table name to display:
Books
Books.db
----------------------------------------------------------------
| Author | Title | CallNo |
----------------------------------------------------------------
| Wesley | Journal | PQ945 |
----------------------------------------------------------------
| Pushkin | Evgeny | MN234 |
----------------------------------------------------------------
| #Burnett | The Scret | MN234 |
----------------------------------------------------------------
------------------------------------------------------------
Type 'Yes' or 'No' (y/n) to Continue:
n
------------------------------------------------------------
Redirecting to Home Page..
------------------------------------------------------------
------------------------------------------------------------
You are on the menu
c - CREATE i - INSERT p - PRINTFILE r - REMOVE e - EXIT
type anyone of operations to perform (c/i/p/r/e) & click ENTER:
e
EXIT operation has been chosen
[[SSN, Name], [12345678, Duff], [987654367, Butler]]
[]
[[file name, column name, size], [Books, Author, 20], [Books, Title, 10], [Books, CallNo, 8], [People, SSN, 16], [People, Name, 20]]
[]
[[Author, Title, CallNo], [Wesley, Journal, PQ945], [Pushkin, Evgeny, MN234]]
[]
-
Notifications
You must be signed in to change notification settings - Fork 0
Duq Database Management System Assignments
License
sindhusweety/DBMS-Assignments
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
Duq Database Management System Assignments
Topics
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published