A SIWES report on software Engineering

Type Siwes (I.T.) Reports
Faculty Engineering, Environment & Technology
Course Computer Science
Price ₦2,000
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