Data Base Management System (DBMS)

  Database Management System


Database is a collection of a data, which is stored in a systematic manner, i.e. in the form of tables so that we you can retrieve and manipulate information quickly and effeciently from a large set of data. A database consists of one or more tables. A table contains  information in the form rows and coloumns. Rows are called as Records. Columns are called as Fields.  


The Database Management System (DBMS) is a computerised record keeping system that enables us to create, store, modify and extract information from a database.

Advantages Of Database Management System 
Keys 

  1. Primary Key
  2. Composite Primary Key
  3. Foreign Key
  4. Candidate Key


Database Objects 





























Ways to Create Tables In Ms Accesss 



Design 
View 















Datasheet View







Forms

A form is a printable or typed document with blank spaces for insertion of the requires or requested information.
Example of a form-



























































Comments

Post a Comment

Popular posts from this blog

Web Applications And Security

Image
 Web Applications and Security Computer Networks  Computer network is a group of two or more computers systems or peripheral devices that are connected together to exchange information and share resources with each other. Types Of Networks Personal Area Network (PAN) Local Area Network (LAN) Metropolitan Area Network (MAN) Wide Area Network (WAN)  Advantages Disadvantages of Computer Networks Network Components Switch Repeater Hub Router Bridge E-Shopping The process of buying an selling things online is called E-Shoping or Online Shopping.  Examples of E-Shopping are-
Read more

Green Skills

Image
  I.T. (402)     Part- A     Unit V Sustainable Development Sustainable development is the development that meets the needs of present without compromising the ability of future generations to meet their own needs. Principles of Sustainable Development Economic Growth Environmental Protection Social Inclusion Cultural Diversity Measures To Be Taken For Sustainable Development  Proper use of Means and Resources  Development of Positive Attitude and Hoslistic Apporch Towards Conservation Integrated Socio-Economic development Development Based on People's participation  Limited Development Long-Lasting Development Thus, sustainable development is essential because it helps us to look at our world differenntly- that economies should grow, compaines should thrive, people should have decent work and new innovative technologies should be created, but not at the cost of the environment. Sustainable Development Goals (SDG's) Sustainable Development Goals are the collection of 17 goals s
Read more