Relationship in DBMS
Relationship in DBMS Relationship The association among entities is called a relationship. example, the relationship between an employee and a department is works_at . example , relationship enrolls is used in student and course. Relationship Set A set of relationships of a similar type is called a relationship set. These attributes are also called …
Read more
Attributes in DBMS
Attributes in DBMS Attributes · properties of entities are called attributes . · All attributes are store domain or range of values. example, students' name store alphabetic values, and students' age store positive integer or numeric values, etc. · Example, in student entity attributes are name, class, and age. · …
Read more
Entity in DBMS
Entity in DBMS Entity Entities are objects/concepts /nouns, e.g. customer , supervisor , location , or promotion . An entity represents real-world objects which are easily identifiable . Example:- in a school database, students , teachers , classes, and courses are entities. All these entities have some attributes or properties for identity . Entiti…
Read more
User Interfaces in DBMS
User Interfaces in DBMS · An interface that is a user uses to access data from a database. · There are various user-interfaces provided by a DBMS are: Menu-Based Interfaces for Web Clients or Browsing – Forms-Based Interfaces Graphical User Interfaces Interfaces for the DBA Natural Languages Interfaces Interfaces for Parametric Users ( …
Read more
Database Language in DBMS
Database Language in DBMS A DBMS is software that used appropriate languages and interfaces to express database queries and updates. Database languages are used to read, store and update the data in the database. Types of Database Language 1. Data Definition Language (DDL) Used to define database structure, skeleton, or patter…
Read more
Social Plugin