DATABASE

Today we are learning about database, here are some information about database management system.

DATABASE

A database, often abbreviated as DB, is a collection of information organized in such a way that a computer program can quickly selectdesired pieces of data.





DATABASE MANAGEMENT SYSTEM






A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.

Fields, Records and Files

You can think of a traditional database as an electronic filing system, organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number.

An alternative concept in database design is known as Hypertext. In a Hypertext database, any object, whether it be a piece of text, a picture, or a film, can be linked to any other object. Hypertext databases are particularly useful for organizing large amounts of disparate information, but they are not designed for numerical analysis.

QUERY

-A query is a request for information from a database. There are three general methods for posing queries:

Choosing parameters from a menu: In this method, the database system presents a list of parameters from which you can choose. This is perhaps the easiest way to pose a query because the menus guide you, but it is also the least flexible.

Query by example (QBE): In this method, the systempresents a blank record and lets you specify the fields and values that define the query.

Query language: Many database systems require you to make requests for information in the form of a stylized query that must be written in a special query language. This is the most complex method because it forces you to learn a specialized language, but it is also the most powerful.

-To make a request for information from a database.

REPORT

A formatted and organized presentation of data. Most database management systems include a report writer that enables you to design and generate reports.

KEY

 In database management systems, a key is a field that you use to sort data. It can also be called a key field , sort key, index, or key word. For example, if you sort records by age, then the age field is a key. Most database management systems allow you to have more than one key so that you can sort records in different ways. One of the keys is designated the primary key, and must hold a unique value for each record. A key field that identifies records in a different table is called a foreign key.

REFERENCE:

https://searchsqlserver.techtarget.com/definition/database-management-system

https://www.webopedia.com/TERM/D/database.html

https://www.webopedia.com/TERM/D/database_management_system_DBMS.html

https://www.webopedia.com/FIG/DATABASE.gif

https://www.webopedia.com/TERM/Q/query.html

https://www.webopedia.com/TERM/K/key.html

NEW DICOVERY !!!

today i learned something very interesting that is how to take a screenshot on a pc

- so i have a screenshot of the IP configuration of a PC that im using right now

for anyone who wants to learn how to screenshot it,here are the step:

1.  Click on the window you would like to capture.

2.  Press Ctrl + Print Screen (Print Scrn) by holding down the Ctrl key and then pressing the Print Screen key. The Print Screen key is near the upper-right corner of your keyboard. (Depending on the type of keyboard you have, the exact key names on your keyboard may vary slightly.)

3. Click the Start button, located on the lower left-hand side of your desktop.

4. Click on Paint.

5.In the paint window, hold down the Ctrl key and then press and release the V key. Your captured screenshot should then appear within the paint window.

 6.To save the image, click on the File drop-down menu located in the upper left-hand side of the toolbar and click on Save As..

7. In the Save As window, browse to your desired save location, enter a filename on the File Name: field, and click Save to save your screenshot.

this is a new discovery to me so i hope that i can discover another interesting thing to do in a computer

OPERATING SYSTEM

Today we are going to learn about operating system. I kind of interested in this topic so here are some information I got for this topic:

Operating System (OS)

Definition - What does Operating System (OS) mean?

An operating system (OS), in its most general sense, is software that allows a user to run other applications on a computing device. While it is possible for a software application to interface directly with hardware, the vast majority of applications are written for an OS, which allows them to take advantage of common libraries and not worry about specific hardware details.

The operating system manages a computer's hardware resources, including:

• Input devices such as a keyboard and mouse
• Output devices such as display monitors, printers and scanners
• Network devices such as modems, routers and network connections
• Storage devices such as internal and external drives

The OS also provides services to facilitate the efficient execution and management of, and memory allocations for, any additional installed software application programs.

-here are some types of operating system:

MICROSOFT WINDOWS

Microsoft Windows is a group of several graphical operating system families, all of which are developed, marketed, and sold by Microsoft. Each family caters to a certain sector of the computing industry. Active Windows families include Windows NT and Windows Embedded; these may encompass subfamilies, e.g. Windows Embedded Compact (Windows CE) or Windows Server. Defunct Windows families include Windows 9x, Windows Mobile and Windows Phone.

BIOS SETUP UTILITIES

Use the BIOS Setup utility to change important BIOS settings for the computer. Basic Input/Output System (BIOS) is a program that controls communication between all input and output devices on the computer (such as disk drives, display, keyboard, mouse, and printer). The BIOS settings are stored in a chip on the motherboard CMOS (Complementary Metal Oxide Semiconductor) memory. A battery on the motherboard keeps the settings from being lost when the system is turned off.

The BIOS stores configuration information such as:

• The addresses of devices (hard disk drives, for example), that are attached to the computer.
• The startup sequence of the computer.
• The amount of system and extended memory.

STARTUP MENU

The Start menu is a user interface element used in Microsoft Windows since Windows 95 and in some other operating systems. It provides a central launching point for computer programs and performing other tasks. It has different names in different operating systems and window managers, such as Kickoff Application Launcher in KDE, Dash in GNOMEand Unity, and Start screen in Windows 8.

Traditionally, the Start menu provided a customizable nested list of programs for the user to launch, as well as a list of most recently opened documents, a way to find files and get help, and access to the system settings. Later enhancements via Windows Desktop Update included access to special folders like "My Documents" and "Favorites" (browser bookmarks). Windows XP's Start menu was expanded to encompass various My Documents folders (including My Music and My Pictures), and transplanted other items like My Computer and My Network Places from the Windows desktop. Until Windows Vista, the Start menu was constantly expanded across the screen as the user navigated through its cascading sub-menus.

INSTALLING A WINDOWS OS

Windows Installer (previously known as Microsoft Installer,^[3] codename Darwin^[4][5]) is a software component and application programming interface (API) of Microsoft Windows used for the installation, maintenance, and removal of software. The installation information, and optionally the files themselves, are packaged in installation packages, loosely relational databasesstructured as COM Structured Storages and commonly known as "MSI files", from their default filename extensions. Windows Installer contains significant changes from its predecessor, Setup API. New features include a GUI framework and automatic generation of the uninstallation sequence. Windows Installer is positioned as an alternative to stand-alone executable installer frameworks such as older versions of InstallShield and NSIS.

Before the introduction of Windows Store, Microsoft encouraged third parties to use Windows Installer as the basis for installation frameworks, so that they synchronize correctly with other installers and keep the internal database of installed products consistent. Important features such as rollback and versioning depend on a consistent internal database for reliable operation. Furthermore, Windows Installer facilitates the principle of least privilege by performing software installations by proxy for unprivileged users.

DISK FORMATTING

Disk formatting is the process of preparing a data storage device such as a hard disk drive, solid-state drive, floppy disk or USB flash drive for initial use. In some cases, the formatting operation may also create one or more new file systems. The first part of the formatting process that performs basic medium preparation is often referred to as "low-level formatting".^[1] Partitioning is the common term for the second part of the process, making the data storage device visible to an operating system.^[1] The third part of the process, usually termed "high-level formatting" most often refers to the process of generating a new file system.^[1] In some operating systems all or parts of these three processes can be combined or repeated at different levels^{[nb 1]} and the term "format" is understood to mean an operation in which a new disk medium is fully prepared to store files.

As a general rule,^{[nb 2]} formatting a disk leaves most if not all existing data on the disk medium; some or most of which might be recoverable with special tools.^[4] Special tools can remove user data by a single overwrite of all files and free space.^[5]

REFERENCE

1. https://en.wikipedia.org/wiki/Microsoft_Windows

2. https://support.hp.com/my-en/document/bph07110

3. https://www.techopedia.com/definition/3515/operating-system-os

4. https://www.slideshare.net/priyapatra372/types-of-operating-system-64344527

5. https://en.wikipedia.org/wiki/Start_menu

6. https://en.wikipedia.org/wiki/Windows_Installer

7. https://en.wikipedia.org/wiki/Disk_formatting