1 / 8

DATABASE MANAGEMENT

DATABASE MANAGEMENT. BY GOBETTI ANDREA. What is a database?. Integrated set of data files allows easy cross-referencing of related data items promotes integrity eliminates redundancy. Differences between database and file management software. Allow to manipulate data Create reports

amadis
Download Presentation

DATABASE MANAGEMENT

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. DATABASE MANAGEMENT BY GOBETTI ANDREA

  2. What is a database? • Integrated set of data files • allows easy cross-referencing of related data items • promotes integrity • eliminates redundancy

  3. Differencesbetween database and file management software • Allow to manipulate data • Create reports • Handle individual enquires • F.M.S. works with only one file at time

  4. Database models • Hierarchical • Network • Relational

  5. Hierarchical model • Data items and references are related in a top-down structure • Makes possible orderly navigation of paths to the desired information • The same path must be followed for each access operation

  6. Network model • There’s always a hierarchical structure • “Random Access” is possible • Multiple access paths are possible between records

  7. Relational model • A series of files organized as data tables • Some relation tables to link data together • “Random Access” is possible

  8. DBMS (DataBase Management System) Some essencial facilities: • Create (table with fields) • Insert (records into tables) • Amend and delete • Search

More Related