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
What is schema

List some security violations (or) name any forms of malicious access. A) Unauthorized reading of data B) Unauthorized modification of data C) Unauthorized destruction of

Illustrate about the advanced object design Advanced object design is a complex task. The objects discovered through analysis serve as a skeleton of design. The operations reco

What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information system used in manuf

Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

Part: Recommended (Non-query) Optimisations This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....