Archive for: July 2022 - Welcome to Ed2Ti Blog.

A Manager Soccer game with IA.

19 July 2022 - Posted in Trebas College by edward

Last week, my professor at Trebas Institute, Mr. Iyad Koteich started a class talking about ER Model. I confess that I really like to design database models(ER Models).

My classmate Ravi Rawat took a picture from a dashboard with a relationship model designer by Professor Iyad Koteich. This picture was the "kick-off" for this project.

First I need to explain the difference between ER Model and R Model.

R Model: Describe a vision of the problem to be resolved that any person can see and understand.

ER Model: Materializing the relational model in an Entity on a database requires some organizations.

I will use "WE" every time because Professor Iyad Koteich is my mentor and some classmates can contribute with us.

We need to understand how this project will be constructed:

Create the full ER Model -> MVP (2022-07-29)
Develop a PHP program to maintain the data (pĺayer, teams, clubs, games, etc) -> MPV (2022-08-31)
Develop a python program, to run in the background, analyzing the teams and the games. (2022-12-31)

The Codes of this project are hosted on GitHub: https://github.com/ed2ti/soccer-game-ia

You can directly download the ER-Model here

Study objectives:

Understand ER Model
Construct a Database (MariaDB or Postgres SQL)
FrontEnd Develop with PHP
BackEnd Develop with PYTON (sklearn, pandas, numpy)

All players were created by a website: https://www.mockaroo.com/. You can directly download it here.

A simple form example with: HTML5, CSS3, PHP and MySQL(MariaDB)

05 July 2022 - Posted in Trebas College by edward

Professor: Iyad Koteich

Objective: Using a MariaDB database, create a simple PHP program to:

Create a new account
Login user

I'm using in this example some technologies like HTML5, CSS3, PHP, and MySQL(MariaDB)

Table: users

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstName` varchar(120) NOT NULL,
  `lastName` varchar(120) NOT NULL,
  `password` varchar(120) NOT NULL,
  `email` varchar(120) NOT NULL,
  `phone` varchar(120) NOT NULL,
  `last` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

All files from this project you can find on GitHub: GitHub-Link

A Cloud experience with MariaDB Database

04 July 2022 - Posted in Trebas College by edward

Professor: Iyad Koteich

On 2022-07-04, I present at class a LAB with AWS using two services:

EC2(Elastic Compute Cloud) Instances
RDS(Relational Database Service) - Database (MariaDB)

The purpose is to compare the configuration and utilization of MariaDB as an IAAS or PAAS.

MariaDB - IAAS(infrastructure-as-a-service)

Create an EC2 Instance with an ubuntu server
Instal MariaDB - apt install mariadb-server
Configure a Security group
Change bind-address to 0.0.0.0
Create a user and give access to him.

Create User:

CREATE USER 'admin'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Change Bind Address: /etc/mysql/mariadb.conf.d/ and change bind-address

MariaDB - PAAS(platform-as-a-service)

Create a RDS Instance item
Configure a Security group

Relational Database: MariaDB is Relational Database and what is it?

relationship -> one-to-one [indicate]
relationship -> one-to-many [orders]
[son] relationship -> many-to-many [rent cars]

Data Definition Language.

CREATE DATABASE trebasdb;
** USE trebasdb; **
CREATE TABLE users( id int(4) AUTO_INCREMENT, name varchar(30) NOT NULL, email varchar(50), PRIMARY KEY (id) );

Data Manipulation Language.

SELECT * FROM
DELETE FROM
INSERT INTO

Design patterns.