際際滷

際際滷Share a Scribd company logo
Introduction to
Database Systems
CODE OF ETHICS
 All students must come to class on time
(Attendance will be taken in first 5 to 10 mins)
 Students should remain attentive during class and
avoid use of Mobile phone, Laptops or any gadgets
 Respect faculty and staff through actions and
speech
 Class participation is encouraged
2
Text Book
 Primary
 Database Systems 8E, C.J.Date, Addison Wesley Pub.
Co. (2004).
 Reference
 Database Systems: A Practical Approach to Design,
Implementation and Management 5E, R.Connolly and
P.Begg, Addison-Wesley Pub. Co (2009).
 Fundamentals of Database Systems, 5E, Elmasri and
Navathe, Addison-Wesley, ISBN: 0-201-74153-9.
Sequence [TodaysAgenda]
Content of Lecture
 Basic Database Concepts (Definitions)
 Different File Systems
 Database and its Advantages
What is a Database
Database Def-1
A database is a shared collection of logically
related data that is stored to meet the
requirements of different users of an organization.
Database Def-2
A database is a self-describing collection of
integrated records
Database Def-3
A database models a particular real world
system in the computer in the form of data
The concept of a shared
organizational database
Accounting
Accounts
Payable
Accounts
Receivable
Management
Control
Planning
Manufacturing
Production
Scheduling
Marketing
Product
Development
Sales
Corporate
Database
A bit of History
 Computer initially used for computational/
engineering purposes.
 Commercial applications introduced File Processing
System.
Different Files Systems
 Manual File System
 Computerized File System
 Database System
Manual File System
 Way of managing data using:
 Pen and Paper
 Data Storage:
 Record data on paper.
 File paper away into folders and cabinets.
 Data Retrieval:
 Locate paper from cabinets and folders.
 Retrieve data from paper.
 Main disadvantages: Data collection increased by
time to time and keeping track of data becomes
much difficult.
Computerized File Processing
System
A collection of programs that perform services for
the end-users such as production of reports
Computerized File Processing
System
Program and Data Interdependence
Registration
Applications
Registration
Data
Files
Registration
Examination
Applications
Examination
Data
Files
Examination
Library
Applications
Library
Data
Files
Library
Computerized File Processing
System
Fine
Books Issued
Father Name
Name
Reg_Number
Library
Grade
Semester
Class
Address
Name
Reg_Number
Examination
Class
Address
Phone
Father Name
Name
Reg_Number
Registration
Duplication of Data
Vulnerable to Inconsistency
Database System
A database system is a relationship between stored
data, a database, users and the hardware or
operating system used for the storage.
Database System
Registration
Examination
Library
Applications
Library
Examination
Applications
Registration
Applications
Database
Management
System
University
Students
Database
Advantages of Database
 Persistent
 Data stored in a database can usually last for a long
time
 Shared
 Data stored in a database can be simultaneously
accessed by multiple programs
 Interrelated
 Data stored in a database can be combined to produce new data
19

More Related Content

Similar to Lec 1 Database.ppt (20)

CS3270 - DATABASE SYSTEM - Lecture (1)
CS3270 - DATABASE SYSTEM -  Lecture (1)CS3270 - DATABASE SYSTEM -  Lecture (1)
CS3270 - DATABASE SYSTEM - Lecture (1)
Dilawar Khan
Chapter 1 Intro to DBS.pdf
Chapter  1 Intro to DBS.pdfChapter  1 Intro to DBS.pdf
Chapter 1 Intro to DBS.pdf
TamiratDejene1
Chapter 1 Intro to DBS.pdf
Chapter  1 Intro to DBS.pdfChapter  1 Intro to DBS.pdf
Chapter 1 Intro to DBS.pdf
TamiratDejene1
Database & Database Users
Database & Database UsersDatabase & Database Users
Database & Database Users
M.Zalmai Rahmani
computer fund-database presentation
 computer fund-database presentation computer fund-database presentation
computer fund-database presentation
Rakibul islam
Database Systems - Lecture Week 1
Database Systems - Lecture Week 1Database Systems - Lecture Week 1
Database Systems - Lecture Week 1
Dios Kurniawan
DBMS Lecture 1.ppt
DBMS Lecture 1.pptDBMS Lecture 1.ppt
DBMS Lecture 1.ppt
MohsinBajwa18
System Analysis And Design
System Analysis And DesignSystem Analysis And Design
System Analysis And Design
Lijo Stalin
ESSENTIAL of (CS/IT/IS) class 06 (database)
ESSENTIAL of (CS/IT/IS) class 06 (database)ESSENTIAL of (CS/IT/IS) class 06 (database)
ESSENTIAL of (CS/IT/IS) class 06 (database)
Dr. Mazin Mohamed alkathiri
Anshu Joshi_2371050_DBMS.pptxData base management system
Anshu Joshi_2371050_DBMS.pptxData base management systemAnshu Joshi_2371050_DBMS.pptxData base management system
Anshu Joshi_2371050_DBMS.pptxData base management system
anshjoshi7417
Database Systems Lec 1.pptx
Database Systems Lec 1.pptxDatabase Systems Lec 1.pptx
Database Systems Lec 1.pptx
NishaTariq1
DB Lecture 01.ppt
DB Lecture 01.pptDB Lecture 01.ppt
DB Lecture 01.ppt
KalsoomBajwa
Lec20.pptx introduction to data bases and information systems
Lec20.pptx introduction to data bases and information systemsLec20.pptx introduction to data bases and information systems
Lec20.pptx introduction to data bases and information systems
samiullahamjad06
Information Management
Information ManagementInformation Management
Information Management
EllenGracePorras
Intoduction- Database Management System
Intoduction- Database Management SystemIntoduction- Database Management System
Intoduction- Database Management System
Dr. Jasmine Beulah Gnanadurai
PPT-UEU-Basis-Data-Pertemuan-1.pptx
PPT-UEU-Basis-Data-Pertemuan-1.pptxPPT-UEU-Basis-Data-Pertemuan-1.pptx
PPT-UEU-Basis-Data-Pertemuan-1.pptx
UbaidURRahman78
Lecture-1.ppt
Lecture-1.pptLecture-1.ppt
Lecture-1.ppt
ChSheraz3
01-Database Administration and Management.pdf
01-Database Administration and Management.pdf01-Database Administration and Management.pdf
01-Database Administration and Management.pdf
TOUSEEQHAIDER14
DBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational databaseDBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational database
walaahuluu
This discussion about the dbms introduction
This discussion about the dbms introductionThis discussion about the dbms introduction
This discussion about the dbms introduction
rishabsharma1509
CS3270 - DATABASE SYSTEM - Lecture (1)
CS3270 - DATABASE SYSTEM -  Lecture (1)CS3270 - DATABASE SYSTEM -  Lecture (1)
CS3270 - DATABASE SYSTEM - Lecture (1)
Dilawar Khan
Chapter 1 Intro to DBS.pdf
Chapter  1 Intro to DBS.pdfChapter  1 Intro to DBS.pdf
Chapter 1 Intro to DBS.pdf
TamiratDejene1
Chapter 1 Intro to DBS.pdf
Chapter  1 Intro to DBS.pdfChapter  1 Intro to DBS.pdf
Chapter 1 Intro to DBS.pdf
TamiratDejene1
Database & Database Users
Database & Database UsersDatabase & Database Users
Database & Database Users
M.Zalmai Rahmani
computer fund-database presentation
 computer fund-database presentation computer fund-database presentation
computer fund-database presentation
Rakibul islam
Database Systems - Lecture Week 1
Database Systems - Lecture Week 1Database Systems - Lecture Week 1
Database Systems - Lecture Week 1
Dios Kurniawan
DBMS Lecture 1.ppt
DBMS Lecture 1.pptDBMS Lecture 1.ppt
DBMS Lecture 1.ppt
MohsinBajwa18
System Analysis And Design
System Analysis And DesignSystem Analysis And Design
System Analysis And Design
Lijo Stalin
Anshu Joshi_2371050_DBMS.pptxData base management system
Anshu Joshi_2371050_DBMS.pptxData base management systemAnshu Joshi_2371050_DBMS.pptxData base management system
Anshu Joshi_2371050_DBMS.pptxData base management system
anshjoshi7417
Database Systems Lec 1.pptx
Database Systems Lec 1.pptxDatabase Systems Lec 1.pptx
Database Systems Lec 1.pptx
NishaTariq1
DB Lecture 01.ppt
DB Lecture 01.pptDB Lecture 01.ppt
DB Lecture 01.ppt
KalsoomBajwa
Lec20.pptx introduction to data bases and information systems
Lec20.pptx introduction to data bases and information systemsLec20.pptx introduction to data bases and information systems
Lec20.pptx introduction to data bases and information systems
samiullahamjad06
PPT-UEU-Basis-Data-Pertemuan-1.pptx
PPT-UEU-Basis-Data-Pertemuan-1.pptxPPT-UEU-Basis-Data-Pertemuan-1.pptx
PPT-UEU-Basis-Data-Pertemuan-1.pptx
UbaidURRahman78
Lecture-1.ppt
Lecture-1.pptLecture-1.ppt
Lecture-1.ppt
ChSheraz3
01-Database Administration and Management.pdf
01-Database Administration and Management.pdf01-Database Administration and Management.pdf
01-Database Administration and Management.pdf
TOUSEEQHAIDER14
DBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational databaseDBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational database
walaahuluu
This discussion about the dbms introduction
This discussion about the dbms introductionThis discussion about the dbms introduction
This discussion about the dbms introduction
rishabsharma1509

More from ssuserd527bb (6)

Social Stratification (1).pptx
Social Stratification (1).pptxSocial Stratification (1).pptx
Social Stratification (1).pptx
ssuserd527bb
Acculturation vs Assimilation.pptx
Acculturation vs Assimilation.pptxAcculturation vs Assimilation.pptx
Acculturation vs Assimilation.pptx
ssuserd527bb
Role and Status (1).pptx
Role and Status (1).pptxRole and Status (1).pptx
Role and Status (1).pptx
ssuserd527bb
Social Institutions.pptx
Social Institutions.pptxSocial Institutions.pptx
Social Institutions.pptx
ssuserd527bb
madiha.pptx
madiha.pptxmadiha.pptx
madiha.pptx
ssuserd527bb
Lecture 14 Database.ppt
Lecture 14 Database.pptLecture 14 Database.ppt
Lecture 14 Database.ppt
ssuserd527bb
Social Stratification (1).pptx
Social Stratification (1).pptxSocial Stratification (1).pptx
Social Stratification (1).pptx
ssuserd527bb
Acculturation vs Assimilation.pptx
Acculturation vs Assimilation.pptxAcculturation vs Assimilation.pptx
Acculturation vs Assimilation.pptx
ssuserd527bb
Role and Status (1).pptx
Role and Status (1).pptxRole and Status (1).pptx
Role and Status (1).pptx
ssuserd527bb
Social Institutions.pptx
Social Institutions.pptxSocial Institutions.pptx
Social Institutions.pptx
ssuserd527bb
Lecture 14 Database.ppt
Lecture 14 Database.pptLecture 14 Database.ppt
Lecture 14 Database.ppt
ssuserd527bb

Recently uploaded (20)

Why Hire Python Developers? Key Benefits for Your Business
Why Hire Python Developers? Key Benefits for Your BusinessWhy Hire Python Developers? Key Benefits for Your Business
Why Hire Python Developers? Key Benefits for Your Business
Mypcot Infotech
Why Every Cables and Wires Manufacturer Needs a Cloud-Based ERP Solutions
Why Every Cables and Wires Manufacturer Needs a Cloud-Based ERP SolutionsWhy Every Cables and Wires Manufacturer Needs a Cloud-Based ERP Solutions
Why Every Cables and Wires Manufacturer Needs a Cloud-Based ERP Solutions
Absolute ERP
AI-Powered Chatbots for Employee Support
AI-Powered Chatbots for Employee SupportAI-Powered Chatbots for Employee Support
AI-Powered Chatbots for Employee Support
AutomationEdge Technologies
Computer Architecture Patterson chapter 1 .ppt
Computer Architecture Patterson chapter 1 .pptComputer Architecture Patterson chapter 1 .ppt
Computer Architecture Patterson chapter 1 .ppt
jaysen110
A Brief Introduction About Raman Bhaumik
A Brief Introduction About Raman BhaumikA Brief Introduction About Raman Bhaumik
A Brief Introduction About Raman Bhaumik
Raman Bhaumik
Consequences and Principles of Software Quality v1.0
Consequences and Principles of Software Quality v1.0Consequences and Principles of Software Quality v1.0
Consequences and Principles of Software Quality v1.0
Yann-Ga谷l Gu辿h辿neuc
AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]
AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]
AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]
haroonsaeed605
Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...
Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...
Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...
Philip Schwarz
SketchUp Pro Crack [2025]-Free Download?
SketchUp Pro Crack [2025]-Free Download?SketchUp Pro Crack [2025]-Free Download?
SketchUp Pro Crack [2025]-Free Download?
kiran10101khan
Carousel - Five Key FinTech Trends for 2025
Carousel - Five Key FinTech Trends for 2025Carousel - Five Key FinTech Trends for 2025
Carousel - Five Key FinTech Trends for 2025
Anadea
Adobe InDesign Crack Full Version Free Download 2025
Adobe InDesign Crack  Full Version Free Download 2025Adobe InDesign Crack  Full Version Free Download 2025
Adobe InDesign Crack Full Version Free Download 2025
sannnasaba545
LLM Security - Smart to protect, but too smart to be protected
LLM Security - Smart to protect, but too smart to be protectedLLM Security - Smart to protect, but too smart to be protected
LLM Security - Smart to protect, but too smart to be protected
Ivo Andreev
Online Software Testing Training Institute in Delhi Ncr
Online Software Testing Training Institute in Delhi NcrOnline Software Testing Training Institute in Delhi Ncr
Online Software Testing Training Institute in Delhi Ncr
Home
Data Storytelling for Portfolio Leaders - Webinar
Data Storytelling for Portfolio Leaders - WebinarData Storytelling for Portfolio Leaders - Webinar
Data Storytelling for Portfolio Leaders - Webinar
OnePlan Solutions
Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...
Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...
Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...
Shubham Joshi
Build the future with Agentforce and Mulesoft
Build the future with Agentforce and  MulesoftBuild the future with Agentforce and  Mulesoft
Build the future with Agentforce and Mulesoft
GiulioPicchi
Cybersecurity & Innovation: The Future of Mobile App Development
Cybersecurity & Innovation: The Future of Mobile App DevelopmentCybersecurity & Innovation: The Future of Mobile App Development
Cybersecurity & Innovation: The Future of Mobile App Development
iProgrammer Solutions Private Limited
Tenorshare 4uKey Crack Fre e Download
Tenorshare  4uKey  Crack  Fre e DownloadTenorshare  4uKey  Crack  Fre e Download
Tenorshare 4uKey Crack Fre e Download
oyv9tzurtx
Metaverse Meetup: Explore Mulesoft MAC Project
Metaverse Meetup: Explore  Mulesoft MAC ProjectMetaverse Meetup: Explore  Mulesoft MAC Project
Metaverse Meetup: Explore Mulesoft MAC Project
GiulioPicchi
Code or No-Code Tests: Why Top Teams Choose Both
Code or No-Code Tests: Why Top Teams Choose BothCode or No-Code Tests: Why Top Teams Choose Both
Code or No-Code Tests: Why Top Teams Choose Both
Applitools
Why Hire Python Developers? Key Benefits for Your Business
Why Hire Python Developers? Key Benefits for Your BusinessWhy Hire Python Developers? Key Benefits for Your Business
Why Hire Python Developers? Key Benefits for Your Business
Mypcot Infotech
Why Every Cables and Wires Manufacturer Needs a Cloud-Based ERP Solutions
Why Every Cables and Wires Manufacturer Needs a Cloud-Based ERP SolutionsWhy Every Cables and Wires Manufacturer Needs a Cloud-Based ERP Solutions
Why Every Cables and Wires Manufacturer Needs a Cloud-Based ERP Solutions
Absolute ERP
Computer Architecture Patterson chapter 1 .ppt
Computer Architecture Patterson chapter 1 .pptComputer Architecture Patterson chapter 1 .ppt
Computer Architecture Patterson chapter 1 .ppt
jaysen110
A Brief Introduction About Raman Bhaumik
A Brief Introduction About Raman BhaumikA Brief Introduction About Raman Bhaumik
A Brief Introduction About Raman Bhaumik
Raman Bhaumik
Consequences and Principles of Software Quality v1.0
Consequences and Principles of Software Quality v1.0Consequences and Principles of Software Quality v1.0
Consequences and Principles of Software Quality v1.0
Yann-Ga谷l Gu辿h辿neuc
AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]
AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]
AnyDesk Pro 3.7.0 Crack License Key Free Download 2025 [Latest]
haroonsaeed605
Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...
Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...
Drawing Heighways Dragon - Recursive Function Rewrite - From Imperative Styl...
Philip Schwarz
SketchUp Pro Crack [2025]-Free Download?
SketchUp Pro Crack [2025]-Free Download?SketchUp Pro Crack [2025]-Free Download?
SketchUp Pro Crack [2025]-Free Download?
kiran10101khan
Carousel - Five Key FinTech Trends for 2025
Carousel - Five Key FinTech Trends for 2025Carousel - Five Key FinTech Trends for 2025
Carousel - Five Key FinTech Trends for 2025
Anadea
Adobe InDesign Crack Full Version Free Download 2025
Adobe InDesign Crack  Full Version Free Download 2025Adobe InDesign Crack  Full Version Free Download 2025
Adobe InDesign Crack Full Version Free Download 2025
sannnasaba545
LLM Security - Smart to protect, but too smart to be protected
LLM Security - Smart to protect, but too smart to be protectedLLM Security - Smart to protect, but too smart to be protected
LLM Security - Smart to protect, but too smart to be protected
Ivo Andreev
Online Software Testing Training Institute in Delhi Ncr
Online Software Testing Training Institute in Delhi NcrOnline Software Testing Training Institute in Delhi Ncr
Online Software Testing Training Institute in Delhi Ncr
Home
Data Storytelling for Portfolio Leaders - Webinar
Data Storytelling for Portfolio Leaders - WebinarData Storytelling for Portfolio Leaders - Webinar
Data Storytelling for Portfolio Leaders - Webinar
OnePlan Solutions
Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...
Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...
Mastering Software Test Automation: A Comprehensive Guide for Beginners and E...
Shubham Joshi
Build the future with Agentforce and Mulesoft
Build the future with Agentforce and  MulesoftBuild the future with Agentforce and  Mulesoft
Build the future with Agentforce and Mulesoft
GiulioPicchi
Tenorshare 4uKey Crack Fre e Download
Tenorshare  4uKey  Crack  Fre e DownloadTenorshare  4uKey  Crack  Fre e Download
Tenorshare 4uKey Crack Fre e Download
oyv9tzurtx
Metaverse Meetup: Explore Mulesoft MAC Project
Metaverse Meetup: Explore  Mulesoft MAC ProjectMetaverse Meetup: Explore  Mulesoft MAC Project
Metaverse Meetup: Explore Mulesoft MAC Project
GiulioPicchi
Code or No-Code Tests: Why Top Teams Choose Both
Code or No-Code Tests: Why Top Teams Choose BothCode or No-Code Tests: Why Top Teams Choose Both
Code or No-Code Tests: Why Top Teams Choose Both
Applitools

Lec 1 Database.ppt

  • 2. CODE OF ETHICS All students must come to class on time (Attendance will be taken in first 5 to 10 mins) Students should remain attentive during class and avoid use of Mobile phone, Laptops or any gadgets Respect faculty and staff through actions and speech Class participation is encouraged 2
  • 3. Text Book Primary Database Systems 8E, C.J.Date, Addison Wesley Pub. Co. (2004). Reference Database Systems: A Practical Approach to Design, Implementation and Management 5E, R.Connolly and P.Begg, Addison-Wesley Pub. Co (2009). Fundamentals of Database Systems, 5E, Elmasri and Navathe, Addison-Wesley, ISBN: 0-201-74153-9.
  • 4. Sequence [TodaysAgenda] Content of Lecture Basic Database Concepts (Definitions) Different File Systems Database and its Advantages
  • 5. What is a Database
  • 6. Database Def-1 A database is a shared collection of logically related data that is stored to meet the requirements of different users of an organization.
  • 7. Database Def-2 A database is a self-describing collection of integrated records
  • 8. Database Def-3 A database models a particular real world system in the computer in the form of data
  • 9. The concept of a shared organizational database Accounting Accounts Payable Accounts Receivable Management Control Planning Manufacturing Production Scheduling Marketing Product Development Sales Corporate Database
  • 10. A bit of History Computer initially used for computational/ engineering purposes. Commercial applications introduced File Processing System.
  • 11. Different Files Systems Manual File System Computerized File System Database System
  • 12. Manual File System Way of managing data using: Pen and Paper Data Storage: Record data on paper. File paper away into folders and cabinets. Data Retrieval: Locate paper from cabinets and folders. Retrieve data from paper. Main disadvantages: Data collection increased by time to time and keeping track of data becomes much difficult.
  • 13. Computerized File Processing System A collection of programs that perform services for the end-users such as production of reports
  • 14. Computerized File Processing System Program and Data Interdependence Registration Applications Registration Data Files Registration Examination Applications Examination Data Files Examination Library Applications Library Data Files Library
  • 15. Computerized File Processing System Fine Books Issued Father Name Name Reg_Number Library Grade Semester Class Address Name Reg_Number Examination Class Address Phone Father Name Name Reg_Number Registration Duplication of Data Vulnerable to Inconsistency
  • 16. Database System A database system is a relationship between stored data, a database, users and the hardware or operating system used for the storage.
  • 18. Advantages of Database Persistent Data stored in a database can usually last for a long time Shared Data stored in a database can be simultaneously accessed by multiple programs Interrelated Data stored in a database can be combined to produce new data
  • 19. 19