A Step By Step To Database Programming Using Python GUI and MariaDB

Vivian Siahaan, Rismon Hasiholan Sianipar

Beschreibung

In this book, you will create two desktop applications using Python GUI and MariaDB. This book is mariadb-based python programming Intentionally designed for various levels of interest and ability of learners, this book is suitable for students, engineers, and even researchers in a variety of disciplines. No advanced programming experience is needed, and only a few school-level programming skill are needed.
In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes.
In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets.
In third chapter, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables.
In fourth chapter, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables.
In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables.
In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.
In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table.
In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables.
In chapter nine, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Verfügbar seit: 31.01.2020.

Wissenschaft & Technologie

Weitere Bücher, die Sie mögen werden

The Backyard Homestead Manual -...

Chase Bourn

Save yourself from more than half of the trouble most beginning and advanced homesteaders have to deal with.
Homestead gardening has exploded over the last few years. One in three US households now gardens to provide food for their families.
There are a variety of reasons why people are getting into gardening in such numbers. At the top of the list is that you can ensure the quality and nutrition of their fruits and vegetables.You also maintain control over where and how they’re produced so they know they’re safe.
If you have a garden or are considering one, now is the perfect time to start or take it to the next level. Optimizing your efforts provides superb results that no grocery store could ever compete with.
It’s also the start of a self-reliant lifestyle because once you get proficient in gardening for food, it has real economic benefits both meeting actual needs and saving money.
Are you wondering if this kind of gardening will work in your backyard?
The answer is 100% yes, it will work because there are plants and gardening techniques that work for all sorts of living situations.
All you need is a basic understanding of particular plants and their needs to make sure you can live a self-sufficient life as a homesteader.
In The Backyard Homestead Manual, you ll discover:- A gardener’s framework for effective planning to ensure your harvest is sufficient- Different garden bed options to accommodate your available space- Straight-forward ways to improve the quality of your soil- Specialty fruits and vegetables that grow in tricky environments- 6 easy ways to ensure you eat well throughout the winter- 3 things you can't overlook if you want your plants to reliably grow- New strategies for getting rid of weeds that minimize your required time and effortAnd much more.<br /

Zum Buch

We Are A Growing God - And What...

Cyril James Skidmore

With simple words, Cyril James Skidmore summarizes the growing scientific evidence of the actual direction and purpose of our universe. He then shows us what that means for our lives and our relationships with one another and our world.

Zum Buch

The Golden Ratio

IntroBooks Team

The Golden Ratio is an irrational number and simultaneously an excellent technique which bestows a lot to those who are into the designing field. It helps in a number of things, which are essential for the proper construction of architecture as well as designing. The Golden ratio has a lot of names which are famous for the discrete tasks which can be performed by the Golden Ratio and so accordingly it is named. 
The Golden Ratio was used by a number of distinguished mathematicians and artists, which have also created some great masterpieces which are well-known and famous worldwide. These masterpieces include the many architectural buildings, sculptors, images, paintings, designs etc.  
The Golden ratio is an amazing technique and most probably the only one technique, which is present in a number of domains such as mathematics, physics, art, architecture, paintings etc. The Golden Ratio is directly related to nature, which makes it more interesting and easy going.

Zum Buch

101 Rare Plants of Wales

Lauren Marrinan

Wales has a rich and varied flora of about 1200 native and anciently-introduced flowering plants, conifers and ferns. 
 
Amongst these are many special plants ranging from arctic-alpine relics of the last Ice Age to recently evolved species and medicinal herbs. They range from short-lived annual grasses to long-lived trees and vary ecologically from those growing on the sea shores to those on the tops of mountains. 
 
Some are widespread around the world and some are endemics only found in Wales. The aim of this book is to celebrate 101 of our rarer Welsh plants, to summarise what is currently known about them and to raise their profile in the national consciousness.

Zum Buch

Introduction to Agile Modeling

Kevin Aguanno

During requirements gathering and solution design, one of the most common techniques used to create a shared vision is modeling. Over the years, many tools and techniques have emerged for modeling in different fields that take in to account the various complexities of the solutions involved; however, one drawback that most share in common is the need to understand a modeling language (or notation technique) to create or even read and understand the models.The agile management movement has turned its attention to modeling in an effort to streamline the process and to more efficiently deliver needed stakeholder value during the modeling process.  The result is a practice called agile modeling that focuses on creating models tailored to the specific information needs of their consumers, using language and techniques shared by both creator and consumer, and employing collaborative modeling strategies.In this short recording of a teleseminar, learn the underlying principles of agile modeling, some practical techniques that are used, and how you can get started today.

Zum Buch

The Heavens Proclaim His Glory -...

Thomas Nelson

“I can see how it might be possible for a man to look down upon the earth and be an atheist, but I cannot conceive how he could look up into the heavens and say there is no God.”  Abraham LincolnOur world displays the handiwork of God all around us—in the land and sea, the animals and the plants. But in respect to the sky, the heavens, the universe…there’s a realm of beauty and creation man has not been able to witness, until now.  The Heavens Proclaim His Glory is a compilation of stunning photography taken by NASA’s Hubble®  Telescope capturing striking images of stars, galaxies, cosmic events, planets, and more. Vivid up-close photographs are paired with a romantic Psalm or quote, as well as a short description of the image. The Heavens will open up a whole new world of worship and praise for our God. Contributors include: Francis Chan, Mike Huckabee, John MacArthur, Stephen Mansfield, Sarah Young, Max Lucado, Jenna Lucado, Henry & Richard Blackaby, Robert Morgan, Kirk Cameron, Homer Hickam, and more.

Zum Buch