1 / 41

3.4 Database Management System

3.4 Database Management System. Unit 3. What is a database?. It’s an organized collection of data, related to a particular subject or purpose. Databases are actually much more powerful than spreadsheets. You can manipulate data much more easily using a database.

haven
Télécharger la présentation

3.4 Database Management System

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. 3.4 Database Management System Unit 3

  2. What is a database? It’s an organized collection of data, related to a particular subject or purpose.

  3. Databases are actually much more powerful than spreadsheets. You can manipulate data much more easily using a database.

  4. Some of the actions that you can perform on a database that would be difficult (if not impossible )to perform on a spreadsheet are: • Retrieve all records that match certain criteria • Update records in bulk • Cross-reference records in different tables • Perform complex aggregate calculations

  5. Index Number Index Number Name Name District District 1 1 Janaka Saman Kumara Janaka Saman Kumara Galle Galle 2 4 Priyantha Ilukdeniya Samanthi Iddamalgoda Galle Hambantota 3 6 Bandula Kariyawasam Nirmala Dilrukshi Anuradapura Galle 4 Samanthi Iddamalgoda Galle 5 Gunarathna Maddumage Hambanthota 6 Bandula Kariyawasam Galle 7 Chandrarathna de Silva Kalutara Retrieve all records that match certain criteria Students from Galle

  6. Index Number Index Number Qualifications Name District 1 1 Janaka Saman Kumara OL Galle 2 2 Priyantha Ilukdeniya AL Hambantota 3 3 Nirmala Dilrukshi OL Anuradapura 4 4 OL Samanthi Iddamalgoda Galle 5 5 GRADE 10 Gunarathna Maddumage Hambanthota 6 6 BA Bandula Kariyawasam Galle 7 7 Chandrarathna de Silva AL Kalutara Cross-reference records in different tables

  7. Data Base Management Systems (DBMS) • Access • FileMaker Pro • Oracle or • SQL Server

  8. Provides you with the software tools you need to organize data in a flexible manner. DBMS

  9. You can  Add data to the database Modify or delete data from the database Ask questions (or queries) about the data stored in the database and  Produce reports summarizing selected contents

  10. A DBMS contains several objects • Tables • Queries • Forms • Reports etc.

  11. Tables allow us to create the framework for storing information in a database. 

  12. A table organizes data into columns

  13. and Rows

  14. Name Name Sex Sex DOB DOB No No 001 001 002 002 003 003 004 Sunil 05/07/2005 Male 005 005 A row represent a RECORD containing all the information about one item (or entity).

  15. Name Name Sex Sex DOB DOB No No M 001 002 M 003 M 004 M 005 M A column represent a FIELD containing the same type of information about every record.

  16. Number Name District Tel.No. 1 Sunil Galle 2285462 2 Jagath Matara 2245231 3 Nishani Kalutara 2234752 FIELD NAMES RECORD FIELD

  17. If a database only stores information it would be useless. - We need to retrieve information as well.

  18. Index Number Index Number Name Name District District 1 1 Janaka Saman Kumara Janaka Saman Kumara Galle Galle 4 2 Samanthi Iddamalgoda Priyantha Ilukdeniya Hambantota Galle 3 6 Nirmala Dilrukshi Bandula Kariyawasam Anuradapura Galle 4 Samanthi Iddamalgoda Galle 5 Gunarathna Maddumage Hambanthota 6 Bandula Kariyawasam Galle 7 Chandrarathna de Silva Kalutara Retrieve information on those living in Galle

  19. If you simply want to recall the information stored in a table you can open the table and scroll through the records contained within it  

  20. Or  You can query thetable so that it can retrieve data according to your request with the use of QUERIES

  21. Forms are user-friendly interfaces that allow users to enter information in a graphical form. That information can be directly passed to the database. 

  22. Information could be retrieved from our database through the use of queries in a tabular form . -- not exactly the most attractive marketing material! 

  23. Reportsprovide attractively formatted summaries of the data contained in one or more tables and/or queries. 

  24. Reports allow the inclusion of graphics, attractive formatting and pagination. 

  25. Offer an organized mechanism for storing, managing and retrieving information through the use of tables

  26. Microsoft Access

  27. 2. Click here 1. Click here How to start Microsoft Access 1

  28. 1. Select this 2. Click this 2

  29. 1. Enter a file name here 2. Click here 3

  30. 4 Microsoft Access Database window

  31. Database objects Database objects Database objects Database objects

  32. To create a table in Design view: 3. Click 1. Select 2. Select

  33. 1. Select

  34. 2. Click

  35. 2. Select the Data Type by clicking the down arrow 3. Type a description here 1. Enter Field Name here

  36. To Save the table • Click File • Select Save • Type a file name • Click OK

  37. We can use two methods to place information into tables  By opening the table and adding data By using a user friendly graphical FORM to add data

  38. To Open the table 2. Click Open 1. Select the table

  39. Data Sheet view

  40. Record 1 Record 2 Record 3

  41. Thank You

More Related