Key Features:
- No of Pages: 114
- No of Chapters: 08
- Contains diagrams
- Well researched and organized
Introduction:
Abstract
ABSTRACT
Welcome to an Industrial Training Report (ITR) that ushers you into an exciting world of Software
Engineering. This report provides some of the features that are important to students and anyone
that has interest in database development and Object Oriented Programming in java. These features
are discussed in details as:
The survival of contemporary businesses of today is hinged on the structure and quality of
her management, her technological know-how, communications capabilities, market power,
and compliance strategy.
Thus, Chapter 1 presents an overview of the company, her services, organizational structure.
Imagine building a powerful application that requires the use of a database without the basic
knowledge of how to build a database. Thus chapter two, INTRODUCTION TO
DATABASE AND ITS CONCEPT provides technical report on the various methods to
design and create a database which allows the Software Engineers to build a robust database
that will suit the need of the application.
Chapter three and four provides us with the basic STRUCTURED QUERY LANGUAGE
(SQL) knowledge for creating databases, populating a database and performing other basic
operations on the database.
Chapter five ushers us into the world of OBJECT ORIENTED PROGRAMMING IN JAVA,
teaching us some of the basic things that someone who is interested in Object OrientedProgramming should know.
Chapter six was a continuation of the concept of Object Oriented Programming, here we
treated JAVA CONTROL FLOWS AND ARRAYS.
Chapter seven we took a deeper look at Oriented Programming, here we discussed the basic
building block of an Oriented Programming.
Chapter eight we looked at developing Graphical User Interface using Drag and Drop
method, and the conclusion of this technical report.
Table of Content
TABLE OF CONTENT
Declaration
Dedication
Acknowledgement
Abstract
Introduction of SIWES
CHAPTER ONE CORPORATE PROFILE OF NEW HORIZONS SYSTEM SOLUTIONS1.1.
CORPORATE PROFILE OF NEW HORIZONS SYSTEM SOLUTIONS
1
CHAPTER TWO DATABASE AND ITS CONCEPT
2.1. INTRODUCTION TO DATABASE AND ITS CONCEPT 9
2.1.2. Definition of a Database 9
2.1.3. Relational Database Management System (RDBMS) 9
2.1.3.1. Relational Database 9
2.1.3.2. Relational Database Design Process 10
2.1.4. Basic Concept of a Relational Database
11
2.1.4.1. Table 11
2.1.4.2 Keys 12
2.1.4.3 Relationship 13
2.1.4.4 Entity Relationship Diagram (ERD) 14
2.1.4.4.1. The Chen ER Model 15
2.1.4.4.2. The Crow’s Foot ER Model 16
2.1.5. Normalization
17
2.1.5.1. The Normal Forms 18
2.1.6. Denormalization 19
CHAPTER THREE MY STRUCTURED QUERY LANGUAGE (MySQL)
3.1
20 INTRODUCTION TO MySQL 3.2 How to Launch MySQL Server 20
3.3 Data Types 21
3.4 Creating and Setting Up Database in MySQL Server
3.4.1. Creating a Database
3.4.2. Setting Up a Database to Use
22
22
3.5. Creating Tables
3.6. Creating Index 24
25
3.7. Inserting Data into a Table 25
3.8. Retrieving Data from a Table
3.8.1. Retrieving a Single Column
3.8.2. Retrieving a Multiple Columns 26
26
27
233.9. How to Update Data on a Table 28
3.10. How to Delete Data On A Table 30
3.11. Generating Reports Using Conditions
3.11.1. Conditional Statements
3.11.1.1. Operators 32
32
32
3.12. Generating Report from Multiple Tables 33
3.12.1. Types of Join 33
3.13. Generating Summary Reports 35
3.14. Customizing a Database 37
3.14.1. Adding and Removing Table Columns 37
3.14.2. Renaming Table and Columns 38
3.14.3. Changing the Data Type of a Column 39
CHAPTER FOUR STRUCTURED QUERY LANGUAGE (SQL) SERVER 2008
4.1. INTRODUCTION
40
4.2. How to Log On To SQL Server 2008 40
4.3. A Look at the SQL Query Analyzer Interface 40
4.4. Creating Database and Tables 41
4.5. Creating a Query 42
4.6. Data Manipulation Language Statements
42
4.6.1. Insert Statement 43
4.6.2. Select Statement 43
4.6.2.1. Optional Clauses of the Select Statement
4.6.2.1. 1. Where Clause
4.6.2.1.2. Group by Clause
4.6.2.1.3. Having Clause
4.6.2.1.4. Order By
4.7. Comments 44
44
44
45
45
464.8. Update Statement
46
4.9. Delete Statement 46
4.10. Conditional Operators 47
4.11. Working Functions 48
4.11.1. Date Functions
48
4.11.2. Aggregate Functions 50
4.11.3. String Functions
4.11.3.1. Case Conversion Functions 54
4.11.3.2. The Substring Function
54
55
4.11.3.3. Concatenation 56
4.11.4 Rank Data Using The Ranking Function 56
4.11.4 .1 The Rank Function 56
4.11.4 .2 The Dense_Rank Function 56
4.11.4 .3 The Row Number Function 57
4.12. Retrieving Data from a Table Using Joins
58
4.12.1. The Union Operator 58
4.12.2. The Except and Intersect Operands 59
4.12.3. The Cross Join 61
4.12.4. The Outer Join 62
CHAPTER FIVE JAVA PROGRAMMING LANGUAGE
5.1. INTRODUCTION TO JAVA PROGRAMMING LANGUAGE
5.2. Netbeans IDE 64
65 5.3 Using Netbeans To Write And Compile A Java Program 65 5.4. Our First Program in Java
5.4.1. Class Names and Identifiers 68
69
5.4.2. Access Modifiers
71
5.5. Data Types 71
5.5.1. Operators
5.5.1.1. Arithmetic Operator
5.5.1.2. Relational Operators
5.5.1.3. Logical Operators
5.5.1.4. Assignment Operator 71
71
72
73
74CHAPTER SIX JAVA CONTROL STATEMENTS AND ARRAYS
6.1. JAVA CONROL STATEMENTS
75
6.1.1. Sequence Structure
6.1.2. Selection Statement 75
75
6.1.2.2. If.....else statement 76
6.1.2.3. Conditional Operator (? :)
6.1.2.4. If...else if...else statement
77
78
6.1.2.5. Switch Multiple-Selection Statements
80
6.1.3. Java Loops 81
6.1.3.1.While Looping Statement 81
6.1.3.2. For Loop Statement
82
6.1.3.3. Do...while repetition statement 83
6.1.3.4. Break and Continue Statement 85
6.1.3.5. Break Statement 85
6.1.3.6. Continue Statement 86
6.2. Arrays in Java Programming Language 87
CHAPTER SEVEN OBJECT ORIENTED PROGRAMMING AND JAVA EXCEPTION HANDLING
7.1. OBJECT ORIENTED PROGRAMMING AND PROGRAMMING LANGUAGES 89
7.1.1. BASIC OBJECT TECHNOLOGY CONCEPTS 89
7.1.1.1. Classes 89
7.1.1.2. Objects 89
7.1.1.3. Constructors
89
7.1.1.4. Encapsulation 90
7.1.1.5. Inheritance 90
7.1.1.6. Polymorphism 91
7.1.1.7. Abstract Classes and Interface 91
7.1.2. Object Oriented Implementation 91
7.1.2.1 Inheritance
7.1.2.1.1. Constructors in Sub Classes 91
947.1.2.2. Polymorphism
7.1.2.2.1. Overriding as a Polymorphic Behavior
7.1.2.2. 2. Processing Objects Polymorphically 94
7.2. JAVA EXCEPTION HANDLING 99
7.2. 1. Catching an Exception 99
7.2.1.1 The Try Block 99
7.2.1.2. Exception Handlers 100
94
97
7.2.1.3 Using the Finally Block
101
CHAPTER EIGHT GRAPHICAL USER INTERFACE (GUI)
8.1. INTRODUCTION TO JAVA GRAPHICAL USER INTERFACE (GUI) 104
8.2. Swing and Awt
8.3. Getting Started
8.4. Creating a Jframe Container
8.5. Getting Familiar with the Gui Builder
8.6. Adding Components
8.7. To Resize the Panel 105
105
105
108
109
110
8.8. Setting Properties of the Components
8.9. Adding Events to Our Components 114
113
CONCLUSION 117
Introduction
The introduction of this research is only available in the paid version.
Buy Now