Posts

Enhanced-ER (EER) Model Concepts: Specialization and Generalization

Image
  EER is the high-level data model that incorporates the extensions to the ER Model. It is the diagrammatic technique to display the following concepts: Subclass and Superclass Specialization and Generalization Union and Category Aggregation Generalization It works on the principle of a bottom-up approach. In Generalization, lower-level functions are combined to form higher-level function which is called entities. This process is repeated further to make advanced-level entities. In the Generalization, process properties are drawn from particular entities and thus we can create the generalized entity. We can summarize the Generalization process as it combines subclasses to form a superclass. Example of Generalization – Consider two entities Student and Patient. These two entities will have some characteristics of their own. For example, the Student entity will have Roll_No, Name, and Mob_No while the patient will have PID, Name, and Mob_No characteristics. Now in this example Name a...

DBMS Architecture

Image
DBMS design depends upon its architecture. Basic client-server architecture is used to deal with a large number of PCs, web servers, database servers, and other components connected with the network. The client-server architecture consists of many PCs and a workstation which are connected via the network. DBMS architecture depends upon how users are connected to the database to get their requests done. Type of DBMS Architecture :  1-Tier Architecture In this architecture, the database is directly available to the user. It means users directly sit on the Database and use it. Any changes done to the database are directly reflected in the database itself. It doesn't provide any handy tool for the user to interact with the database. The 1-tier architecture is used for the development of local applications where programmers directly communicate with the database quick response. 2-Tier Architecture The two-tier architecture is the basic client-server architecture. In two-tier architectur...