Entity set or entity type, Database Management System

A collection of a same kind of entities is known as an Entity Set or entity type.

Example:

For the COLLEGE database defines earlier objects of concern are Students, Faculty, Course and departments. The sets of all the students' entities form a entity set STUDENT. Likewise collection of all the courses creates an entity set COURSE.

Entity sets require not be disjoint. For example - an entity may be part of the entity set STUDENT, the entity set FACULTY, and the entity set PERSON.

Posted Date: 3/6/2013 6:00:16 AM | Location : United States







Related Discussions:- Entity set or entity type, Assignment Help, Ask Question on Entity set or entity type, Get Answer, Expert's Help, Entity set or entity type Discussions

Write discussion on Entity set or entity type
Your posts are moderated
Related Questions
Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,

To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

Where does view definition stored? A view definition is permanently stored as part of the database.

Describe briefly models which define the operations on classes. The three models which are used to define operations on classes are as: Object Model = data dictionary + Obje

Objectives differentiate DDBMS and conventional DBMS; Describe Network topology for DDBMS; Describe the concepts of horizontal and vertical fragmentation; Descr

What does the extract statement do in extract datasets? The data is written to virtual memory by extract commands.

what is lossless & dependency preserving decomposition ?

Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact

Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas