Computing in the Box

Welcome to ABCHIGHWAY!..

ATTENTION MAED(EDUC.TECHNOLOGY)

Download this app DOWNLOAD

If you are using IOS, mark the URL(address of the app) I gave you last saturday in your IPhone

Attention BSIT 3a ,3b and BSIT 2 b and c

SOFT ENG CLICK HERE FOR LECTURE.

So, your task this week is to download the CITEAPP, listed below. How? Activate your mobile data, open your browser in your CP. Type this in your browser navigation bar  - "https://abchighway.blogspot.com. (This for android app)

Oppss!!! dont't forget to turn on your MOBILE DATA.

1. Download this app DOWNLOAD

2. Check your cellphone android wall, from there you can see the ANDROID ICON. tap it.

Requirements for BSIT 3a and b (Software Engineering)

1. BandPapers(long or short)

2. Notebook

3. Pencils and ballpens

4. Plastic Folder and Envelopes

5. Mobile Phone with CITEAPP

Soft Eng. students, go to Soft Eng Tab

Requirements for BSIT 2b and c(SIA)

1. BandPapers(long or short)

2. Notebook

3. Pencils and ballpens

4. Plastic Folder and Envelopes

5. Mobile Phone with CITEAPP

SIA Students, go to SIA Tab

To enroll in the MAED virtual class please follow these chagrin of instructions

1. Create your email address in gmail account(write your complete name , dont use any monicker)

2. Click THIS/or open classroom.google.com

3. Use this code/copy  to enroll oghryo0

Attention MAED (Masters in Education)!!

How are you?? it is raining today(08.05.19). We have  discussed the  different angles of Educational Technology last saturday. We have already covered the topics for the first  and second meeting and bit advancing to the abyss of digital start up tools.

So, your task this week is to download the CITEAPP, listed below. How? Activate your mobile data, open your browser in your CP. Type this in your browser navigation bar  - "https://abchighway.blogspot.com. (This for android app)

Oppss!!! dont't forget to turn on your MOBILE DATA.

1. Download this app DOWNLOAD

2. Check your cellphone android wall, from there you can see the ANDROID ICON. tap it.

Concept Notes:

These are the topics discoursed last saturday

1. Overview of Computing

2. The significance of Educational Technology

3. The whys and how's and what's of Coomputer.

4. Different Computing Jargons

5. The beginning of Internet and the importance of social network

6.  Different species of computer application

7.  Different digital toolkit for classroom management like Word processing, Spread Sheets, Slides Presentation and Database

8. Multimedia as a catalyst for social information campaign

8.1 Infomercial 

8.2 Social Marketing

8.3 Shockvertisements

8.9 Social Campaign

8.10 Video Explainer

Comprehensive Questions.

Instructions: Write your answer in your yellow pad paper. Submit this on Aug. 10,2019

1. What is your best take away in our discussion last Saturday?

2. Explain the magnetism of  Multimedia as part of your knowledge campaign inside the classroom? 

3. Would you  consider YOUTUBE as an Educational Technology Influencer? why? and How?

* * * *  * Ends here * * * *

F1StackMind SOON!!!!

***********************

Now you can study . work . and..collaborate. 

Hello BSIT 1st Year Section 1-C,1-D,1-F,1-H and1-G

"READ this page and look for CITEAPP or CITEWAY APP. DOWNLOAD it in yout mobile phone.

How?
If you don't have a copy of the Citeway/Abchighway app you can still DOWNLOAD  it here

PYthon UI (PY-UI) 2019 coming soon!

This is the convergeance of beautiful minds in computing, particular for those who are inclined in Python technology. This coming 2019! watch out.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

02.05.18
CODE CAMP!
Hone your skills in coding, learn the basic and advance principle of COMPUTING through programming! Check the code camp schedule at the CITE office and meet your Code Camp Guru's.

03.01.18
ATTENTION BSIT 2-C


Write the following programs that anchore to BREAD(Browse Read Add Delete)

Front end using html

1. add.html
2. edit.html
3. del.html
4. display.html

Middle end/Back End

1. add1.php
2.edit1.php
3.del1.html
4. display1.html


How to start?? open your notepad and start with your html tags
(example of adding a record)

<html>
...
...
<form action = "add1.php" method = "POST">
enter lastname
<input type = "text" name = "lname" >
</br>

enter fname
<input type = "text" name = "fname">
</br>
<input type = "submit" value = "add">
</form>
...
******

in your php code..
add1.php

<?php
//connect to your localhost...

$query = "insert into <name of your table>(lastname,firstname)VALUES("del cruz","juan")";

mysql_query($query);

....
...
?>

//study the codes and modify it.




02.02.18
ATTENSION BSIT 2 C

To wrapped up the things that we'v  discussed last time please check this.

1) SQL commands
2) Basic SQL aggregate functions 
3) Basic form data collection using PHP
         3.1 date ,$_POST, echo, html <tags> <?php ?>   Your task is to review all the "sekwel" commands and memorize it, to avert confusions during the evaluation. Start now to review the PHP programming. This will serve as your middle programming tool to communicate with your mysql.

Requirements for the PHP

* Install xampp
* NotePad or any text editor
* A browser

Read these PHP global array functions.

$_GET; $_POST;$_REQUEST;$_FILE,$_SESSION;$_HTTP;

WEb programming in PHP  decides the data manipulation to these function, the GET and POST. What is GET? and what is POST? you use these function  if you are invoking an action parameter in your html, passing the varibles/values to your PHP codes. Meaning your INPUT works will commence on your HTML, your PROCESS and OUTPUT work will be fetched  by your PHP program

Remember the Front-End - > Middle -END and -> Back - End.

Last thursday, Feb.1,2018  we discussed how to write a code in PHP, mimicking the twitter program, a simple programming exercise to passed the value of  HTML variables  to the Php program. We used the $_POST to read the data from the html tags. What is $_POST? this is a super global function of PHP that collects data from the form in your html. Now that's a simple and seamless explanation. Go ahead and expound yout thoughts! read books in the library.

How it works::{We will discuss it next week:)}

Study the following php commands(basic)..this is your tool to manipulate the "sekwel".

Reserve words
for..while...do loop...if..else...switch..case..break..default...

Php Function/methods..

* Date(), mysql_connect(), mysql_select_db(),msyql_query() mysql_close

Lets put some spicy to that to catch the latest trends in the IT Computing

* For your readings and research
      mysqli() and PDO
      (Write this in your pad paper)



*********************






12.21.17 - 12.25.17
ATTENTION!
BSIT 2ND YEAR section C
****************************


Please read the concept notes at the bottom about the SQL and review the basic commands.

While you are enjoying your vacation, have time to research the following PHP stuff.

TODO1:

1, MYSQL, MYSQLI and PDO
2.What is the difference bewtween mysql and mysqli?

TODO2:

Review the following SQL and memorize the syntax

1. SELECT (where) condition
1.1 provide 2 examples

2. UPDATE
2.1 provide 2 examples

3.DELETE
3.1 provide 2 examples

4. INSERT INTO
4.1 provide 2 examples

*******



12.04.17
ATTENTION!
BSIT 2ND YEAR!
****************************


*******
I will not be around this monday(12.04.17). I will give you your  tasks, proceed to the Library. 

a) Write a program in Php to determine the course of the student. Use html5 to encode the data and PHP to validate the data

html5 (input) - - - >php(Process)

what are the commands in Php?

echo and if ..else command

Problem:: Ask the user to enter the following using HTML5 (the filename is act5.html)

* IDNO

*LASTNAME

*FNAME

*COURSE

Validate the course, if the course is

BSN = display NURSING

CRIM = display CRIMINOLOGY

IT = display BSIT

BA = display BA

save your php to act5.php

2. WHAT IS THE PURPOSE OF "GET" AND "POST"?

(WRITE YOUR ANSWERS IN A SEPARATE PAPER, 1 FOR THE PHP ,HTML AND  1 FOR

QUESTION NUMBER 2.)

SUBMIT YOUR TASKS ON DEC. 5,2017 (CITE DEPARTMENT) between - 9am - 1pm

Submit your tasks on Tuesday(12.05.17) Cite department. 

*********

YOUR TASK STARTING TODAY. 12.04.17

1. REVIEW YOUR SEKWEL

1.1 SQL Commands (basic)

* SELECT, ORDER BY, ASC and DESC

* WHERE and LIKE

Like is use to display the content of the FN using Wildcards. Example % * ?
please read the threads below.IF YOU HAVE QUESTIONS PLEASE SEE ME IN CITE DEPARTMENT.

Review also your mathematical operators and the Logical operators.

Example of your Logical Operators

= AND OR NOT XOR

****************

FINISH YOUR ASSIGNMENTS FOR EVALUATION 

1. Php Basic Program that will enter the following FN (Field Names)

=> Lastname, Firsntame, age, Course

Front end- Html5

Middle Program - Php

* your your source code in your band paper or 1 whole sheet of pad paper.

*********************

SEKWEL ACTIVITY

Problem:

The name of your database is Data1 , the table name is Student.

Student -> FN 

IDNO - varchar

Lastname-varchar

Fname -varchar

Age -varchar

Course -varchar

Write your answer in your 1 whole sheet of pad paper/band paper.

1. Display all the records

2. Display all the course and lastname

3. Display all the lastname in ascending order using ASC

4. Display all the firstname and lastname in order, use lastname as the key

5. Display all the records where age is greater than or equal to 20

6. Display all the records where lastname = "Pi" and age = 30

7. Display all the records where lastname = "Pi" and Fname = "Pe"

8. Display all the records while lastname is arranged in DESC and age >18

9. Display all the idno,lastname only

10.Display all the age in ASCENDING order

SUBMIT THESE TASKS ON FRIDAY, DEC, 8,2017

*****

You can read the threads below for your further readings!

*************************************

03.15.17
ATTENTION!
BSIT 2A,2B,2C and 2D!

The evaluation for the final examination is until March 24,2017. Please bring your passports. Submit all the projects and TODO lists during the final examination day.

Review  the citeway app / abchighway.blogspot.com.
Memorize the relational database connection, the add, delete, edit, locate,display and connectivity program to the localhost.

SECTION D! please coordinate with section A, B and C about the requirements.

Those who are prepared for the evaluation, see me in the CITE office or ask Ms. Fahnnie.

Thank you.
***

the 

03.06-10.17
ATTENTION BSIT 2A,2B,2C and 2d!

We are in the verge of finishing our topics in Database Management System. Don't forget to visit the LIBRARY for your further readings in this subject. What are the books for this subject? please  read the DATABASE CONCEPTS or DeMystified Database or any database books that discourse the ABC's of database management or concepts.

CONCEPT NOTES:

A relational database is a digital database whose organization is based on the relational model of data, as proposed by E. F. Codd in 1970.^[1] The various software systems used to maintain relational databases are known as a relational database management system (RDBMS). Virtually all relational database systems use SQL (Structured Query Language) as the language for querying and maintaining the database.
(Source : wikipedia)

To sum it up, A relational database can create a relation to other database using tables. It could be more than two or more than three or more tables to suffice the queries of the end users.Please check this example.

Fig. aa

There are two tables in fig. aa, it is very obvious that studinfo is having  a relation with the table named "studgrade". From the diagram, please analyze the primary key or the index key that keeps the two table connecting to each other.

To display the the records in studifo and studgrade, it is imperative to inject the SQL using the inner join, left join and right join.

Injecting the query based on the diagram of figure aa.

select studinfo.lname, studinfo.fname, studgrade.prelim, studgrade.midterm, studgrade.final from studgrade on studinfo inner join studgrade.idno = studinfo.idno;

okey! okey! feeling buffled? again lets dissect it here, keep on pushing! read!

SQL JOIN

An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.

The most common type of join is: SQL INNER JOIN (simple join). An SQL INNER JOIN returns all rows from multiple tables where the join condition is met.

Different SQL JOINs

Before we continue with examples, we will list the types of the different SQL JOINs you can use:

• INNER JOIN: Returns all rows when there is at least one match in BOTH tables
• LEFT JOIN: Return all rows from the left table, and the matched rows from the right table
• RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table
• FULL JOIN: Return all rows when there is a match in ONE of the tables

SQL LEFT JOIN Syntax

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name=table2.column_name;

PS: In some database Left Join is called OUTER JOIN, research this! and put this in your 1 whole sheet of pad paper! this is equivalent to 2 Activities.

Example

SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID
ORDER BY Customers.CustomerName;

SQL RIGHT JOIN Syntax

SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name=table2.column_name;

The RIGHT JOIN keyword returns all rows from the right table (table2), with the matching rows in the left table (table1). The result is NULL in the left side when there is no match.

Example:
SELECT Orders.OrderID, Employees.FirstName
FROM Orders
RIGHT JOIN Employees
ON Orders.EmployeeID=Employees.EmployeeID
ORDER BY Orders.OrderID;

SQL FULL OUTER JOIN Syntax

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name=table2.column_name;

Full Join is the combination of Left and Right Outer join, it will provide results to the right and left tables.

SQL FULL OUTER JOIN Example

The following SQL statement selects all customers, and all orders:

SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
FULL OUTER JOIN Orders
ON Customers.CustomerID=Orders.CustomerID
ORDER BY Customers.CustomerName;

Now, what do you think, this is pretty simple, focus!!!

Independent Activities:
(Equivalent to 10 activities)

Get your bond paper and answer these questions.

1. What is a relational database? explain and draw your own diagram.
2. What are the examples of joining the databases? explain each join command.
3. Design a table using your existing database.
Tables are Orders and CustomerId
(put this in another bond paper)
Orders - Fieldnames are

ordersID(Integer), customersID(integer),orderDate(Date)
001                         213                              2017-09-01
002                         214                              2017-09-02

(write 10 records)

in the customersID

customersName (varchar)               ordersID(integer)
Anto Cruz                                          001
Andeng Cruz                                     002


4. Display all the ordersID, customersName using the inner join
5. Display all the ordersID, orderDate and customersName using the Right Join.
6. Display all the ordersID, orderDate and customersName using the Left Join.
7. Display all the records in both table using the Full Join.

Section A: Submit your activity on March 7(in our class)
Section B: Submit your activity on March 8(in our class)
Section C: Submit your activity on March 9(in our class)
Section D:Submit your activity on March 9(Cite office, morning only from 9-12pm)

Late submission will not be entertained!

Exploratory Tasks::
Put this in your bondpaper(s).

1. What is database Normalization?
2. How will you Normalize a database?
3. What is SQL Injection?
4. How will protect your database from the HAcKers
and SQL Injectors?

Deadline::
Section A: Submit your activity on March 7(in our class)
Section B: Submit your activity on March 8(in our class)
Section C: Submit your activity on March 9(in our class)
Section D:Submit your activity on March 9(Cite office, morning only from 9-12pm)


UnderPinning Knowledge and Skills::
Laboratory activities!
Core requirements:

1. app1
Description::
Mastering the php programming in adding, updating, displaying, locating and deleting records.

PS.Memorize the SQL commands and the connectivity to the localhost and database using the PHP.Create and memorize the program in php, how to add/insert records, display records, search records, delete records and update records.

Here are the codes(Example for search records)
step 1. Write a html4/html5 program and save it to search.htm, make it plain and simple, you can add ornamental to the page later.

<!doctype html>
<html>
..
..
<body>
..
<form action ="search.php" method = POST>
<p> search Record(lastname) </p>
<input type = "text" name ="lname" size = 30>
<input type = "submit"  value = "search">
</form>
.
.
</html>

Now, write your php code and save it to "search.php" don't forget to activate your XAMPP or WAMPP. and run your localhost kiddo!

//code of search.php

<?php
$konekta ...
$data ...

mvsql_select_db($data,$konekta) or die(mysql_error());

$pangita = "select * from {your table name} where
lname = '$_POST[lname]' ";

$result = mysql_query($pangita);

     if($result) {

         while($row=msyql_fetch_array($result)){
         echo $row['idno'];
         echo $row['lname'];
         {type the rest of your fieldnames here}
      
        }  //close the loop

    }else{

        echo "<script> alert('no records found');</script>";
  } //end if here

 mysql_close($konekta);

?>

Note* You can replace later the mysql to mysqli, for further readings you can check the PDO. yOUR assignment is
to discuss what is PDO? write 3 examples of PDO. 1 whole sheet of pad paper.


* * * END * * *


02.20.17
ATTENTION BSIT 2A,2B, 2C and 2D!


Section 2b and 2c ! finish these tasks today - feb 20, 2017

READ THIS!

Please review your SQL commands from  Select, Update, Insert and Delete, these commands applies the rule of BREAD and CRUD, what is BREAD?  well that is browse, read, edit, add and delete, for the CRUD, it is Create Red Undelete and Delete, simple as that.

We will have an individual assessment about the SQL, added to that are the following SQL statements.

The SQL SELECT DISTINCT Statement

In a table, a column may contain many duplicate values; and sometimes you only want to list the different (distinct) values.

The DISTINCT keyword can be used to return only distinct (different) values.

SQL SELECT DISTINCT Syntax

SELECT DISTINCT column_name,column_name
FROM table_name;

The following SQL statement selects only the distinct values from the "City" columns from the "Customers" table:

Example

SELECT DISTINCT City FROM Customers;

**
(Review this...)

SQL SELECT TOP Example

The following SQL statement selects the two first records from the "app1" table:

Example

SELECT TOP 2 * FROM app1;

This will display top 2 records, bit the same to LIMIT

The next example will inject the wildcards, the purpose of this is to display the characters or pattern of the characters stored in the fieldlists.

The following SQL statement selects all customers with a Country containing the pattern "land":

Example

SELECT * FROM app1
WHERE Lname LIKE 'land%';

This will display all the lastname with the patterned lastname of land , i.e Holand, Borland, Daland, Loland:)

SQL Wildcard Characters

In SQL, wildcard characters are used with the SQL LIKE operator.

SQL wildcards are used to search for data within a table. 

With SQL, the wildcards are:

Wildcard	Description
%	A substitute for zero or more characters
_	A substitute for a single character
[charlist]	Sets and ranges of characters to match
[^charlist] or [!charlist]	Matches only a character NOT specified within the brackets

The following SQL statement selects all customers with a City starting with any character, followed by "erlin":

Example

SELECT * FROM Customers
WHERE City LIKE '_erlin'

Using the SQL [charlist] Wildcard

The following SQL statement selects all customers with a City starting with "b", "s", or "p":

Example

SELECT * FROM app1 WHERE lname LIKE '[bsp]%';

The following SQL statement selects all customers with a City starting with "a", "b", or "c":

Example

SELECT * FROM app1
WHERE lname LIKE '[a-c]%';

Advance topic, manuevering the tables

The IN Operator

The IN operator allows you to specify multiple values in a WHERE clause.

SQL IN Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);

IN Operator Example

The following SQL statement selects all customers with a City of "Paris" or "London":

Example

SELECT * FROM app1
WHERE course IN ('BSIT','BSN');

ARE you still awake? keep on reading.

The SQL BETWEEN Operator

The BETWEEN operator selects values within a range. The values can be numbers, text, or dates.

SQL BETWEEN Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

BETWEEN Operator Example

The following SQL statement selects all products with a price BETWEEN 10 and 20:

Example

SELECT * FROM app1
WHERE prelim BETWEEN 10 AND 20;

I GUESS you comprehend this. Though it is a simple query but you can apply this in the sql injection.

SQL Aliases

SQL aliases are used to give a database table, or a column in a table, a temporary name.

Basically aliases are created to make column names more readable.

SQL Alias Syntax for Columns

SELECT column_name AS alias_name
FROM table_name;

SQL Alias Syntax for Tables

SELECT column_name(s)
FROM table_name AS alias_name;

Alias Example for Table Columns

The following SQL statement specifies two aliases, one for the CustomerName column and one for the ContactName column. Tip: It requires double quotation marks or square brackets if the column name contains spaces:

Example

SELECT lname AS lastname, course AS [kurso]
FROM app1;

That's all for the lecture today, get your bondpaper and answer the following questions.

INDEPENDENT ACTIVITY

1. What is SQL?
(not less than 30 words)

2. Table name is App1, field names are IDNO, LNAME, FNAME, ADDRESS, EMAIL, GRADE
    - display first 2 records using TOP
    - display 10 records using LIMIT

3.  Display all the records in ascending order (table name is App1) using ASC

4.  Display all the records in descending order using DESC


5. Display all the GRADE, using BETWEEN.
       Grade range should be 60-100

6. Display lname , fname using IN , extract 'CRUZ' and 'CRUISE; inside the table.

7. Display all the records with the pattern of 'RUZ'

8. Display the all the records where Lastname  starts in A-B-C while grade is < 50 arrange in DESC

9. Display all the records using IN , and extract these courses - BSN and BSIT while lname starts in letter C and Address has the pattern of  %ILO%

10. BONUS!

EXPLORATORY ACTIVITY/TASKS

REVIEW THE FOLLOWING PHP COMMANDS, STATEMENTS AND FUNCTION

1. msyql_connect; my_sql_select_db, mysql_close.mysql_query

Research this in the Library!!! write this in your bondpaper.

1.$_GET; $_SESSION; $_POST
2. echo, print, for loop, while loop, foreach
3. $row, msyql_fetch_array()

a)Memorize the program to connect in your  LOCALHOST!
b)Memorize the program to Insert the records!

that's all for now.

***See You!***

THIS ACTIVITY IS EQUIVALENT TO 10 ACTIVITIES!
*****sEE yOU*****




02.06.17

ATTENTION BSIT2 2ND YR. SECTION A,B,C AND D!
YOU NEED TO DOWNLOAD THE CITEWAY APP IN THIS BLOG! THIS IS ONE OF THE REQUIREMENTS.

***

COVERAGE OF THE MIDTERM EXAMINATION

1) ALL SQL (STRUCTURE QUERY LANGUAGE) EXCEPT FOR ALTER AND CREATE TABLE

2)PLATFORM
3)OPERATING SYSTEM
4) TERMS AND JARGONS
5) TOOLS FOR DATABASE MANAGEMENT/SOFTWARE
6. FRONT END AND BACK END.
7. PHP CODES FOR MYSQL CONNECTIVITY AND DATABASE MANIPULATION

* COMPILE ALL YOUR TODO LISTS FOR EVALUATION
* REVIEW YOUR SQL AND PHP COMMANDS
* PREPARE YOUR PITCH AFTER THE MIDTERM FOR THE UPCOMING "MINI CAPSTONE PROJECT"
* HUDDLE WITH YOUR PARTNER FOR YOUR COMPANY LOGO.

TYPE OF EXAMINATION

a) MULTIPLE CHOICE
b) ENUMERATION
c) identification*
d) TRUE OR FALSE
e) PROGRAMMING

12.02.16
Attention BSIT 2nd yr. Section A,B,C and D!

* Please compile all your assignments/tasks your TODO Lists from 1-5 in your Folder.
* Present that to me next week.
* Your Tasks/assignments/homeworks will serve as your passport for evaluation to take the PRELIM Examination.
* Please prepare your Permit 

*******************************************
Coverage of the Prelim Examination SY-2016-17.(Please read the topics in this post)

1. Overview of the database management
2. Characteristics of the database
3. Fundamentals of Query
4. Basic Structure of a database
5. Tidbits of a relational database
6. DBMS Paradigm/framework
7. Database Softwares
8. Database Platforms
9. Start up using Php and Mysql
10. Basic SQL Commands.


= We will have a marathon of discussion (time based learning) on Database Management next week with demonstration. These will cover the following , associating the basic BREAD (browse, read, edit, add and Delete)

1. Designing a database 
  1.1 TABLES
2. Displaying the fields and Structure
3. Adding a FIELDS
4. BROWSING the records
5. injecting the SQL to manipulate the RECORDS
   5.1 Using SELECT, WHERE, and APPENDING/INSERT a record
6. RAD (Rapid Application Display) to createa MODULE to RUN a Program using FORM,
TABLE and query.

Note* We will use the VBA(Visual Basic Access) MS Access for quick introduction, after that we will use the Web Platform using the  Php and PhpMyAdmin.

*- - - - - -  * - - - - - *

11.28.16
DATABASE
Attention! BSIT 2nd Year Section A,B,C and D.

Click this->important!..short lecture(audio-podcasting)

***
If you don't have a copy of the Citeway/Abchighway app you can still DOWNLOAD  it here

Please Read this post:
Target Dates - Nov. 29,2016 to Dec. 2,2016

To wrapped up the things that we discussed, last week.

1. Overview of the database management
2. Characteristics of the database
3. Fundamentals of Query
4. Basic Structure of a database
5. Tidbits of a relational database
6. DBMS Paradigm/framework
7. Database Softwares
8. Database Platforms
9. Start up using Php and Mysql

**************************************

TODO(4)
Instruction: NO Print out , write your tasks.

1. Get your long/short size bond paper.
2. Write the origin of the following database softwares
   2.1 MS SQL
   2.2 MYSQL
   2.3 POSTGRES
   2.4 SQLITE
   2.5 PDO
   2.6 MS ACCESS
   2.7 MONGODB

3. Search the following SQL commands and provide 2 examples for
   every queries.

  3.1 SELECT...
  3.2 UPDATE
  3.3 DELETE
  3.4 INSERT
  3.5 DROP

(Note* Compile all your answers including your previous TODO lists in your folder).

******************************

DISCUSSION:

Database is about building a data for a particular application, no system can sustain itself with out storing a data. It requires a fine and genuine design to communicate with the end users and the database itself. for a clean ground up illustration, DATABASE has the following ingredients to build a data, first is the table of specification. what is a TABLE? it has a ROW and a COLUMN  to define the field names of the data and values cascadingly displayed as rows.

DATABASE NAME: studentInfo
TABLE NAME: info

FIELD NAMES:  id    lastname     firstname     m.i   course

==========================================

Let say, the table info has 3 records.

id     lastname   firstname  m.i  course
01    CRUZ       JO             P    BSIT
02    LUNA      TIKO        M   BSIT
03   LEE           KOT         P    BSIT

 kid stuff!! the name of the database is STUDENTINFO, the table name is
INFO   and there are four field names that describes the behavior of the table. these are the
lastname, firstname , m.i and course.

Again, designing a database, requires planning. Planning takes place to gather the information and data for the target project.

How to design a database? Here, follow these simple techniques

1. Plan 2. Gather the information 3. Design the Database  4. Parallel testing 5. Deploy and
Install 6. Normalize your data

DISPLAYING THE RECORDS USING SQL

What is SQL? we use this jargon everyday, especially in the communication service company, basically it stands for Structure Query Language,Queries are information or questions, It is the universal lingua franca in database parlance. What is SQL? what is the purpose of this jargon? SQL is a tool in database to run a binary search for a target record in the table or within a multiple table using relational database algorithm. This is commonly used in different database platform, like desktop or web application.

A RELATIONAL DATABASE has records with connection with other tables.The end user can run a multiple display to link the table field names. Just imagine if you chunk your database into two tables. Table for the Student information and Student Account.

Conceptual Framework:

STUDENT INFORMATION   ----> STUDENT ACCOUNT

The STUDENT INFORMATION table will store the grades and course, while the STUDENT ACCOUNT will store the student payments for prelim,midterm and final grade. With this, there is a clean process of joining  tables to avoid confusion and clean house keeping of data.

USING SQL TO DISPLAY THE RECORDS.

Here are the examples how to display a record using the SQL (standard query)

example: DATABASE NAME: STUDENTINFO
                TABLE NAME: STUDENTINFO
             
                 FIELD NAMES:

                 idno        lastname     firstname     course    level
                 001         CRUZ        CHAR          BSIT      2
                 002         DELAT      DO               BSIT      3
                 003         BULAK     BOL             BSIT      3

IF you want to display ALL the  records. This is the command

SELECT -- SQL command use to display a record.

SELECT idno, lastname, firstname, course FROM  STUDENTINFO
(SYNTAX - SELECT <FIELDNAMES> FROM <TABLE NAME> <CONDITION>

IF you want to display a particular record, let say, the lastname equal to "CRUZ"


SELECT idno, lastname, firstname, course FROM STUDENTINFO WHERE lastname = "CRUZ"

(Explanation: We injected the clause "WHERE", this is a condition showing to filter the
last argument that will display the lastname of CRUZ.

IF you want to display the selected Field Names, like showing only the lastname and firstname.

SELECT lastname, firstname  FROM STUDENTINFO


TODO5
Instruction: NO Print out , write your tasks.

1. Get your bondpaper long/short
2. DESIGN a  table with the following field names

     NAME OF DATABASE: todo6
     TABLE NAME: STUDENT1

          IDNO
          LASTNAME
          FIRSTNAME
          M.I
          COURSE
          YEARLEVEL

3. Write 20 records, live records, meaning, you need to write the names of your classmates

example:

IDNO  LASTNAME  FIRSTNAME  M.I  COURSE  YEARLEVEL

001      DONCONG    KONG             M    BSIT          2
002      CONLEE        SHO                 M    BSIT          2

4. Display all the records using the SQL

5. Display  all the lastname and firstname using the SQL

6. Display all the IDNO

7. Display all the records with  Lastname = "CONLEE"

9. Display the idno, lastname with MI equivalent to "M"

AGAIN, If you have installed the XAMPP or LAMP in your computer then review your HTML and SQL. Memorize these commands.
************************



11.22.16

You can now download the abchighway app for your mobile
[instructions]
1. Click this to DOWNLOAD
2. Copy the citeway.apk to your mobile
3. Install it
4. Activate your MOBILE Data
5. Enjoy.

DATABASE
(You can view this page using your Mobile, the URL is - "abchighway.blogspot.com")
Important Note* Click the Follow Button!!



Attention: BSIT 2nd year, section A,B,C and D.

Please read this post:

I will be gone for 8 days,  I will return on Dec. 2,2016. For now this is your turf to learn the preliminary stuff of database Management.


KEY DRAWING
(You can view this page using your Mobile, the URL is - "abchighway.blogspot.com")
11. 19. 16
Attention: BSIT 3 (Animation Track)

Please read this post:

This is your virtual classroom for Key Drawing subject. I will return on Dec. 2,2016. Please open this blog everyday, starting Nov. 21 - Dec. 2, 2016. Please check the main page and go to {Gaming production}and Click the Follow Button!

*************
Topic 1 :DATABASE OVERVIEW
(BSIT 2nd year A,B,C, and D! read this.)

(Source - tutorialspoint)

Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information.

Mostly data represents recordable facts. Data aids in producing information, which is based on facts. For example, if we have data about marks obtained by all students, we can then conclude about toppers and average marks.

A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

Characteristics

Traditionally, data was organized in file formats. DBMS was a new concept then, and all the research was done to make it overcome the deficiencies in traditional style of data management. A modern DBMS has the following characteristics −

• Real-world entity − A modern DBMS is more realistic and uses real-world entities to design its architecture. It uses the behavior and attributes too. For example, a school database may use students as an entity and their age as an attribute.
• Relation-based tables − DBMS allows entities and relations among them to form tables. A user can understand the architecture of a database just by looking at the table names.
• Isolation of data and application − A database system is entirely different than its data. A database is an active entity, whereas data is said to be passive, on which the database works and organizes. DBMS also stores metadata, which is data about data, to ease its own process.
• Less redundancy − DBMS follows the rules of normalization, which splits a relation when any of its attributes is having redundancy in values. Normalization is a mathematically rich and scientific process that reduces data redundancy.
• Consistency − Consistency is a state where every relation in a database remains consistent. There exist methods and techniques, which can detect attempt of leaving database in inconsistent state. A DBMS can provide greater consistency as compared to earlier forms of data storing applications like file-processing systems.
• Query Language − DBMS is equipped with query language, which makes it more efficient to retrieve and manipulate data. A user can apply as many and as different filtering options as required to retrieve a set of data. Traditionally it was not possible where file-processing system was used.
• ACID Properties − DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability (normally shortened as ACID). These concepts are applied on transactions, which manipulate data in a database. ACID properties help the database stay healthy in multi-transactional environments and in case of failure.
• Multiuser and Concurrent Access − DBMS supports multi-user environment and allows them to access and manipulate data in parallel. Though there are restrictions on transactions when users attempt to handle the same data item, but users are always unaware of them.
• Multiple views − DBMS offers multiple views for different users. A user who is in the Sales department will have a different view of database than a person working in the Production department. This feature enables the users to have a concentrate view of the database according to their requirements.
• Security − Features like multiple views offer security to some extent where users are unable to access data of other users and departments. DBMS offers methods to impose constraints while entering data into the database and retrieving the same at a later stage. DBMS offers many different levels of security features, which enables multiple users to have different views with different features. For example, a user in the Sales department cannot see the data that belongs to the Purchase department. Additionally, it can also be managed how much data of the Sales department should be displayed to the user. Since a DBMS is not saved on the disk as traditional file systems, it is very hard for miscreants to break the code.

Users

A typical DBMS has users with different rights and permissions who use it for different purposes. Some users retrieve data and some back it up. The users of a DBMS can be broadly categorized as follows −

• Administrators − Administrators maintain the DBMS and are responsible for administrating the database. They are responsible to look after its usage and by whom it should be used. They create access profiles for users and apply limitations to maintain isolation and force security. Administrators also look after DBMS resources like system license, required tools, and other software and hardware related maintenance.
• Designers − Designers are the group of people who actually work on the designing part of the database. They keep a close watch on what data should be kept and in what format. They identify and design the whole set of entities, relations, constraints, and views.
• End Users − End users are those who actually reap the benefits of having a DBMS. End users can range from simple viewers who pay attention to the logs or market rates to sophisticated users such as business analysts.

DATABASE students TODO Lists (TODO1)

Target Dates -  Nov 22-25,2016

"Learn and Earn"

1. Install the XAMP or WAMP in your Laptop (If you have a laptop)

2. Prepare your long/short size bondpaper

3. Answer the following questions based on topic mentioned "Database Overview"

3.1 (Do not print your answer, you need to write it in your bondpaper)

   Questions

     * What is a database?

     * What is the meaning of DBMS?

     * Explain the significance of a Database?
     * Draw the conceptual framework of the DBMS Structure that partcipated by
       the Administrator, Designer and End Users

Topic 2: Usage of Database

Dr.F

database is very crucial to design an application that requires information for hoarding the data. For Example, creating a web application that needs a backend for student information.

Keywords: - Backend; Records; FieldNames:

The Backend data refers to the support engine of a file that can hoard the data, hoard means to store the data as record in  the file. To to sum it up, applications that

involves file handling operations requires a database to retrieve and store the information.

Field name is the characteristic of a record that handles the structure of the database. 

    example of field names:

                                Last name; First name; iD Number; Phone Number.

Each field names focus to its own data types, the data types match the content of the data in the field names.

Data types are the behavior of the data to read the information of the records, the records can accept the following data types:

            Integer(Numbers, general numbers), Float(Numbers with decimal points); Text(Combination of charsets and strings); Date(date and time format); Obj(Images, video, embedded data like worksheets, word etc.).

Database Programs(Examples)

1.MS Access (VBA-Visual Basic Access)
2.VBasic /.Net
3.Php - MYSQL,MYSQLI,PDO
4.MONGODB
5.POSTGRES
6.CASANDRA
7.COUCHDB
8.REDIS


  

DATABASE students TODO Lists (TODO2)

Target Dates -  Nov 22-25,2016

"Learn and Earn"

1. Prepare your long/short  size bondpaper.

2. Answer the following questions

     

Questions

     * What is the purpose of the database?

     * Write a least 15 field names that requires to

        store the Student Information

     * Explain the importance of a data type.
     * Write a reaction paper about database management.

 Keyword - Management* - It is an art of handling the following areas, like
                                       planning, organizing, directing, organizing and budgeting.

DATABASE students TODO Lists (TODO3)

Note*If you don't have a laptop, you can join to your classmates with a laptop, this is an experimental activity.

Target Dates -  Nov 22-25,2016

Dr.F

"Learn and Earn"


* How to start a database application?

This is now your starting point, the question is..did you complete your TODO lists? if not, do not attempt to read this POST!! Go back and read the TODO lists!

Ask your self to recall the topics that glued in this blog! Again focus! what is a DATABASE? (answer it orally or silently) what is a DBMS? what is a record? what is fieldname? can you recall the basic and common DATA TYPES? Okey, if you feel that you answered these questions then let your feet get  wet in this TODO Lists:)

INSTALLING THE XAMP

1. Be sure that you are wired(" naka connect ka sa internet") If you have a laptop  or a pc you can easily download the xamP, don't worry we have xampp  in the CITE LAB.

XAMP Means - XML APACHE MYSQL PHP

2. Open your browser(any browser) and open your google engine or bing engine.

2.1 Search " download XAMPP"

3. After downloading the XAMPP, install it in your pc or laptop

4. Wait for a while.. while XAMPP is instaling in your PC/Laptop

5. Launch the XAMPP

6. Click  the first three radio box/buttons.., and for every paired check box click the [Star/Stop] button.

7. Minimize the XAMPP dialog box.

8. Go back to your browser and in your navigation bar, type this - http://127.0.0.1   {PRESS THE ENTER KEY}

*Key Facts - 127.0.0.1 are octets, value of the local host domain, powered by the APACHE server.
* Key Facts - you can replace http://127.0.0.1 with - http://localhost

9. XAMPP page will be displayed, click the english option as language.

9.1 If done correctly, you will gaze this page

******Relax..