1 / 24

IT Applications Theory Slideshows

A database is an organized collection of data managed by Database Management Systems (DBMS) like Access or SQL. Databases serve various purposes, including storing, sorting, and reporting large volumes of information, managing transactions, personnel records, inventory, and more. They are essential in sectors such as finance, education, healthcare, and customer management. Key terms related to databases include tables, records, primary keys, queries, and entity-relationship diagrams. Understanding these components and their applications is crucial for effective data management and utilization.

varen
Download Presentation

IT Applications Theory Slideshows

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. Databases - purposes and applications IT Applications Theory Slideshows

  2. What are databases? • A database is • an organised collection of data (e.g. details of your CD collection) • DBMS (Database Management System) is • software that creates and manages databases. E.g. Access, Filemaker, SQL. • Use these terms appropriately

  3. What do databases do? • Store data • Search data • Sort, group, calculate data • Report on data

  4. Purposes Databases are used to store and manage large quantities of information such as… • Recording transactions • Bank deposits, withdrawals, credit card use • Transaction Processing System (TPS) recording sales • Summarising bulk data • Management Information Systems • Executive information Systems

  5. Purposes • Chronologies • Calendars • Diaries • Work Logs

  6. Purposes • Mass mailings • Cheques • Gas bills etc • Renewal notices • Membership notifications • Cards, labels

  7. Purposes • Personnel records • A school’s student records • A company’s staff records • School attendance • Factory work logs, to calculate wages

  8. Purposes • Network management • Network & internet login names, passwords, privileges, restrictions • Printing credit • Internet credit

  9. Porpoises • Storing knowledge • KnowledgeBases • FAQs • Expert Systems • Wikis

  10. Purposes • Event information • Automated system error log • Help desk requests • Medications issued to patients • Reports • School reports • Financial summaries • Monthly bank statements

  11. Purposes • Booking systems • Airlines • Theatre tickets • Doctors’ appointments • Restaurant bookings

  12. Puppies • Inventories • How many size 26 blue socks are left in stock? • Is it time to reorder left-handed rubber flange grommets? How would you do this? • Software registers • Online shopping with real-time stock availability (e.g. Amazon) • Library catalogues

  13. Papooses • Customer Lists • Customer records: name, address, purchases etc • Car buyers automatically notified of safety recalls • Dentist, doctor, optometrist reminders about checkups being due • Library loans

  14. Purposes • Government records • Medicare payments • Tax records • Car registrations, driver licences • Births, deaths and marriages • Criminal records • Passports, immigration records • Pharmacy prescriptions

  15. Posses • Supplier lists • Who provides your shop with green socks? • Assets • Furniture, IT equipment, vehicles, tools etc owned by an org

  16. Purposes • Event management • School sports carnival events, competitors and results • Competition entries, winners • Community management • Website, web forum memberships • Mailing lists • Club membership lists

  17. Purpoos • Financial records • Tax records, including GST & BAS figures • Income, costs, profit/loss • ISP records of customer downloads • Insurance company policy holders & expirations • Magazine subscriptions

  18. Purr pussies • Catalogues • Libraries • University & museum collections • Photos (e.g. Flickr) • Torrent trackers • eBay items • Timetabling • School timetables, class lists • Public transport timetables

  19. Basically, databases are ubiquitous!

  20. Terms to know • Table • Fields • Records • Field types – including Boolean • Validation • Range check, data type check, existence check, limited entry options

  21. Terms to Know • Form (input) • Query find • Report (output)

  22. Terms to know • Access hierarchy • Different levels of access for different people or groups • Scripting, macros • Automate tasks that are done often

  23. Terms to Know • Primary key, foreign key • Relational • Flat-file • Relationships • 1:1 • 1:many • many:many

  24. Terms to know • Design tools • Entity Relationship Diagram (Data structure diagram) • Data structure diagram table • Layout diagram (mock up)

More Related