-
Notifications
You must be signed in to change notification settings - Fork 0
/
Readme.txt
48 lines (35 loc) · 1.67 KB
/
Readme.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Database Design
Implemented a rudimentary Database Design based on SQL, called VroomBase. VroomBase support actions on a single table at a time, no joins or nested queries.
Upon launch, engine will present a prompt similar to the MySQL mysql> prompt or SQLite sqlite> prompt, where interactive commands may be entered :-
VroomBase>
Technical Dependency –
System should have Eclipse or Netbeans installed.
a. If Eclipse is not installed, please click here to download and then install –
http://www.eclipse.org/downloads/eclipse-packages/
Programming Languages Used –
a. JAVA
Instructions to execute – Assuming user has installed Eclipse :-
a. Import the project in Eclipse and hit “Run” choosing “DesignMain.java” file
b. For help, execute “help;” – this will provide the list of supported commands.
Supported Commands –
All commands below are case insensitive
CREATE database database_name;
Create new database.
CREATE table table_name (id int, name varchar);
Create new table under respective database.
USE database_name;
Switched to new database.
SHOW tables;
Display all tables under respective database.
SELECT * FROM table_name;
Display all records in the table.
SELECT * FROM table_name WHERE rowid = <value>;
Display records whose rowid is <id>.
DROP TABLE table_name;
Remove table data and its schema.
DROP Database database_name;
Remove database and its table.
HELP;
Show this help information.
EXIT;
Exit the program.