1 / 34

Introduction to Database

Introduction to Database. T. B. A. A. E. A. D. S. What is Database?. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Is a tool for collecting and organizing information. Database program lets you:. Store information

malha
Télécharger la présentation

Introduction to Database

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. Introduction to Database

  2. T B A A E A D S

  3. What is Database? • A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. • Is a tool for collecting and organizing information

  4. Database program lets you: • Store information • Find information • Analyze and print information • Manage information • Share information

  5. Kinds of Databases

  6. Types of Databases

  7. Structured Database Models • Hierarchical model • Network model • Relational model • Entity-relationship model • Dimensional Model • Object-relational model

  8. Hierarchical Model • Can be visualized as parent-child relationship wherein a child may only have one parent but a parent can have several children. Publisher Authors Bookstore Manuscript Deliveries Payment

  9. Network Model • This model was developed to address in part the problems of the hierarchical model. • This model allows sharing of branches but are still part of the same database structure. Publisher Manage Represent Bookstore Authors Make Arrange Arrange Arrange Manuscript Book Launching Book Category

  10. Developed by Dr. E.F. Codd of IBM in 1970s to solve the problems of the earlier database models as well as finding a way of making database management less dependent to any application. Relational Model Publisher Authors Bookstore Book Category Books Book Arrangement

  11. Terminologies • Relation = is a table with columns and rows • Attributes = are the names given to each column of the relation. • Domain = is the set of possible values which the attributes will take • Tuples = usually represents an object and information about that object

  12. Sample

  13. Entity-relationship model • this model was written by Peter Chen in 1976. This model is an abstract and conceptual representation of data

  14. Dimensional Model • Is a specialized adaptation using the relational model that is used to represent data in data warehouses. • Data warehouse storage of all digital data of a company or organization. • Dimensions  tells where, who and what type • Measures means quality.

  15. Object-relational Model • Is a model that utilizes the relationship model as well as the object-oriented programming paradigm.

  16. What is RDBMS?

  17. Relational Database Management System  Is designed to create, maintain, manipulate, modify and delete information in a relational database.

  18. Things you can do with RDBMS: • Create a database • Information storage • Information retrieval • Information management • Information analysis • Print and share information.

  19. Characteristics of a GOOD Database Information • Accurate • Organized • Timely • Verifiable • Accessible • Economical • Useful

  20. Relational Database Terminologies

  21. Relationships • Primary Key • Foreign Key • Linking table a table that establishes a connection between two or more table.

  22. Types of Relationship • One-to-One Relationship • One-to-Many Relationship • Many-to-Many Relationship

  23. One-to-One Relationship Student ID First Name Last Name Phone 001 Ritchell Galeos 555-8282 002 Alce Navaluna 555-6513 003 Armando Talaid 555-1289 Student ID Section Adviser 001 St. Thomas Ms. Sator 002 St. Dominic Mr. Taraya 003 St. Catherine Mr. Dacalos Students Table Sections Table

  24. One-to-Many Relationship PublisherCode Name Country Phone 198801 Jemma Philwzxc 555-8282 Publisher Table Book Table ISBN Pub Code Book Title Price 9781235 198801 Creative Design P424.00 9781236 198801 Web Design P324.00 9781237 198801 Office Productivity P424.00

  25. Many-to-Many Relationship Students Table Subjects Table

  26. Designing a Database • Define the purpose of your database • Determine the tables that you need in the database. • Determine the fields that you need in the database. • Identify unique field values • Determine the relationship between tables. • Test the design by entering sample data.

  27. Characteristics of a Well Designed Database • Modify data easy. • Retrieving information easy. • Developing and building user application is easy. • Maintaining the structure is easy. • Adding and deleting data is easy.

  28. Database Design to Avoid • Spreadsheet design • Spreadsheet view • Building a database design on the database software

More Related