Database Assignment Help

1
DatabaSE assignment help

• ByEssayCorp

2
Table of contents

• WHAT IS DATABASE ?
• USES OF DATABASE
• WHAT KIND OF INFORMATION COULD WE STORE IN A
  DATABASE ?
• WHAT IS DATABASE MANAGEMENT SYSTEM ?
• SOME IMPORTANT DATA CONCEPTS
• WHAT IS FILE PROCESSING ?
• PROBLEMS OF FILE PROCESSING
• FUNCTIONS OF DBMS
• ADVANTAGES OF DBMS
• WHAT IS A DATA MODEL ?
• LEVELS OF ABSTRACTION
• CONTACT US

3
What is database ?

• A database is a collection of information that is
  organized in a way which make it easy to be
  accessed, managed and updated. We can present the
  data in the form of graphics, reports, tables,
  scripts, text etc.

4
What is database ?

• The word database is used to refer to any of the
  following
• Data used to support the launch of a space
  shuttle.
• Data collected, maintained, and used in airline
  reservation.
• A very large flat file on which you run some
  statistical analysis functions.
• A collection of Excel Spreadsheets.
• A collection of Word documents.
• Your personal address book in a Word document.

5
Uses of database

• The two main uses of database are
• Storing Information
• Sorting Information

6
What kind of information could we store in a
database ?

• Telephone numbers
• Patient information
• Business clients
• Car registration plate owners
• Parents contact information for children in a
  school
• Name and phone numbers of friends

7
What is database management system ?

• A database management system (DBMS) is a system
  software used for creating and managing
  databases. The DBMS provides users and
  programmers with a systematic way to create,
  retrieve, update and manage data.

8
Some important data concepts

• ENTITY - Entity is the person, place, object or
  event. And it get stored as a record or a table
  row.
• ATTRIBUTE - Attribute is the characteristic of an
  entity. And it get stored as a field or a table
  column.
• DATABASE - Database is a collection of related
  tables.

9
Some important data concepts

• TABLES - Table is a collection of  related
  records (collection of related entities).
• RECORD - Record is a collection of fields (table
  row) and it represents an entity.
• FIELD - Field is a collection of characters
  (table column) and represents an attribute.
• CHARACTER - Character is a single alphabetic,
  numeric or other symbols.

10
Database

• A database can represent a single business or an
  entire market.
• A database also includes relationships between
  the different table.

11
tables

• A bunch of records form a table.
• A table is a group of related entities.

FIRST NAME LAST NAME AGE SEX
Henry Hernandez 19 M
John Cooper 21 M
Rose Miller 20 F
12
Record

• A record is an entity.
• A bunch of fields form a record.

FIRST NAME
Henry
LAST NAME
Hernandez
13
Field

• Characters H E R N A N D E Z form a field.
• A field is an attribute of an entity.

LAST NAME
Hernandez
14
What is file processing ?

• When the organized data is stored and processed
  in independent files of data records.

15
Problems of file processing ?

• DATA REDUNDANCY - Data redundancy means duplicate
  data require update to many files.
• LACK OF INTEGRATION - Lack of integration means
  data stored in separate files hard to combine
  data.
• DATA DEPENDENCY - Data dependency means changing
  the file format requires changing the program.

16
Function of dbms

• There are certain functions of DBMS
• Data Integrity Management
• Backup and Recovery Management
• Data Dictionary Management
• Security Management

17
Advantages of dbms

• It controls Data Redundancy.
• It provides data consistency by controlling data
  redundancy.
• Authorized users can share data within an
  organization.
• A database is a combination of tables and
  relationships, which makes the user to easily
  update and retrieve data.

18
What is a data model ?

• A Data model is a collection of concepts for
  describing data.
• A schema is a description of a particular
  collection of data, using a given data model.
• The relational model of data is the most widely
  used model today.
• Main concept  relation, basically a table with
  rows and columns.
• Every relation has a schema, which describes the
  columns, or fields.

19
Levels of abstraction

• Views describe how users see the data.
• Conceptual schema defines logical structure.
• Physical schema describes the files and indexes
  used.
• Sometimes called the ANSI/SPARC model.

20

• FOR MORE, VISIT
• https//www.essaycorp.com/database_assignment_help
  .html

21

• THANK YOU