U16-KLO1.1-2.1-2.2-2.3

Open Ended

Layers to read about:

Business Logic Layer

Data-Access Layer

User Interface Layer

Questions

What is a multi-layer application and why is it used in software development?

How do the three layers communicate or interact with each other?

What is the purpose of the User Interface layer?

Can you give two examples of UI elements in a software application?

What types of decisions or operations are handled in the Business Logic layer?

Why is this layer sometimes called the “brain” of the application?

What is the role of the Data-Access layer in a system?

Match

Match the following

• Presentation Layer

• Application Layer

• Data Layer

(UI)

(Logic)

(Database)

• (UI)

• (Logic)

• (Database)

Match

Match the following

• Presentation Layer (UI)

• Application Layer (Logic)

• Data Layer (Database)

This is what the user sees on the screen

This part thinks and makes decisions.

This part stores the information.

• This is what the user sees on the screen

• This part thinks and makes decisions.

• This part stores the information.

Multiple Choice

Which of the following is NOT a benefit of using a multi-layer application?

• It makes the program easier to fix or update.

• Each layer has its own job.

• It combines all functions into a single layer.

• It helps the program work better.

Multiple Choice

Which layers are typically found in a multi-layer application?

• User Interface Layer, Data-Access Layer, Business Logic Layer

• Presentation Layer, Security Layer, Data Layer

• Application Layer, Network Layer, Database Layer

• Frontend Layer, Backend Layer, Storage Layer

Categorize

Options (11)

The part a person sees on the screen

Buttons, text, and menus

I click and type here

It is the face of the app

Helps me talk to the app

I don’t need coding to use it

This part of the app thinks

It makes decisions

Hidden from the user

Keeps data safe

Organizes information

Organize these options into the right categories

UI

not UI

Multiple Choice

Which of the following is NOT a main feature of the UI layer?

• Buttons

• Menus

• Database tables

• Messages

Multiple Choice

Which of the following is NOT a reason why a user interface should be easy to use, attractive, clear, and responsive?

• Users can quickly understand what to do

• It looks nice and organized

• It makes the app harder to use

• It works well on phones, tablets, and computers

Open Ended

What three main parts can you see in the picture?

Which part is in the middle between the other two?

Why do you think it is in the middle — what could its job be?

What direction do the arrows go?

What might that mean?

What do you think the Database does?

The middle box is called “Data Access Layer.” What do you think the words “data” and “access” mean?

Put them together — what could “Data Access Layer” mean?

Dropdown

1. What three main parts can you see in the picture?​

Select answer

2. Which part is in the middle between the other two?​ ​

Select answer

3. Why do you think it is in the middle, what could its job be?​ ​

Select answer

4.What direction do the arrows go? What might that mean?​

Select answer

5.What do you think the Database does?​ ​

Select answer

​6. The middle box is called “Data Access Layer.”What do you think the words “data” and “access” mean?
“Data” means information. “Access” means to get, use, or reach something.

7. Put them together — what could “Data Access Layer” mean?
It means the part of the system that gets and sends information from and to the database.It is like a helper that manages the data so the website can use it safely.

Poll

What is the role of the Data-Access Layer in an application and why is it important?

• It shows the buttons, pictures, and text that users click on, helping them use the system easily.

• It stores, finds, and manages data in the database, helping keep information safe and organized.

• It controls the colors, fonts, and layout of the website, making it look attractive.

Multiple Select

What are two ways the Data-Access Layer helps protect and manage data in an application?

• Controls how the app connects to the database

• Helps the system follow rules for reading and writing data

• Makes the user interface more complex

• Keeps data and code separate

Categorize

Options (16)

The part a person sees on the screen

Buttons, text, and menus

I click and type here

It is the face of the app

Helps me talk to the app

I don’t need coding to use it

This part of the app thinks

It makes decisions

Keeps data safe

Organizes information

This part stores information

It finds information when needed

It saves and takes out data

It talks to the app’s database

Users cannot see this layer

Checks rules

Organize these options into the right categories

UI

Data Access layer (DAL)

not UI or DAL

Poll

What do you think the Business Logic Layer (Logic Layer) does in an application?

• It shows buttons, text, and images to the user.

• It stores and finds data in the database.

• It thinks for the app and makes decisions using rules.

Poll

What is a main job of the Business Logic Layer?

• To make decisions and check rules.

• To save and search for data in the database.

• To show menus, buttons, and pictures.

Poll

The Business Logic Layer helps the app:

• Look nice for the user.

• Think and decide what to do next.

• Turn data into pictures and videos.

Poll

Which sentence is true about the Business Logic Layer?

• It is the "face" of the app.

• It is the "brain" of the app.

• It is the place where data sleeps.

Poll

Which example best matches the Business Logic Layer?

• Checking if a password is correct.

• Showing a login screen/form

• Saving username and password in a database.

Word Cloud

describe BLL using 1 or 2 words

BLL

1. The Business Logic Layer is the brain of an application.

2. It is usually in the middle, between the part the user sees (UI) and the part that stores information (Database).

3. This layer helps the app think, follow rules, and make decisions.

4. For example, it can check if a password is correct or decide what should happen next.

5. It does not show buttons or pictures, and it does not store data.

6. It just helps the app do the right thing.

Poll

Where is the Business Logic Layer usually found?

• At the top, where users click and type (UI).

• In the middle, between the UI and the Data.

• At the bottom, where data is stored (Database).

Multiple Choice

Which of the following best describes the role of the Business Logic Layer (BLL) in an application?

• It stores all the data for the application.

• It displays the user interface to the user.

• It contains the rules, calculations, and decisions that define how the business operates.

• It manages the network connections.

Multiple Choice

Which of the following are benefits of separating the Business Logic Layer from other layers in an application?

• Easier maintenance

• Reusability

• Better testing

• All of the above

Categorize

Options (13)

HTML

PHP

SQL

CSS

JavaScript

Python

Ruby

Java

C#

MongoDB

PostgreSQL

Oracle

SQLite

Organize these options into the right categories

UI

BLL

DAL

Categorize

Options (16)

The part a person sees on the screen

Buttons, text, and menus

I click and type here

It is the face of the app

Helps me talk to the app

I don’t need coding to use it

This part of the app thinks

It makes decisions

Keeps data safe

Organizes information

This part stores information

It finds information when needed

It saves and takes out data

It talks to the app’s database

Users cannot see this layer

Checks rules

Organize these options into the right categories

UI

Data Access layer (DAL)

BLL

Categorize

Options (11)

Network

OODB

Hierarchical

RDB

Flat-file

Text File

CSV File

JSON File

HTML Document

Image File

Audio File

Which of the followings are DB types/Structure

DB

not DB

Categorize

Options (17)

Single table, rows & columns

CSV, Excel

Use: Simple data storage, small datasets

Tree-like, parent-child relationships

Use: Data with strict hierarchy (e.g., organization charts)

Data stored in a single file

Use: Easy to read and write for humans

Data is organized in a tree structure

Graph structure, multiple relationships

Use: Complex data relationships

Flexible schema, allows for many-to-many relationships

Data represented as nodes and connections

Data organized in tables with relationships

Use: Complex queries and data manipulation

Examples: MySQL, PostgreSQL, Oracle

Data can be accessed using SQL (Structured Query Language)

example: XML documents

Organize these options into the right categories

Flat File Database

Hierarchical Database

Network Database

Relational Database

Multiple Choice

Which of the following best describes the main difference between relational databases and XML databases?

• Relational databases use tables with rows and columns, while XML databases store data in hierarchical structures.

• Relational databases store data in hierarchical structures, while XML databases use tables with rows and columns.

• Relational databases are optimized for processing XML data, while XML databases are optimized for relational data.

• Relational databases do not use schemas, while XML databases require schemas.

Multiple Select

Which of the following are advantages of using ODBC for database connectivity?

• It allows programs to connect to any database in the world.

• It automatically translates requests between different languages.

• It requires manual translation for each database type.

• It works behind the scenes to fetch data from different databases.

ODBC Vs.BLL

ODBC-XML-RDB - Group sort

You can open this webpage in a new tab.

Copy link

Open in new tab

Open Ended

What is one question you still have about data applications after today's session?