WEEK -11

DATA BASE MANAGEMENT SYSTEM (DBMS)

DBMS...

- Stands for "Database Management System." In short, a DBMS is a database program. Technically speaking, it is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs.

- Some DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro. Since there are so many database management systems available, it is important for there to be a way for them to communicate with each other. For this reason, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program's proprietary syntax into a syntax other databases can understand.

Data Base Components... 

• Tables: tables are where the actual data is defined and entered. Tables consist of records (rows) and fields (columns). 

• Queries: queries are basically questions about the data in a database. A query consists of specifications indicating which fields, records, and summaries you want to see from a database. 
• Forms: forms are designed to ease the data entry process. For example, you can create a data entry form that looks exactly like a paper form.
• Reports: when you want to print records from your database, design a report. Access even has a wizard to help produce mailing labels.
• Pages: a data access page is a special type of Web page designed for viewing and working with data from the Internet or an intranet. 
• Macros: a macro is a set of one or more actions that each performs a particular operation, such as opening a form or printing a report. 
• Modules: a module is a collection of Visual Basic for Applications declarations and procedures that are stored together as a unit. 

Some DBMS...

• Microsoft Access
• Oracle
• IBM DB2
• SQL Server
• MySQL

Types of Data Base... 

• Hierarchical database 
• Network database  
• Relational database  
• Object-Relational database

 SQL -Structure Query Language...

Is a standard language for accessing and manipulating databases? Although SQL is an ANSI (American National Standards Institute) standard, there are many different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

 
MS-Access...

Microsoft Access is an application used to create small and midsize computer desktop databases for the Microsoft Windows family of operating systems. It can also be used as a database server for a web-based application. It is also supported by ADO, ODBC, and the .NET Framework, etc.