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 factors might influence a company to outsource its IT infrascture.

What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

What are called multilevel indices? Indices with two or more levels are known as multilevel indices.

What is B-Tree? A B-tree eliminates the redundant storage of search-key values .It permits search key values to appear only once.

Question 1 Explain the 10 reasons to use MySQL Question 2 Write the SQL statements to demonstrate the following using SELECT command Expression Evaluation ORDER BY

Consider the relations given below Borrower (id_no, name) Book (accno., title, author, borrower_idno) (a) Define the above relations as tables in SQL forming real world assumptio

Explain pipelining.        Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,

Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru


What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs