In this figure I created a database ABCLibrary and inserted new tables to it

In this figure i created a database abclibrary and

This preview shows page 15 - 20 out of 20 pages.

-In this figure, I created a database ABCLibrary and inserted new tables to it that can be used later on. These tables are book, customers, and book order. 2. Create a GUI application that can insert, delete and modify the book information in ABCLibrary Database.
Image of page 15
-This is the main window from the GUI that I created. -This the GUI when you insert record to the abc library.
Image of page 16
3. Create stored procedures that can insert, delete and modify the book information using the book table in ABCLibrary database.
Image of page 17
4. Call the stored procedures from your book information.
Image of page 18
------------------------------------------------------------------------------------------------------------ --------- SUMMARY: The topics that were discussed in this activity lab are: Use of host Use of port Use of db in mysql Use of user in mysql Use of password even if it is optional Use stored procedure, function and trigger inside a program. Connecting mysql and ssms into an application or program Difference between SSMS vs MySQL CONLCUSION: In this lab activity I conclude that SSMS is better than MySQL because some parts in MySQL are limited like the stored function, in MySQL you can only use scalar function while in SSMS you can use Inline single table, multi- line table and scalar function. RECOMMENDATION: I recommend to use SSMS than MySQL because if you’re going to make an application or program that shows table or uses table it’s better to use SSMS.
Image of page 19
LESSON LEARNED: In this laboratory activity I learned: Use of host Use of port Use of db in mysql Use of user in mysql Use of password even if it is optional Use stored procedure, function and trigger inside a program. Connecting mysql and ssms into an application or program Difference between SSMS vs MySQL
Image of page 20

You've reached the end of your free preview.

Want to read all 20 pages?

  • Fall '16
  • Microsoft SQL Server, Stored procedure

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors