Transcription of Introduction to Database Concepts
{{id}} {{{paragraph}}}
1 Part I: Introduction to DatabasesKostis Sagonas2 Introduction to DatabasesIntroduction to Database ConceptsQPurpose of Database SystemsQView of DataQData ModelsQData Definition LanguageQData Manipulation Language3 Introduction to DatabasesDatabase Management System (DBMS)QCollection of interrelated dataQSet of programs to access the dataQDBMS contains information about a particular enterpriseQDBMS provides an environment that is both convenient andefficient to Applications:+Banking: all transactions+Airlines: reservations, schedules+Universities: registration, grades+Sales: customers, products, purchases+Manufacturing: production, inventory, orders, supply chain+Human resources: employee records, salaries, tax deductionsQDatabases touch all aspects of our lives4 Introduction to DatabasesPurpose of Database SystemQIn the early days, Database applications were built on top offile systemsQDrawbacks of using file systems to store data:+Data redundancy and inconsistency Multiple file formats, duplication of information in different files+Difficulty in accessing data Need to write a new program to carry out each new task+Data isolation multiple files and formats+Integrity problems I
1 Part I: Introduction to Databases Kostis Sagonas Introduction to Databases 2 Introduction to Database Concepts Q Purpose of Database Systems Q View of Data Q Data Models Q Data Definition Language Q Data Manipulation Language Introduction to …
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Introduction, Engineering, Gamal Department of Electrical, Department of Electrical Engineering Stanford, RF Engineering, Engineering Aspects of Electromagnetic Shielding, INTRODUCTION - dB Engineering, 598 Database Management Spring 2012, Database, Chapter 1: Introduction, Polymer, Polymer Chemistry Polymer, Licensed under a Creative Commons