The Materials include below
Purpose of Database
Systems:There are some drawback that have fetch:
- Redundant and inconsistent data.
- difficult to access data.
- integrity problem.
Levels of abstraction have 3 levels physical level,logical view and view level.In physical
level that describe how to record store.Logical level describes how trelationmongdata.
View level that have application that hide the data type information.
View of Data:In this section we describes how to relation between physical level components that is application , physical level and logical levels.
Data Models:It is collection of the data,data relationship,data schematics,data constraints.There are different models are used as ER models and relation models.
ER models describes using entity and relation between entity.It is widely used for database design.There are used entity relation is deposit,borrow,and etc.There are use entity as customer,account,user and etc.
Relation models there is used two different entity are related each other.For example there is city have some proper prefix of account number that is used.
Data Definition Language:Specification of notation that define database schemas.DDL is generate a table for database dictionary.It is used for store metadata,usually have data definition language.
Data Manipulation
Language:It is define for access and manipulate data from database. There is two type of language used procedure and nonproducer.SQL is most widely used.
For more information click below for download.
For more information click below for download.