What is Entity relationship model(E-R model)[DBMS-1]

-

Entity relationship model(E-R model)

-Entity relationship model consists of the entities and relationship.
-It was developed to facility database designed by allowing specification of the enterprise schema.
-the enterprise schema consists of the overall logical structure of the database.
-The E-R model is very useful  in mapping the meaning integration of the recall world enterprise on the conceptual schema.
-The E-R data model is three basic option :
       _Entity set
       _relationship set
       _Attributes  
-It is use for the conceptual design of the database application.

Entity: 

An object which has a some physical existence is called entity.

Relationship:

A relationship is a associate among several entity.

Entity set are relationship set

Entity set:

-A group of similar types of entities is called is called entity sets.
-Let T be a entity set e1,e2,e3..........en.
  e1,e2,e3,,,,,,,,en are the same types of entity.
-Or a entity set is a set of entity of the same type that can share the some properties.
-The individual entity constitute a set are said to be the extension of the entity set.
-ex the set of all the persons who are customer at given bank that can define as extension of the entity set customer.
-All individual bank customer are the extension of the entity set customer.
-The entity set does not need disjoint .
                                                      (Entity set of customer and loan)

Relationship sets:

-A relationship is a associate among several entity.
-A group of relationship is known as relationship sets.
-ex a relationship that associate customer with the loan L17 and this is specific relationship that is  customer with loan L17.
-We can have more than one relationship that can be define the overall same entity.
-A relationship set is a set of relationship of the same type.
-Formally it is mathematically origination no N>2 entity set.
-It is a entity set e1,e2,e3........en
  than the relationship R is a subset of e1,e2,e3.....en.

Attributes:

-Properties or characteristics of the entity is called attributes. 
 attributes are the descriptive properties 
 proceed by the each member of the entity set.
-ex the possible attributes of the customer entity are the customer id ,customer city ,loan.
-there are the 4 types of attribute:
                                                     -single value and multi value attributes
                                                     -simple and composite attributes 
                                                     -derived attributes
                                                     -null attributes 

Comments

Post a Comment

Popular posts from this blog

What is queries in SQL[DBMS-6]

-
Queries in SQL Data types character: -This types of data types store the characters string in fixed length. -The size in brackets determine the no of characters the shell can hold. -character data types is 255 characters. var character(size)/var char 2 (size): -This character is used to store variable length alpha numeric data. -Var char is 2000 character. date: -Date data type is used to represent to the data / time. -The standard. format is dd/mm/yy. Number: -The number data type is used to store number no of any magnitude may be stored up to 38 bit.  
Read more

Draw process state diagram and explain each state(OS-3)

-
Image
-Process state means current activity of process. -When process is execute it changes the state generally state of process is determine by the current activity of process. -Each process may be in one of the following state. new- the process is being is oriented. ready- the process is waiting to be assigned to the processor. waiting - the process is waiting for some event (I/O operation) to occur. running - the process is being executed.  terminated -the process as finished the execution. process state diagram: -The pictorial is represented to the process changing from one process to another process during       there  execution is known as process state diagram. -A process can be change for one process in the following manner. new ready: The operating system(os) create a process and prepares the process to be executed ,then the os moved the process into the ready queue.  ready running: When it is time to select a pro...
Read more

What is demand paging(OS-9)

-
Image
Demand paging -Loading the entire program in the physical memory at program execution time is not so good because the user does not need the entire program in memory at a time. -An alternative strategy is to load pages only as they are need this technique is known as demand paging. -With demand paging virtual memory, pages are only loaded when they are demanded during program execution pages that are never accessed thus never loaded into physical memory.    -A demand paging system is a similar to paging system with swapping, -But here it uses a lazy swap where it never swap a pages into memory unless that page will be need. -In demand paging pager is more suitable than swap er. 
Read more