Observation I created a database named ABCLibrary with three tables named book

Observation i created a database named abclibrary

This preview shows page 14 - 21 out of 21 pages.

Observation: I created a database named ABCLibrary with three tables named book, customers and book_order. The book table consist of bookid, bookname, authored, price, copyright year and stock quantity, The customers table consist of customerid, bookid, quantity and copyright year. Lastly the book order table consist of bookid, price, quantity and valid date. All columns have their respective data types. 2. Create a GUI application that can insert, delete and modify the book information in ABCLibrary Database. Observation: This is the main window from the GUI that I created.
Image of page 14
Observation: This the GUI when you insert record to the abc library.
Image of page 15
3. Create stored procedures that can insert, delete and modify the book information using the book table in ABCLibrary database.
Image of page 16
Observation: The above image is a stored procedure for inserting, deleting and modifying the book information using the book table in ABCLibrary database. 4. Call the stored procedures from your book information.
Image of page 17
Observation: The use of this syntax is to call the stored procedure in the book information.
Image of page 18
SUMMARY: MySQL is the database management system. It is also referred to as an Open-source relational database management system (RDBMS). It supports all platforms like Windows, Mac OS, Solaris, Free BSD, Linux, etc. SQL Server is defined as a relational database management system (RDBMS). It supports the platforms that are Linux, Microsoft Windows, and Windows server. SQL Server provides the language drivers to connect easily with any code. The features of MySQL are support to cross-platform, stored procedures, triggers, cursors, data definition language, ACID compliance, SSL support, views updatable, partitioning, Indexing, select, commit grouping, Unicode support and many more. There are certain limitations in My SQL. In MySQL, Triggers are limited to only one action per timing. It means only one trigger can be executed on the table if any event happens on the table. Triggers cannot be defined on views as well. Unlike in SQL Server where it provides high scalability as it can be used for small projects as well as large applications. It helps in taking care of millions of transactions per day. It gives better performance and high speed while retrieving the data for the application. To connect MySQL to SSMS, first you need to have all the necessary drivers and modules to allow your application’s connection to the
Image of page 19
application. In the Python programming language, there are several modules/packages available to install in order to establish connection to a SQL Database such as MySQL or MS SQL. In MySQL, one of the widely used
Image of page 20
Image of page 21

You've reached the end of your free preview.

Want to read all 21 pages?

  • Fall '16

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

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes