Computer Free Learning

DBMS Tables A table is a set of data represented by columns and rows. A column is referred to as a field and a row is a combination of column values and is referred to as a record. Tables contain a unique set of characteristics and they store data of the same type in each row. Data Fields A data field which is one piece of information you track in your database. Each data field in the table can define the characteristics of its data as a string value, numeric value, date and/or time values. Relationships A relational database contains tables that relate to another table by using a relationship. The tables are connected by a common field. The relationships are defined as: One to Many: this is the most common type of a table relationship. For every record in Table A, there are multiple records in Table B.  Example: There is a one to many relationship between the Customers table and Orders table. A customer may have many orders in the Order table. Many to Many: For every record in Table A...

A database is an organized collection of data that is stored electronically. It is designed to be efficient, secure, and scalable, and is typically managed by a database management system (DBMS). A database consists of one or more tables, each of which contains a set of related data. Tables are organized into rows and columns, with each row representing a unique record and each column representing a data field. For example, a table might contain customer records, with each row representing a single customer and each column representing a piece of information about the customer, such as their name, address, and phone number. Here are some of the key features of a database: Data organization: A database is designed to organize data in a way that is efficient and easy to access. This typically involves breaking down complex data structures into simple tables that can be easily searched and sorted. Data consistency: A database is designed to ensure that data is consistent and accurate. Thi...

A database management system (DBMS) is a software application that is used to manage and organize data. It is designed to allow users to store, retrieve, modify, and analyze data in a structured and efficient way. A DBMS typically includes a set of tools for managing data, including a database engine, a query language, and tools for designing and maintaining databases. Some of the key features of a DBMS include: 1. Data modeling: A DBMS allows users to create a conceptual and logical model of the data that they want to store in the database. This involves defining entities, attributes, and relationships between them. 2. Data storage: A DBMS provides tools for storing data in a structured way, using tables or other data structures. It also manages the physical storage of data on disk or other storage media 3. Data retrieval: A DBMS allows users to retrieve data from the database using a query language. The query language enables users to specify the criteria for selecting data from the...

A step by step instructions and guidance  on how to create a Google form Create,send,share and edit a form Google  forms are a useful tool to help you plan events, send a survey, give students  a quiz, or collect other information in an easy, streamlined way. Google forms are available for the public to access by simply giving the URL of the form to those who need to complete the form. When you send or share a form,recipients’ responses will automatically be collected.  A Google form is automatically connected to a spreadsheet with the same title.The spreadsheet defaults to private sharing. You will need to access the spreadsheet to update the sharing rights for the spreadsheet that contains the responses from completed forms. Create and send a Google form You can create and share a form from your Documents List or from any existing spreadsheet . Create a form from your Documents List: 1. Click Create new > Form. The form you create will be connected to a  sp...

Ready to start learning the best five tips to identify and clarify spam emails from your computer system Android phone. while many experienced internet users (and inexperienced as well) are used to seeing literally thousands of unread letters in their inbox, some of us want to keep the mail organized. It is also never a pleasant experience to be bombarded by spam emails.  The problem is that many spam letters actually contain viruses and other malicious content that should never be viewed or even opened. In order to avoid such things, you need to learn how to identify spam emails from regular letters sent to you by businesses and friends. Corporations devote significant resources to fight spammers, but a single user cannot rely on automation and vast resources. So what should you do? Know your enemy Spam is what we call all emails that are sent out by businesses and scammers to access wide audiences. While the vast majority of spam is harmless and will collect cybernetic dust in yo...

A full details of html tags in summary Basic Tags <html> </html> Creates an HTML document <head> </head> Sets off the title & other info that isn't displayed <body> </body> Sets off the visible portion of the document <title> </title> Puts name of the document in the title bar; when bookmarking pages, this is what is bookmarked Body attributes (only used in email newsletters) <body bgcolor=?> Sets background color, using name or hex value <body text=?> Sets text color, using name or hex value <body link=?> Sets color of links, using name or hex value <body vlink=?> Sets color of visited links, using name or hex value <body alink=?> Sets color of active links (while mouse-clicking) Text Tags <pre> </pre> Creates preformatted text <h1> </h1> --> <h6> </h6> Creates headlines -- H1=largest, H6=smallest <b> </b> Creates bold text (should use <strong>...

Responsive web design provides an optimal experience, easy reading and easy navigation with a minimum of resizing on different devices such as desktops, mobiles and tabs, Responsive web design uses only HTML and CSS , it is not a program or a JavaScript. When you use CSS and HTML to resize, hide, shrink, enlarge, or move the content to make it look good on any screen it is called Responsive Web Design. Web pages can be viewed using many different devices like desktops, tablets, and phones. Your web page should look good, and be easy to use, regardless of the device Web pages should not leave out information to fit smaller devices, but rather adapt its content to fit any device. VIEWPORT The viewport is the user's visible area of a web page, the viewport varies with the device, and will be smaller on a mobile phone than on a computer screen. Before tablets and mobile phones, web pages were designed only for computer screens, and it was common for web pages to have a static design an...