Transcription of Introduction to Database Concepts
{{id}} {{{paragraph}}}
Example: barber
Introduction to Database Concepts
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
Introduction to Databases 10 Entity Relationship Model (Cont.) Q E-R model of real world + Entities (objects) E.g. customers, accounts, bank branch + Relationships between entities E.g. Account A-101 is held by customer Johnson Relationship set depositor associates customers with accounts Q Widely used for database design + Database design in E ...
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: