Project - Business Case/Use Case
Someone needs some tool to SSCET RESULS
Package(Main
Folder) perform some task on the web
Templates
Customer Roll No
(HTML)
Wants to develop functionality of
.Html business over internet (Web)
.js
projects which can be accessed Search
.css
.py via browser
Maths – 450/500
School wants to develop a Physics – 300/500
project in which students can
check their marks by entering total -
roll number
How to store my physical data in
Data computer?
(Physical Results Register
File/Register)
Results Roll, Number, Name, Class, Physics, Chem, Maths ,
Where to store? Total
Database 1 Divyani 12th A , 400, 500, 450 1350
2 Divyanshi 6th B , 400, 500, 450 1350
Which Database?
I have less than 1 There are multiple ways to store
million record Database(Stora data in computer
SQL Lite ge systems ) 1. Files (.txt, .excel, .word)
SQL LITE 2. Database (Oracle, SAP HANA,
SQL-Lite,
Schema (Set of table for a project ) MySQL, MongoDB…
School events) many databse)
Which Format?
Table
Create table
How we create <table>
table? SQL Command
SQL (Structured
Query Language)
Server Operations
Logic to process the business data is written using server
Database Layer Operations language in server
1. Collect Data How server is access ; via domain name /ip- address
2. Identify tables and relationship
between them (Data Model which language should be used to process the logic over
Diagram/ Entity-Relationship) database :
Diagram programming language
3. Create Schema( create tables with 1. Python
relationship ) – through SQL 2. [Link]
commands 3. Ruby
Data retrival/business
4. Data Entry – (through SQL 4. Java logics
command or code or file upload (tabular to json
tools) conversion)
(Search Screen, .json = Data
Server
Results) {name , (SQL Lite)
Anyone can access
Chrome Browser – age, SQL Queries
API/endpoint(URL which
Send Requests roll, table
take the request and
mars} return the resutls Database
[Link]
[Link]
Project Host
Data Processing
DBMS (Server – Python,
Data (SQL lite, SQL Connec
[Link], Java, Ruby…
Query) tor
Server Side
language )
DBMS holds complete data in
Tabular Format – Database layer .json
Server – It understand the request
from the client, fetches required Browser
data from database, process it for Json Processing & Mapping
the required request and send it to UI
back to UI/browser is desired (Java Script)
format (.json) with desired field) –
Server layer
Client (Browser) : It sends the HTML .CSS
request to the sever end point
(URL) and gets the response;
process the response through java
script , maps to using .CSS file to
the HTML page layout ( UI layer)
Data Database
- Database (SQL Lite, Postgres, Mongo, Server (Hosting Server)
Oracle, MySQL) Language – Python, [Link],
- Server Side Programming (Python , JSON) Ruby, Java
- Client Side Programming (Java Script, Server Side Programming
HTML, CSS)
- Package Management tool (UV, NPX,PIP) Browser(Client Side
- Source Code Management (github) Programming)
- Manual (Command Prompt, Terminal (Mac),
Java Script, HTML, CSS
Bash Console (Server) )
YOU WILL BE FULL STACK DEVELOPER
YOU CAN DEVELOP YOUR OWN SOFTWARE