Computer
Studied by 1 person
Call with Kai
Knowt Play
Learn
Practice Test
Spaced Repetition
Match
Flashcards1/50
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
51 Terms
Information Communication Tech
What is the meaning of ICT?
Technical Vocational Livelihood
What is the meaning of TVL?
Word, PowerPoint, Excel, Access
4 main apps of Microsoft?
Commercial
What is meaning of .com?
Database
It is an organized collection of data that is related to a particular subject or purpose.
Cookies
It records the site you open by accepting this.
Learner’s Information System
What is the meaning of LIS?
DepEd
Where is LIS most common from?
Manual Database
It is a traditional way of managing a database using paper and pen.
Manual Database
It is simple to implement.
Manual Database
Difficulty begins when the amount of information becomes too big / too many.
Database Management System
What does DBMS mean?
DBMS
It is a computerized or electronic database.
DBMS
It is a collection of data stored in a computer system.
DBMS
It allows the user to easily enter, access and analyze data quickly and easily.
Tables
It is use to store data in a dbms.
Fields
are the categories or types of information found in a table.
Record
It is a set of fields for a specific item. It represents one entry in a table.
Fields
Records
Point of Sales System
What does POS mean?
Point of Sales System
It is commonly used in groceries and department stores checkout counter.
Point of Sales System
It records transactions and generates updated reports for the store manager or owner.
Automated Teller Machine
What does ATM mean?
Automated Teller Machine
It allows to conduct banking transactions like withdrawing or depositing money, or transferring money from your savings account to your checking account, vice versa.
Automated Teller Machine
Making cash advances, using credit cards, making online payments, and checking available balance.
Flight Reservation System
It allows to see flight details, customer bookings, reservations / cancellation of flights.
Computerized Inventory System
It is used in warehouse operation to monitor the availability, quantity and locations of stocks.
Payroll System
It is designed to compute for employee salaries, deductions and contributions to various agencies.
Enrollment System
It is often used by schools to automate the registration of students, computation of tuition fees, and other student information.
Enrollment System
It may also interface with other DBMS like scheduling, grading systems, attendance reporting.
Flat File Database
It is designed to put all information one table.
Flat File Database
It is usually created using Microsoft Excel
Relational Database
A type of database where one or more tables are linked together or related to other tables in a table.
Relational Database
It can handle information that allows you to enter, search, and analyze data in more than one table at a time.
Student List
It is a list of students allowed to borrow books
Books List
It is a list of books and other materials that can be borrowed from the library.
Transaction List
It is a list of day to day transactions / list of students who borrows books from the library.
Non-Relational/noSQL
It is a database that does not use the tabular schema of rows and columns found in most traditional database system.
Relational Database (RDBMS), Object Oriented Database (OODBMS), Hierarchical Database, Network Database
What are the 4 types of DBMS?
Data Definition
The stage where all necessary fields for the database are gathered and listed.
Data Refinement
The process where some fields needs to be broken down to specific fields. This is necessary to facilitate the search for information in a database.
Establishment of Relationships between tables
This is created do that viewing and accessing records across tables are possible.
Relationship
It is an association established between common fields in two tables.
Primary Key
It is a unique field used to identify each record in a table
Determination of Appropriate data outputs
Process of extracting information from a database.
Determination of Appropriate Data Outputs
This is also known as query.
Determination of Appropriate Data Outputs
The output will be used for creating/generating a report that will be displayed on your computer monitor or printed on paper.
Creation of a control system / User interface system.
The last phase of proper database design is the creation of the control system over the database system.
Text
these are entries that do not have a value associated with them.
Formula
These are mathematical equations that use the value or text in cells to calculate a result.