Follow us:-

This Unit aims to cover the knowledge of Computer Hardware and Networking, which is essential to the discipline of Software Engineering to setup/maintain and troubleshoot problems related to Computer Hardware and Network Environments.

  • Total Hours
    170
    Total Hours 170

Lecturers

Mr Tharaka Sankalpa


Mr Achintha Lakshan


Mr Thilina Rajakaruna


Mr Eshan Oshadha


This Unit aims to enhance the student?s knowledge and skills pertaining to the core concepts of databases, database system environments, database designing, implementing and using Structured Query Language (SQL) in order to fulfill the requirements of industry-level database management systems.

  • Total Hours
    190
    Total Hours 190
Tharaka sankalpa

Tharaka sankalpa

Director
Database Management System
Thilina Rajakaruna

Thilina Rajakaruna

Demonstrator
Database Management System
Lahiru Viraj

Lahiru Viraj

Demonstrator
Database Management System
Maneesha Dasanayake

Maneesha Dasanayake

Demonstrator
Database Management System

Continuous Assessments

1
Using MySQL Workbench Software or HediSQL Software to create a table in the database.
2
Using MySQL Workbench Software with ER Diagram to create a database and table
3
Using MySQL Workbench software to create a table with a database and a table using the ER Diagram and create relationships between creating tables. (One-to-many)
4
Using MySQL Workbench software to create a table with a database and a table using the ER Diagram and create relationships between creating tables. (Many-to-Many)
5
Create a database with MySQL Workbench software or HeidiSQL software and insert data using the Insert Query Statement into the table of the database that created and created the table.
6
Create a database with MySQL Workbench software or HeidiSQL software and use the Insert Query Statement to insert data into the table in the created database and modify the entered data.
7
Using MySQL Workbench Software or HeidiSQL Software to create a Database and Table and insert data from the Insert Query Statement into the table of the created database and use Delete Query Statement to remove the entered data.
8
Using MySQL Workbench Software or HeidiSQL Software to create a database and table and graphically add data to the table in the created database and use Search Query Statement to find the entered data.
9
Using the MySQL Workbench Software or HeidiSQL Software to create a database and table and graphically add data to the table in the created database and use the WHERE Clause to write the Search Query Statement to search for the entered data.
10
Create a Database and Table using MySQL Workbench Software or HeidiSQL Software. Graphically insert data into the table in the created database. Create a Join Query to connect to tables using entered data tables and search data using created tables.
11
Explain how to create a table for storing employee information as mentioned in the problem when creating an ER diagram related to a given problem using the MySQL Workbench software.
12
Explain how to create a table for storing customer and supplier information as mentioned in the problem when creating an ER diagram related to a given problem using MySQL Workbench software.
13
Explain how to create a table for storing information on products and suppliers' bills and items purchased from suppliers as described in the problem when creating an ER diagram using a MySQL Workbench software.
14
Explain how to create an ER diagram for a given problem using the MySQL Workbench software and create a table to store the information on the sold product items as mentioned in the problem.
15
Explain how to create a Relationship from the tables created as mentioned in the problem when creating an ER Diagram related to a given problem using the MySQL Workbench software.
16
Explain how to create a Normalized Database table as mentioned in the problem when creating an ER diagram related to a given problem using MySQL Workbench software.
17
Explain how to create a relationship between the tables in a normalized database created as mentioned in the problem when creating an ER diagram related to a given problem using the MySQL Workbench software.
18
Explain how to create a database using Froward Engineering and graphically add data to the tables to the ER Diagram created for a problem.
19
Explain how to use query statement to enter data, modify data, delete data, search data.
20
Explain how to use SQL Functions such as maximum value, minimum value, data row count using the given data.
21
Explain how to use SQL Functions and sub query such as maximum value and minimum value using the given data.
22
Explain how to use the JOIN keyword to join data storage, tables and how to search for data using joined tables.
23
Explain how to use Sub Query to search for data in data storage tables.
24
Explain how to search for data by Sub Query and JOIN uses the data in the stored tables and how to arrange the result in ascending and descending order and how to use the BETWEEN keyword.
25
Explain how to use the Average SQL Functions using the data in the Database Tables.
26
Explain how to use the data usage SUM SQL Functions in Database Tables.
27
Explain how to use COUNT SQL Functions and INNER JOIN use the data in the Database Tables.
28
Explain how to use MAX SQL Functions and INNER JOIN use the data in the Database Tables.
29
Explain how to use ROUND, MIN, AVG SQL Functions and INNER JOIN uses the data in the Database Tables.
30
Explain how to use the INNER JOIN with CHAR_LENGTH, CONCAT, UPPER, LOWER, AVG SQL Functions using the data in the Database Tables.
31
Explain uses MySQL Workbench Software or HeidiSQL Software how to create the tables required to store the details of the users who use the software while creating the Inventory Control software.
32
Explaining how to draw ER Diagram using MySQL Workbench software to create a table for storing information about billing issued by suppliers, billing information issued to customers, store stock details when creating an Inventory Control software.
33
Explain the relationship between tables created for storing data in Inventory Control software using MySQL Workbench software.
34
Create an Insert Query Statement to enter data into tables created to store the details of the users who use the software when creating Inventory Control software.
35
When creating an Inventory Control software, create an Insert Query Statement, which is required to enter data into tables created to store bill information provided by suppliers, bill information issued to customers, and store stock information.
36
Create SQL View Query to suit the given requirements.
37
Create SQL View Query to suit the given requirements.
38
Create a query to remove a pre-created SQL View.
39
Explain how to create a Relational Algebra Query using Select Operation related to a given need.
40
Explain how to create a Relational Algebra Query using Project Operation related to a given need.
41
Explain how to create a Relational Algebra Query using Rename Operation related to a given need.
42
Explain how to create a Relational Algebra Query using a Cartesian product related to a given need.
43
Explain how to create a Relational Algebra Query and a Relational Algebra Query related to a given query using Select Product related to a given need.
44
Create a database with DDL Query and explain how to create a table using the created database.
45
Explain how to create a table with foreign key using DDL Query.
46
Explain how to insert data into tables created using DDL Query.
47
Explain how to insert a new column with a DDL query and how to insert data into a created table.
48
Create a query statement relevant to updating, searching and creating a view of the data in the tables in the database.
49
Explain the DDL Query used to back up the created database.
50
Explain the DDL Query used to restore a backup database.

For the development of business software applications, it is essential to be aware of business environments.

This unit focusses on providing a perception of business environments to absolute beginner students in the discipline of Software Engineering in order to design Software Applications for business requirements. They are trained to empirically understand the nature of a business environment by developing physical business models and by completing methodically designed various activities. These activities are specially designed to develop the insight of students to carry out certain steps of a typical Software Engineering Lifecycle such as requirement gathering, requirement analysing, and formulating analysed data using designing techniques, which are required to develop a software application.

The context of this unit does not focus on making students professionals in Professional Software Designing and Modelling Techniques but this module aims to develop the perception of the student in software designing. Furthermore, students are expected to learn advanced object oriented modelling and design techniques in the Unit “Software Engineering 1- Object Oriented System Analysis and Design” (H7DV 04).

  • Total Hours
    190
    Total Hours 190

Lecturers

Dr Bhatiya Tissera


Mr Tharaka Sankalpa


This Unit lays the essential mathematical foundation for the Discipline of Software Engineering that enables the student to competently engage in problem solving, mathematical computation and mathematical thinking.

  • Total Hours
    90
    Total Hours 90

Lecturers

Mr Prasad Weerathunga


Miss Kaushalya De Silva


Object-oriented programming is a method of programming based on a hierarchy of classes as well as on well-defined and cooperating objects. The applied knowledge of object-oriented programming is essential for the discipline of Software Engineering and this Unit covers the application of object-oriented programming concepts with the Java programming language. Furthermore, this Unit covers the students’ ability to critically evaluate capabilities, limitations and the overall concept of object-oriented programming as well as the essential programming techniques of the Java programming language.

  • Total Hours
    210
    Total Hours 190

Lecturers

Dr Bhatiya Tissera


Mr Tharaka Sankalpa


Mr Achintha Lakshan


Mr Thilina Rajakaruna


Mr Eshan Oshadha


Object oriented programming is a method of programming based on a hierarchy of classes and well-defined and cooperating objects. The applied knowledge of object oriented programming is essential for the discipline of Software Engineering and this Unit covers the application of object oriented programming concepts with advanced programing concepts of the Java Programming Language.

  • Total Hours
    160
    Total Hours 160

Lecturers

Dr Bhatiya Tissera


Mr Tharaka Sankalpa


Mr Achintha Lakshan


This Unit aims to develop the practical knowledge and skills in Standalone Software Application Development for Business Related Management Systems in any mid-level industry. Furthermore, this Unit provides knowledge and practical expertise to use GUI components/event handling, JDBC and ODBC connections, reporting, software finalising and to work with an Integrated Development Environment, which are all essentials in Software Application Development.

  • Total Hours
    240
    Total Hours 250

Lecturers

Dr Bhatiya Tissera


Mr Tharaka Sankalpa


Mr Maneesha Dasanayake


Mr Achintha Lakshan


This Unit covers Object Oriented System Analysis and Design techniques that are essential to the Software Engineering Discipline and that are used to develop a logical system specification by analyzing user requirements.

  • Total Hours
    180
    Total Hours 180
Maneesha Dasanayaka

Maneesha Dasanayaka

Demonstrator
Object Oriented System Analysis and Design

Continuous Assessments

1
System Development Methodologies
2
Requirement gathering & fact finding techniques
3
Data Modeling Techniques
4
Use case Diagram
5
Activity Diagram
6
equence diagram
7
Collaboration Diagram
8
UML Class Diagram
9
State Diagram
10
Object Oriented Programming concepts

In order to complete this unit, the student should develop following Robotic Projects on an individual basis:
1) Obstacle avoiding Robort
2) Mobile Phone using Arduino & GSM
3) Robot Arm
4) Self Balancing Robort
5) Quadcopter

  • Total Hours
    180
    Total Hours 180

Lecturers

Dr Bhatiya Tissera


Mr Tharaka Sankalpa


Mr Maneesha Dasanayake


This Unit aims to deliver the knowledge and skills on database related web application development using web development languages. This Unit is intended to provide knowledge and skills to Design, Develop, Host and Maintain a web application.

  • Total Hours
    160
    Total Hours 360

Lecturers

Mr Tharaka Sankalpa


Mr Vishwa Nuwantha


Mr Lahiru Karunarathna


Mr Eshan Oshadha


Mr Maneesha Dasanayake


Continuous Assessments

1
Design a responsive user sign in and sign up page using HTML, CSS, JavaScript and Bootstrap
2
Program the user sign up process including input validations
3
Program the user sign in process
4
Develop a remember me add-on for sign in process
5
Develop a forgot password add-on for sign in process
6
Design a dynamic responsive homepage using HTML, CSS, JavaScript and Bootstrap
7
Develop a carousel for homepage using Bootstrap and JavaScript
8
Program the homepage including session management and latest products listing
9
Program the user sign out process using session management
10
Design a responsive user profile page using HTML, CSS, JavaScript and Bootstrap
11
Program the user profile updating process
12
Design a responsive product registration page using HTML, CSS, JavaScript and Bootstrap
13
Program the product registration process including image uploading
14
Program the product updating process
15
Design a responsive seller’s store page using HTML, CSS, JavaScript and Bootstrap
16
Program the seller’s store using product sorting and pagination
17
Program the seller’s product activation and deactivation process
18
Design a responsive product searching page using HTML, CSS, JavaScript and Bootstrap
19
Program the basic product searching process including pagination
20
Program the advanced product searching process including pagination
21
Program the product sorting process
22
Design a responsive single product view page using HTML, CSS, JavaScript and Bootstrap
23
Program the single product view page including the seller’s information
24
Design a responsive watchlist page using HTML, CSS, JavaScript and Bootstrap
25
Program the watchlist page including product adding and viewing process
26
Program the product removing process from the watchlist
27
Design a responsive cart page using HTML, CSS, JavaScript and Bootstrap
28
Program the cart page including product adding and viewing process
29
Program the cart total price calculation process including the delivery fee
30
Design a responsive product details pop-up modal in the cart section using HTML, CSS, JavaScript and Bootstrap
31
Program the product removing process from the cart
32
Design a responsive invoice page using HTML, CSS, JavaScript and Bootstrap
33
Program the product purchasing process through the PayHere payment gateway
34
Program the invoice page
35
Design a responsive purchase history page using HTML, CSS, JavaScript and Bootstrap
36
Program the feedbacks sending process to the purchased product
37
Design a responsive message page using HTML, CSS, JavaScript and Bootstrap
38
Program the message sending and viewing process
39
Design a responsive sign in page for admin panel using HTML, CSS, JavaScript and Bootstrap
40
Program the admin sign in process including the verification code
41
Design a responsive admin homepage using HTML, CSS, JavaScript and Bootstrap
42
Program the admin homepage including the summarized report
43
Design a responsive manage users page in admin panel using HTML, CSS, JavaScript and Bootstrap and program the user blocking process
44
Design a responsive manage products page in admin panel using HTML, CSS, JavaScript and Bootstrap and program the product blocking process
45
Design a responsive single product view modal in product page using HTML, CSS, JavaScript and Bootstrap
46
Design a responsive category registration modal in manage product page using HTML, CSS, JavaScript and Bootstrap and program the category registration and viewing process
47
Design view message modal in admin panel using HTML, CSS, JavaScript and Bootstrap
48
Program the message viewing and replying process
49
Design a responsive product selling history page in admin panel using HTML, CSS, JavaScript and Bootstrap
50
Program the product selling history page including product searching, viewing pending delivery products and daily selling products process

Students will integrate several technologies and will learn NoSQL databases and understand how their functionalities differ and will get the knowledge to choose databases proficiently according to the context

  • Total Hours
    100
    Total Hours 100

Lecturers

Mr Tharaka Sankalpa


Mr Achintha Lakshan


This unit aims to cover the main areas in regard to Research Methodology including the terminology, concepts, conventions and research methods where students will be given a practical experience on the systematic procedures by which research is conducted, enabling them to critically identify, describe and formulate conclusions based on hypothesis testing while evaluating a study’s overall validity and accuracy.

Besides introducing the structure of a research environment, students will also be equipped with the cognitive skills and practical knowledge required to define and provide feasible solutions for problems arising in the industry through research and experimentation in order to reduce risks and to improve efficiency.

This unit will also provide a stable base for advanced research techniques and research paper publishing in order to formulate a path towards the doctoral levels.

  • Total Hours
    40
    Total Hours 40

Lecturers

Prof Rasika Aponsu


Web and mobile developers can use React Native to create cross-platform apps that work as well as natively created apps. This library can be used to create a wide variety of applications. React Native's simplicity and extensibility make it a good match for any mobile project, from e-commerce to gaming.

  • Total Hours
    200
    Total Hours 200

Lecturers

Mr Tharaka Sankalpa