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

Assignment #1 Data Management The questions on this exam are based on the Baxter Aviation case scenario. 1. (5 points) The systems analyst proposes the following two relationshi

Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager

Problem: ‘Users and Information system specialists need to spend inordinate amounts of time locating and gathering data' (Watson and Hal, 1998) Recent developments in the ar

It defines that no primary key value can be null. This is as the primary key is used to recognize individual tuple in the relation. So we will not be able to recognize the records

In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies.  Determine the normal form of this table.  Remember that the normal form is the HIGHE

What are the advantages of by using an index and what are its disadvantages ? In difference, if the search key of a secondary index is not a candidate key, it is not sufficient

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg

What is meant by data-transfer rate? The data-transfer rate is the rate at which data can be retrieved from or kept to the disk.

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and