AfterAcademy Tech
In this blog, we will learn about the types of network based on design, that are Peer-to-Peer, and Server-Based networks. We will also see the applications, advantages, and disadvantages of using these networks.
In this blog, we will learn what are unique keys and what is the need for unique keys. We will also discuss various points on which the unique key differ from a primary key.
In this blog, we will learn about the various keys like the super key, candidate key, primary key, alternate key and foreign key. We will discuss how to identify and differentiate between them with examples.
In this blog, we will learn about the various classification of networks based on their geographical area, media used, ownership, and functionality.
In this blog, we will learn what is an attribute, its various types and symbols used to represent them. We will see various types of attributes such as single & multi-valued attributes, simple & composite attribute, stored & derived attribute and key attribute.
In this blog, we will learn about the degree of relationship in DBMS. We will also see what are its types depending upon various degree possible and discuss what is the maximum and minimum degree possible in relation.
In this blog, we will study various types of relationships in DBMS which help in defining the association between various entities. Also, we will discuss the types of participation constraints which may exist between the relationship and the entity type.
In this blog, we will see the difference between a strong and a weak entity. We will also see various terms which are used to describe a strong and weak entity with the help of in-depth examples.
In this blog, we will learn what is an entity, entity type and entity set and how these terms are related. We will learn the difference between these terms as these terms are often used interchangeably. We will take various examples to understand this.
In this blog, we will see how an ER model is used in database designing. We will also see how an ER model is made using various components of the ER diagram. We will also discuss the features of an ER model along with its advantages and disadvantages.
