1 / 11

Database Management

Database Management. Database. Database: A database is a collection of related data or facts. DBMS. DBMS: A database management system (DBMS) is a software tool that allows people to create, store , access, and process data or facts into useful information.

whitemaria
Download Presentation

Database Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Management

  2. Database • Database: A database is a collection of related data or facts.

  3. DBMS • DBMS: A database management system (DBMS) is a software tool that allows people to create, store, access, and process data or facts into useful information.

  4. Field: The smallest unit of data in a database; used to group each piece or item of data into a specific category. Fields are arranged in a column

  5. Records: One full set of fields – that is, all the related data about one person or object – is called a record. • Tables: A complete collection of records makes a table.

  6. Flat File database structures • A flat file database consists of a single data table. Flat file databases are useful for certain single user or small group situations., especially for list such as address list or inventories.

  7. Relational Database structures In a relational is made up of set of tables – a common field in any two tables creates a relationship between the tables

  8. Working with a Database 1. Creating tables 2. Viewing records 3. Sorting records 4. Creating queries 5. Generating report

  9. Common Database Management System • Oracle • SQL Server • MySQL • MS Access

  10. Creating Database Tables Name the Field Specify the Field type Specify the Field Size

  11. Primary Key Each table in a relational database has one field that is designated as its primary key. This key field is the unique identifier for all the information in any row of the table and this primary key cannot be duplicated.

More Related