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.
Observation: This the GUI when you insert record to the abc library.
3. Create stored procedures that can insert, delete and modify the book information using the book table in ABCLibrary database.
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.
Observation: The use of this syntax is to call the stored procedure in the book information.
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
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
- Fall '16