Mr-Web

  Client-Server Model   What is the Client-Server Model? ⦁ In order to build database-backed web applications, we first need to understand how servers, clients, and databases interact. ⦁ A major part of this is the client-server model, so let's look at that first. The basic idea is very simple, and looks something like this: ⦁  A server is a centralized program that communicates over a network (such as the Internet) to serve clients. ⦁  And a client is a program (like the web browser on your computer) that can request data from a server. ⦁  When you go to a web page in your browser, your browser (the client) makes a request to the server—which then returns the data for that page. Adding databases to the model : Relational Database Clients :   ⦁  A database client is any program that sends requests to a database. ⦁  In some cases, the database client is a webserver! When your browser makes a request, the web server acts as a server (fulfilling that request) ⦁  But when the web serve

 Primary Keys & Foreign Keys What Is Primary Key? ⦁ The primary key is the unique identifier for the entire row, referring to one or more columns. ⦁ if there are more multiple columns for the primary key, then the set of primary key columns is known as a composite key. What Is Foreign Key? ⦁ A primary key in another (foreign) table. ⦁ Foreign keys are used to map relationships between tables.     Primary Key vs Foreign Key  1 -   Primary Key ⦁ A primary key is used to ensure data in the specific column is unique. Foreign Key ⦁ A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables 2 -    Primary Key ⦁ It uniquely identifies a record in the relational database table. Foreign Key ⦁ It refers to the field in a table which is the primary key of another table. 3 -   Primary Key ⦁ Only one primary key is allowed in a table. Foreign Key ⦁ Whereas more than one foreign key is allowed in a table. 4 - Primary Key ⦁ It is a

What Is Relational Databases  Definitions : -   A database is a collection of data. -    A database system is a system for storing collections of data in some organized way. -    It uses a structure that allows us to identify and access data  in relation  to another piece of data in the database. -    Often, data in a relational database is organized into tables. What is a Relational Database Management System (RDBMS)? -    A relational database management system (RDBMS) is a program that allows you to create, update, and administer a relational database. -   Most relational database management systems use the SQL language to access the database. What is SQL? - SQL ( S tructured  Q uery  L anguage) is a programming language used to communicate with data stored in a relational database management system. - Every relational database system (PostgreSQL, SQLite, MySQL, etc) has its own "flavor" of SQL it implements. - Because they are not 100% compliant with SQL standa

 Illustrations Resources For Your Web Projects  Here is a list of 33 + websites that will provide you with free illustrations. In web design images are important but if we add more images to the website it will affect the performance of the website, we cannot add low-quality images to the website as it will not scale well and it affects the overall look of the website. Illustrations on the other hand they are lightweight and SVG formatted images scale well without any change in quality. Since the illustrations are lightweight it will not affect the performance of the website. All web developers are not good at creating illustration, below list are for them, including me. 1. Undraw 2. Draw Kit 3. Indian Doodle 4. Poke 5. open Doodles 6. Lukaszadam 7. IRA Design 8. Mixkit 9. Scale 10. Pulse 11. Gee Me 12. Absurd 13. The Noun project 14. Fresh-folk 15. Rawpixel 16. Webpixels : Eye Pop 17. Delesign 18. Manypixels 19. Icon8 20. Humaans 21. Streamline 22. Lucid 23. Ui8 24. Control.Rock