Database Management System Using Visual C# .NET: MySQL, SQL Server, and Access

Database Management System Using Visual C# .NET: MySQL, SQL Server, and Access
Author : Vivian Siahaan
Publisher : BALIGE PUBLISHING
Total Pages : 740
Release : 2020-09-14
ISBN 10 :
ISBN 13 :
Language : EN, FR, DE, ES & NL


Book 1: VISUAL C# .NET WITH MYSQL: A Definitive Guide to Develop Database-Oriented Desktop Applications In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be more familiar when applying them to some applications in this book. In chapter two, you will go through step by step to build a SALES database using MySQL. You will build each table and add associated data fields (along with the necessary keys and indexes). The first field in the Client table is ClientID. Enter the clien ID in the Name Field and select AutoNumber in the Data Type. You define primary key and other indexes which are useful for quick searching. ClientID is a primary field. You will define FamilyName as an index. You then will create Ordering table with three fields: OrderID, ClientID, and OrderDate. You then will create Purchase table with three fields: OrderID, ProductID, and Quantity. And you will create Product table with four fields: ProductID, Description, Price, and QtySold. Before designing Visual C# interface, you will build the relationships between four tables. The interface will be used to enter new orders into the database. The order form will be used to enter the following information into the database: order ID, order date, client ID, client’s first name and family name, client’s address, product information ordered. The form will have the ability to add new orders, find clients, add new clients. The completed order invoice will be provided in a printed report. In chapter three, you will build a database management system where you can store information about valuables in your warehouse. The table will have seven fields: Item (description of the item), Location (where the item was placed), Shop (where the item was purchased), DatePurchased (when the item was purchased), Cost (how much the item cost), SerialNumber (serial number of the item), PhotoFile (path of the photo file of the item), and Fragile (indicates whether a particular item is fragile or not). The development of this Warehouse Inventory Project will be performed, as usual, in a step-by-step manner. You will first create the database. Furthermore, the interface will be built so that the user can view, edit, add, or add data records from the database. Finally, you add code to create a printable list of information from the database. In chapter four, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. The steps that need to be taken in building Siantar Air Quality Index (SAQI) database project are: Build and test a Visual C# interface; Create an empty database using code; and Report database. The designed interface will allow the user to enter max pollutant, min pollutant, and air quality for any date that the user chooses in a particular year. This information will be stored in a database. Graphical result of the data will be provided, along with summary information relating to the maximum value, minimum value, and mean value. You will use a tab control as the main component of the interface. The control has three tabs: one for viewing and editing data, one for viewing graph of pollutant data, and another for viewing graph of air quality data. Each tab on this control operates like a Visual C# control panel. In chapter five, you will perform the steps necessary to build a MySQL book inventory database that contains 4 tables. You will build each table and add the associated fields as needed. You will have four tables in the database and define the relationship between the primary key and foreign key. You will associate AuthorID (foreign key) field in the Title_Author table with AuthorID (primary key) in the Author table. Then, you want to associate the ISBN (foreign key) field in Title_Author table with ISBN (primary key) in the Title table. Book 2: Visual C# .NET For Programmers: A Progressive Tutorial to Develop Desktop Applications In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be more familiar when applying them to some applications in this book. In chapter two, you will go through step by step to build a SALES database using Microsoft Access and SQL Server. You will build each table and add associated data fields (along with the necessary keys and indexes). The first field in the Client table is ClientID. Enter the clien ID in the Name Field and select AutoNumber in the Data Type. You define primary key and other indexes which are useful for quick searching. ClientID is a primary field. If the small lock symbol is not displayed next to the ClientID row, then you need to place it there. Right click on ClientID row and select Primary Key. A small key is now displayed next to the entry indicating it is the primary key. You will define FamilyName as an index. Select the FamilyName line. On the General tab, set the Indexed property to Yes (Duplicates OK). You then will create Ordering table with three fields: OrderID, ClientID, and OrderDate. You then will create Purchase table with three fields: OrderID, ProductID, and Quantity. And you will create Product table with four fields: ProductID, Description, Price, and QtySold. Before designing Visual C# interface, you will build the relationships between four tables. In chapter three, you will build a Visual C# interface for the database. The interface will be used to enter new orders into the database. The order form will be used to enter the following information into the database: order ID, order date, client ID, client’s first name and family name, client’s address, product information ordered. The form will have the ability to add new orders, find clients, add new clients. The completed order invoice will be provided in a printed report. In chapter four, you will build a database management system where you can store information about valuables in your warehouse. The table will have seven fields: Item (description of the item), Location (where the item was placed), Shop (where the item was purchased), DatePurchased (when the item was purchased), Cost (how much the item cost), SerialNumber (serial number of the item), PhotoFile (path of the photo file of the item), and Fragile (indicates whether a particular item is fragile or not). The development of this Warehouse Inventory Project will be performed, as usual, in a step-by-step manner. You will first create the database. Furthermore, the interface will be built so that the user can view, edit, add, or add data records from the database. Finally, you add code to create a printable list of information from the database. In chapter five, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. You will do this in stages, from database development to creation of distribution packages. These steps are the same as those used in developing a commercial database application. The steps that need to be taken in building Siantar Air Quality Index (SAQI) database project are: Build and test a Visual C# interface; Create an empty database using code; and Report database. The designed interface will allow the user to enter max pollutant, min pollutant, and air quality for any date that the user chooses in a particular year. This information will be stored in a database. Graphical result of the data will be provided, along with summary information relating to the maximum value, minimum value, and mean value. You will use a tab control as the main component of the interface. The control has three tabs: one for viewing and editing data, one for viewing graph of pollutant data, and another for viewing graph of air quality data. Each tab on this control operates like a Visual C# control panel. In chapter six, you will perform the steps necessary to build a SQL Server book inventory database that contains 4 tables using Microsoft Visual Studio 2019. You will build each table and add the associated fields as needed. You will have four tables in the database and define the relationship between the primary key and foreign key. You will associate AuthorID (foreign key) field in the Title_Author table with AuthorID (primary key) in the Author table. Then, you want to associate the ISBN (foreign key) field in Title_Author table with ISBN (primary key) in the Title table.

More Books:

Database Management System Using Visual C# .NET: MySQL, SQL Server, and Access
Language: en
Pages: 740
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-09-14 - Publisher: BALIGE PUBLISHING

Book 1: VISUAL C# .NET WITH MYSQL: A Definitive Guide to Develop Database-Oriented Desktop Applications In chapter one, you will learn to know the properties an
VISUAL C# .NET WITH MYSQL
Language: en
Pages: 348
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-09-13 - Publisher: BALIGE PUBLISHING

In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be m
MYSQL with Visual Basic and Visual C#
Language: en
Pages: 645
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-11-20 - Publisher: BALIGE PUBLISHING

Book 1: This book aims to develop a MySQL-driven desktop application that readers can develop for their own purposes to implement library project using Visual B
LEARN FROM SCRATCH VISUAL C# .NET WITH MYSQL
Language: en
Pages: 684
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-10-05 - Publisher: BALIGE PUBLISHING

In Tutorial 1, you will start building a Visual C# interface for database management system project using MySQL. The database, named DBMS, is created. The desig
MYSQL FOR DATA ANALYSIS AND VISUALIZATION WITH PYTHON GUI
Language: en
Pages: 335
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-06-26 - Publisher: BALIGE PUBLISHING

In this project, you will use the Northwind database which is a sample database that was originally created by Microsoft and used as the basis for their tutoria
A Guide to Python GUI Programming with MySQL
Language: en
Pages: 541
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-01-14 - Publisher: SPARTA PUBLISHING

In this book, you will create two desktop applications using Python GUI and MySQL. In this book, you will learn how to build from scratch a MySQL database manag
MYSQL AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI
Language: en
Pages: 404
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-06-19 - Publisher: BALIGE PUBLISHING

In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in
FOUR PROJECTS: MySQL and SQLite For Data Science with Python GUI
Language: en
Pages: 1583
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-06-29 - Publisher: BALIGE PUBLISHING

PROJECT 1: SQLITE AND DATA SCIENCE: QUERIES AND VISUALIZATION WITH PYTHON GUI In this project, you will develop GUI with PyQt5 to: utilize Push Button, Combo Bo
THE BEST WAY TO LEARN JAVA GUI WITH MYSQL AND SQL SERVER
Language: en
Pages: 546
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-01-13 - Publisher: SPARTA PUBLISHING

This hands-on tutorial/reference/guide to MySQL and SQL Server is not only perfect for students and beginners, but it also works for experienced developers who
The Quick Way to Learn Java GUI with MySQL and SQLite
Language: en
Pages: 539
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-01-15 - Publisher: SPARTA PUBLISHING

This hands-on introduction to database programming using Java is ideal for people with little or no programming experience. The goal of this concise book is not