1 / 15

CHAPTER 5 DATABASE

PREPARED BY: PN. SITI HADIJAH BINTI NORSANI. CHAPTER 5 DATABASE. LEARNING OUTCOMES:. Upon completion of this course, students should be able to: Understand the structure of relational database. List the advantages of managing data using database software.

zorion
Download Presentation

CHAPTER 5 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. PREPARED BY: PN. SITI HADIJAH BINTI NORSANI CHAPTER 5DATABASE

  2. LEARNING OUTCOMES: Upon completion of this course, students should be able to: • Understand the structure of relational database. • List the advantages of managing data using database software. • Identify the basic features of database software. • List the difference between database and spreadsheet software.

  3. WHAT IS A DATABASE? • Collection of data organized so you can access, retrieve, and use it. • Database software also called database management system (DBMS). • Many people use databases to store and organized personal information such as addresses, music and video collection – much more efficient than using sheets of paper or index cards.

  4. Basic Concepts of Relational Database Structure • Every organization has data that needs to be collected, managed, and analyzed. • A relational database fulfills these needs. • The relational model is the basis for any relational database management system.

  5. A relational model has three core components: • A collection of objects or relations • Operators that act on the objects or relations • Data integrity methods. • In other word, it has a place to store the data, a way to create and retrieve the data, and a way to make sure that the data is logically consistent.

  6. Type of Databases • Flat file database: Store information in one large table, and often contain duplicate information. Not flexible or efficient for storing large amounts of information • Relational databases: Store information in separate tables, and enable you to use relationships to bring together information from different tables. This type is powerful and flexible, and it effectively stores large amounts of information.

  7. Database Benefits. • Databases store and manage collections of information related to a particular subject or purpose. • Efficiently add, update, view and organized the information stored in a database. • Can instantly locate information in a database. • Create a table to hold your data, forms to enter and display the information, queries to ask questions of your data and generate reports that can be printed or distributed electronically. • Useful for finding specific data in large collection of information.

  8. Features of Database Software • Part of a Database Access databases consist of objects such as tables, queries, form, report, macros, and modules.

  9. Plan a Database

  10. Difference between Database and Spreadsheet software • Most people are familiar with some kind of spreadsheet, such as Microsoft Excel. • Spreadsheet are easy and convenient to use, and they may be employed by an individual much like a database is used in the enterprise. • Similar to database, spreadsheets are commonly used to store information in a tabular format.

  11. A spreadsheet can store data in rows and columns, it can link cells on one sheet to those on another sheet, and it can force data to be entered in a specific cell in a specific format. • It’s easy to calculate formulas from groups of cells on the spreadsheet, create chart, and work with data in other ways.

  12. But there are many ways in which a spreadsheet is not like a traditional database table:

  13. To be continue… Next class…

More Related