Data base System Concepts & Data Modeling

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