Create a small application that will interact with your database that you have b

Question

Create a small application that will interact with your database that you have been working on throughout the term. To work towards this goal, do the following:

Think of a scenario where you might need to add records to your database (e.g., adding a new student, enrolling a student in a class). Create a mockup of what a graphical interface might look like for this scenario. Paste this mockup into a Word document and include a paragraph justifying why this is a “good” design with support from the assigned reading.

In the high-level language of your choice, create a text-based application that prompts the user for inputs and adds a single record to a table in your database. You needn’t create a functioning GUI, but you may receive up to a 10% bonus on your assignment if you create a GUI instead of a text-based app. This may require some extra reading and investigation to accomplish.

Paste screenshots of your code, executing program, any resulting output, and the database table(s) with new row(s) added into your Word document.

Write a paragraph justifying your choices for the language, provider, and API. Include your considerations for the environment in which this app would run, the project team that would create/maintain it, and its intended audience and purpose.

Explanation / Answer

1) To create a small desktop application, it is best to use Netbeans Swing and AWT with drag and drop feautures. You can make the GUI by just dragging and dropping the components like textbox, buttons and create windows.

2) For database part use can use MySQL with XAMPP server and access it through localhost/phpmyadmin/index.php.

3) The GUI part would contain fields such as name, surname, class, division, rollno, bloodgroup, address, mobile, parents_mobile, etc whichever fields you may need. Finally a submit button to submit your data to the database.

4) This desktop app would run on any environment as it is created in JAVA.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.