1 / 26

Data base System Concepts & Data Modeling

Explore concepts of data modeling, file systems, and database management systems (DBMS). Learn about data redundancy, abstraction levels, DBMS languages (DDL and DML), user roles, functions of a DBA, and system architectures.

lkennerson
Download Presentation

Data base System Concepts & Data Modeling

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. Data base System Concepts & Data Modeling Chapter 1

  2. Data

  3. File Systems

  4. Data Base Management System • DBMS is a collection of interrelated data and set of programs to access those data.

  5. Various Data Base Mgt Systems

  6. Disadvantages of File Systems • Data Redundancy and Inconsistency • Data Isolation • Integrity Problems • No Transaction support • No data sharing • Security Problems

  7. Front End

  8. Back End

  9. Data Abstraction

  10. Data Abstraction(Physical Level)

  11. Data Abstraction(Logical Level)

  12. Data Abstraction(View Level)

  13. Instance • Data base changes over time as information is deleted and inserted.The collection of information stored in the database at a particular moment is called an Instance of Database. • Insert into student values(1,’misha’,99)

  14. Schema • The overall design of the database is called as the database schema.

  15. Schema

  16. Database Languages SQL DDL DML CREATE INSERT DELETE DROP ALTER UPDATE SELECT TRUNCATE RENAME

  17. Data Defination Language • Create Table • Alter Table • Truncate • Rename table • Drop table

  18. Data Manipulation Language • Insert • Select • Update • Delete

  19. DataBASE USER’S • Application Programmer’s

  20. Naïve User’s

  21. Sophisticated User’s

  22. Specialized User’s

  23. Functions of DBA • Schema Definition • Storage Structure and access method definition • Granting of Authorization for data access • Routine Maintenance. • Performance Tuning

  24. Two Tier Architecture

  25. Three Tier Architecture

  26. Non Client Server

More Related