tag:blogger.com,1999:blog-2075934336716950892024-02-20T02:47:39.692-08:00GUIforMySQLAnonymoushttp://www.blogger.com/profile/14818377080567168658noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-207593433671695089.post-45739006702241548532014-06-02T00:53:00.004-07:002014-06-02T00:54:58.090-07:00GUI for MySQL<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">To interact with the
database and work with the tables in a database, one need to use Structured
Query Language (SQL) which includes features on defining structure of the data,
for modifying data in the database and for specifying security constraints. But
it is not possible for everyone to learn MySQL or any other query language.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">The project entitled
‘<b>Graphical user interface for MySQL (Enhanced)</b>’ is aimed at providing a user
friendly and single interface for working with different RDBMS like MySQL.</span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #262626; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-z511iPZsJXo/U4wtB4mCIuI/AAAAAAAAAHw/L1B33Lu5n_w/s1600/Poster.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-z511iPZsJXo/U4wtB4mCIuI/AAAAAAAAAHw/L1B33Lu5n_w/s1600/Poster.JPG" height="240" width="320" /></a></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #262626; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">The project is developed
keeping in mind that the user has no knowledge of any structural query
language.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">The main objective of the
system is to enable a user work with the databases and tables in a RDBMS even
if he/she doesn’t know how to use any SQL. <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">The project is aimed at
accomplishing the following: <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">• Create tables.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">• Add data to the tables.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">• Display tables in a form format.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">• Perform queries, without actually using SQL.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">• Import and save tables in .xls format.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;">• Make changes to the table form, and upload it to the
database.<o:p></o:p></span></div>
<span style="color: #f3f3f3;"><br /></span>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<span lang="EN-US" style="color: #f3f3f3; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-font-kerning: 0pt;"> This project has been developed by <b>Tanuj Dhaundiyal(9910103409)</b>, student of JIIT Noida, Sector-128, of F1 batch.</span></div>
<div class="MsoNormal" style="line-height: 150%; margin-bottom: 10.0pt; text-align: justify;">
<b>Helpful Links:</b></div>
<div class="MsoNormal" style="margin-bottom: 10pt; text-align: justify;">
<span style="line-height: 24px;">Video Link: http://youtu.be/dakvQysinj4</span></div>
<div class="MsoNormal" style="margin-bottom: 10pt; text-align: justify;">
<span style="line-height: 24px;">SlideShare Link: http://www.slideshare.net/slideshow/embed_code/35295738</span></div>
<div class="MsoNormal" style="margin-bottom: 10pt; text-align: justify;">
<span style="line-height: 24px;"><b>Reference Papers:</b></span></div>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 480; width: 786px;">
<tbody>
<tr style="height: 6.85pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0; mso-yfti-lastrow: yes;">
<td style="border: solid windowtext 1.0pt; height: 6.85pt; mso-border-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 400.8pt;" valign="top" width="668"><div class="MsoNormal">
<span lang="EN-US"><a href="http://www.ijcsit.com/docs/Volume%203/vol3Issue3/ijcsit2012030306.pdf">http://www.ijcsit.com/docs/Volume%203/vol3Issue3/ijcsit2012030306.pdf</a></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Lohit Hindi"; mso-bidi-language: HI; mso-fareast-font-family: "Droid Sans Fallback"; mso-fareast-language: ZH-CN; mso-font-kerning: .5pt;"><a href="http://www.hpl.hp.com/techreports/tandem/TR-90.10.pdf">http://www.hpl.hp.com/techreports/tandem/TR-90.10.pdf</a></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Lohit Hindi"; mso-bidi-language: HI; mso-fareast-font-family: "Droid Sans Fallback"; mso-fareast-language: ZH-CN; mso-font-kerning: .5pt;"><a href="http://www.cscjournals.org/csc/manuscript/Journals/IJCSS/volume6/Issue4/IJCSS-722.pdf">http://www.cscjournals.org/csc/manuscript/Journals/IJCSS/volume6/Issue4/IJCSS-722.pdf</a></span></div>
</td>
</tr>
</tbody></table>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/14818377080567168658noreply@blogger.com0