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

Entrepreneurial Skills

Image
I.T. (402)     Part- A    Unit IV Entrepreneurial Skills An Entrepreneur is a person who establishes a business or a venture that generates some value to the customer and proves to be profitable for him. An Enterpreneur starts a business with an eye on what he identifies as an unmet need in the market and works to fulfil. A business venture needs to have a novel element or process to make it acceptable and thriving in the market. Enterpreneuship  :- Enterpreneuship can be described as starting a business by using the resources available to a person. There is a direct relationship between entrepreneurship and society. An entrepreneur needs a society to establish a business and at the same time, society cannot function without the presence of entrepreneurs . In India , Bhavish aggarwal of Ola Cabs , Binny Bansal of Flipkart, and Deep Kalra of MakeMyTrip have been innovative entrepreneurs. They identified the changing needs of the time and came up with innovative ...
Read more