INFORMATION MANAGEMENT(MODULE 4) Zyvrex John R Perez BSIT - 1A What is SQL? Structure Query Language stands for Structured Query Language. A database access and manipulation standard language. It follows the ANSI standard. SQL can do: SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records in a database SQL can update records in a database SQL can delete records from a database SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures and views SQL Commands : SELECT - extract data from a database UPDATE - updates data in a database DELETE - deletes data from a database INSERT INTO - inserts new data into a database CREATE DATABASE - creates a new database ALTER DATABASE - modifies a database CREATE TABLE - creates a new table ALTER TABLE - modifies a table DR...
Posts
- Get link
- X
- Other Apps
Information Management (Module 6) Zyvrex John R Perez BSIT - 1A XML Extensible markup language (XML) is a markup language similar to HTML. It was created with the purpose of storing and transporting data while also being self-descriptive. Is a recommendation from the W3C. JSON JavaScript Object Notation is abbreviated as JSON. Is a lightweight data storage and transmission format. When data is transmitted from a server to a web page, this is commonly utilized. Is it "self-descriptive" and simple to comprehend? AJAX Ajax is a developer's dream because you can: - Read data from web server - after a web page loaded - Update a webpage without reloading the page - Send data to a web server - in the backgrou d
- Get link
- X
- Other Apps
Information Management Learning Task Module 3 Zyvrex John R Perez BSIT - 1A A. Data Definition Language It may be used to define relation schemes, delete relations, and create indices, among other things. B. Interactive Data Manipulation Language In a relation, it may be used to insert, remove, and update tuples. C. Embedded Data Manipulation Language SQL statements are included into programs written in other programming languages using the embedded version of the DML.
- Get link
- X
- Other Apps
Midterm Learning Task Module 1 (Lec) Information Management Zyvrex John R Perez BSIT - 1A Function of DBMS The database management system (DBMS) must be able to receive data definitions in source form (external, internal, and conceptual schemas, as well as all related mappings) and convert them to the proper object form. It must be able to respond to user requests to access and maybe edit current database data, as well as to add new data to the database. Advantage of DBMS Data redundancy is avoided in database systems by keeping a single copy of the data. Because a single copy of a particular data is stored in the database, you can be sure that any changes to the data will be reflected in all future uses of that data.The database system's structure requires that data be independent of other data in the database and the software used to access the database. In a database context, data is easier to utilize. The database will take up less storage space since data redundancy is reduced...
- Get link
- X
- Other Apps
Information Management Zyvrex John R Perez BSIT - 1A Learning Task 1 What is Database? Database management refers to a company's efforts to alter and control data throughout the data lifecycle in order to satisfy the requirements. What type of software is Microsoft Office Excel? Microsoft Excel is a spreadsheet-making tool that is mostly used to create spreadsheets. It may also be used to create databases as well as charts and other graphics. It's a spreadsheet application. What type of software is Microsoft Office Access? Microsoft Access is a database management system by Microsoft that combines a graphical user interface and software development tools with the relational Access Database Engine. It is a part of the Microsoft 365 suite of apps, which may be purchased independently or as part of the Professional and higher editions of Microsoft Office 365. Think of at least 2 differences between access and excel
- Get link
- X
- Other Apps
Information Management Zyvrex John R Perez BSIT - 1A Information Management Experience In my experience in my first class in information management is good because I know that our teacher prepared it well so that I am impressed to our first meeting because she explain it well and I learn from her We also experience the internet connection problem in our first meeting so that there are some times that we can hear clear what our teacher says, but we understand it because its part of our learning system and so that instead of complaining, we more value the effort of our teacher because even she have a network difficulties, she try her best to teach us her lesson
PC TROUBLESHOOTING WITH BASIC ELECTRONICS (LABORATORY)
- Get link
- X
- Other Apps
Zyvrex John R Perez BSIT - 1B Blogpost#3 A. If will you become a computer parts/gadgets or any ICT tools, what will you be and why? A mouse If I were be a part of a computer, I want to become a mouse because a mouse is the tool that can navigate to the computer screen, and a mouse is the decision-making tool of a computer, and I want to be that tool because I want to be the one to decide for the good result of what I will do B. What is the use of computer in your day to day activity? Online Class The use of my computer on a daily basis is to attend an online class meeting and after attending the meeting I will do some of my modules to avoid pilling of modules Online Games The another use of my computer is to play online games, because playing computer or online games can make myself stress-free, and this is one of the tool that me and my friends using to bond even at home C. If will you become a technology, what will you be and why? Technology If ...