Page 62 - Code Craft Computer-8

Let's Connect

6 the Web App

to SQL Server

Core Concepts

On completion of this chapter you will be able to know:
¨ Database and DBMS ¨ Types of DBMS
¨ MySQL ¨ Login to MySQL Server
¨ Creating a Table in the Database ¨ Creating a Connection

Warm Up #Problem Solving

Draw and colour the logo of SQL server in the space given below.
#Art Integration

As you know from previous chapters, a Database Management System (DBMS ) is like keeping
files in a drawer of a cupboard. It arranges all your data in an orderly manner so that you can
retrieve information easily whenever you need it.

DATABASE AND DBMS
In more, simple terms, a database is a collection of data that is organized for easy access, retrieval

and management of its contents. A database has one or more related tables of data. The data can be
any format like text, numeric, images, audio, and video. It helps us to manage and access large
amount of information quickly and efficiently.
A Database Management System (DBMS) in its own, is a software package that provides
software programs to control the creation, maintenance and use of a database.

You also know that a DBMS that stores data in the form of tables and enables you to join the
tables by creating a link between them is called Relational Database Management System
(RDBMS). Some of the examples of DBMS are MS Access, Open Office database, Oracle, and
Microsoft SQL server.

62