Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
A Step By Step To Database Programming Using Python GUI and MariaDB - cover

We are sorry! The publisher (or author) gave us the instruction to take down this book from our catalog. But please don't worry, you still have more than 500,000 other books you can enjoy!

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

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: SPARTA PUBLISHING

  • 0
  • 0
  • 0

Summary

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.
Available since: 01/31/2020.

Other books that might interest you

  • Social Media Marketing 2020 - A Complete Guide to How to Build Your Brand and become an Expert Influencer through Social Media Marketing on Instagram Facebook and You Tube - cover

    Social Media Marketing 2020 - A...

    Lucas Taylor

    • 0
    • 0
    • 0
    Build Your Brand and Become a Social Media Influencer With This Expert Guide! 
    Do you want your content to go viral? 
    Are you ready to build your brand for 2020? 
    SOCIAL MEDIA MARKETING IS HERE TO STAY! PROMOTE YOUR BUSINESS LIKE A PRO AND WIN NEW CUSTOMERS IN 2020! 
    In this day and age, if you have a business, chances are you also have an online presence. Traditional forms of marketing such as billboards and newspaper ads still exist, but they are rather insignificant compared to the reach of social media marketing. Almost every business, big and small, has a social media presence. Some companies rely entirely on their social media strategies to bring new customers and increase revenue! 
    When we talk about SMM, we are talking about a two-way street. Whether you’re using Facebook, Instagram or Youtube to promote your business, you’re doing it together with your customers. They can help you grow, or they can stop you in your tracks. It’s super important to build a loyal base of customers, and this is achieved by building a strong brand. Everyone responds to authenticity! 
    This book will tell teach you all about: Social Media Marketing, truth and liesMaking a great SMM strategyAvoiding mistakes on social mediaStrategies for creating viral videosInner workings of Instagram algorithmsFacebook campaigns that bring real followers! 
    Maybe you’re overwhelmed by the sheer number of social media channels? You don’t know where to start or where to focus your attention? No worries! This book is the ultimate guide on social media marketing in 2020, and it will teach you all you need to know to boost your brand and increase your revenue!
    Show book
  • The Hearts of a Girl - The Journey Through Congenital Heart Disease & Heart Transplant - cover

    The Hearts of a Girl - The...

    Jessica Carmel

    • 0
    • 0
    • 0
    A riveting medical memoir about a family’s journey through multiple surgeries, and a determined battle for survival.   Jessica Carmel was born with a severe congenital heart condition. When she was just four days old, her parents learned she would need heart surgery.   They had no idea that her future held multiple surgeries and even more unexpected challenges. Sixteen years later, as Jessica sat in her cardiologist’s office for a routine checkup, he told her and her mom that there was nothing more he could do for her. Jessica needed a heart transplant.   Three weeks later, Jessica underwent heart transplant surgery. Her recovery was long, but good—but about ten years later, she learned that she was in desperate need of a new kidney. Her only hope of survival was her sister, Amy—who heroically offered up one of her own kidneys. Now their mother would be seeing both of her daughters off to the operating room . . .   This remarkable story of one young woman’s journey through the medical maze—including financial struggles and battles with insurance companies—and a family’s determination to survive and thrive together, is both an informative, fascinating look at health care and an uplifting, inspiring read.
    Show book
  • Learn Python - A Crash Course On Python Programming and How To Start Coding With It Learn The Basics Of Machine Learning and Data Analysis - cover

    Learn Python - A Crash Course On...

    Damon Parker

    • 0
    • 0
    • 0
    Python programming language has rendered itself as the language of choice for coding beginners and advanced software programmers alike.  
    This book is written to help you master the basic concepts of Python coding and how you can utilize your coding skills to analyze a large volume of data and uncover valuable information that can otherwise be easily lost in the volume. Python was designed primarily to emphasize readability of the programming code, and its syntax enables programmers to convey ideas using fewer lines of code. Python programming language increases the speed of operation while allowing for higher efficiency in creating system integrations.  
    Some of the highlights of the audiobook include: 
    ● Step by step instructions on how to install Python on your operating systems (Windows, Mac, and Linux). 
    ● Learn how to create Python variables and assign desired data type to them. 
    ● Basic concepts of writing efficient and effective Python codes, focusing on various programming elements such as Booleans, Tuples, Sets, Dictionaries, and much more. 
    ● Learn the basic concepts of big data analysis and machine learning algorithms. 
    ● Brief overview of various renowned machine learning libraries such as Scikit-Learn, NumPy, SciPy, and more. 
    All the concepts are explained with standard Python coding syntax supported with relevant examples and followed by exercises to help you test and verify your understanding of those concepts. Finally, as an added bonus you will learn some Python tips and tricks to take your machine learning programming game to the next level. 
    Don't you think it can be that easy? If you really want to have proof of all this, don't waste any more time! 
    Grab your copy now!
    Show book
  • How Light Makes Life - The Hidden Wonders and World-Saving Powers of Photosynthesis - cover

    How Light Makes Life - The...

    Raffael Jovine

    • 0
    • 0
    • 0
    A revelatory journey into the beautifully intricate conversion of light into life, key to every living thing's survival—and our planet's futureWe think we know photosynthesis: Plants convert of sunlight, CO2, and water into energy and, ultimately, the food we eat and air we breathe. But Raffael Jovine shows how this incredible process goes beyond what we learned in grade school. First, it's not only about plants: Corals partner with photosynthetic organisms to create the most productive habitat on Earth, slugs eat chloroplasts to create a photosynthesis-based camouflage, hornets use photosynthesis for a very unconventional form of air conditioning—and much more!Further, photosynthesis can help save the world. Jovine's groundbreaking blueprint for the future harnesses photosynthesis to repair ecosystems, create jobs, and grow sustainable food. This book will help you to see the many surprising ways we can't live without this miracle of light—through the photosynthetic pigments in your own eyes!
    Show book
  • 101 Amazing Facts About Pokémon - cover

    101 Amazing Facts About Pokémon

    Merlin Mill

    • 0
    • 1
    • 0
    Did you know that the original Pokémon Gold and Silver were intended to be the last games in the series until the CEO decided to gamble on just one more generation? Or that Pokémon Go broke five Guinness World Records within a month of its release? Do you know which two starter Pokémon are the only ones with dual typing? Or in which regions the starter Pokémon stay pure to their type through each evolution? This fascinating audiobook contains over 100 amazing facts about Pokémon, with chapters including the games, the movies, statistics and so much more. So whether you’re the world’s biggest Poké-fan or you are completely new to the franchise, this is the perfect addition to your audiobook collection.
    Show book
  • Journey Into Wisdom - cover

    Journey Into Wisdom

    Pramila Jayapal

    • 0
    • 0
    • 0
    India, an ancient culture, has many gifts to share with the western world.  Pramila Jayapal, is an Indian-born, Western educated woman, banker turned community activist, who returns to India to explore the complex issues of progress and development, immersing herself in the life of her native land.
    Show book