Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
relations create the database they must satisfy various properties like no duplicate tuples no ordering of tuples and atomic attributes etc relations
for every multivalued attribute a we make a new relation r that contains an attribute corresponding to plus the primary key attribute k of the
for every n-ary relationship type r where ngt2 we make a new table s to represent r we contain as foreign key attributes in s the primary keys of the
for each mn relationship type r we make a new table say s to represent r we also contain the primary key attributes of both the participating entity
for each 1 n relationship type r involving two entities e1 and e2 we recognize the entity type say e1 at the n-side of the relationship type r and
one-to-one relationshipfor every 11 relationship type r in the er diagram including two entities e1 and e2 we take one of entities say e1 preferably
conversion of entity setsi for every strong entity type e in the er diagram we make a
using the concepts defined previous we have identified that strong entities in college database are faculty student course and department this
aggregation one limitation of the e-r diagram is that they do not permit representation of relationships between relationships in such a case the
consider the entity type dependent related to employee entity which is used to keep track of the dependents of every employee the attributes of
entity types that do not have any key attribute and therefore cannot be identified independently are known as weak entity types a weak entity can be
the participation constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type
a relationship set is a set of relationships of the similar typefor example let consider the relationship among two entities sets course and student
let us first describe the term relationshipswhat are relationshipsa relationship can be defined as a set of associations or connection or a rule for
attributes that are directly kept in the data basefor example birth date attribute of a person derived attributes that are not stored directly
attributes having a one value for a particular entityfor instance age is a single valued attribute of a student entityattributes that
attributes attached to an entity can be of various typessimplethe attribute that cannot be further separated into smaller parts and shows the basic
every simple attribute of an entity type have a possible set of values that can be attached to it this is known as the domain of an attribute an
an entity type usually has an attribute whose values are distinct for every individual entity in the collection such an attribute is known as a key
a collection of a same kind of entities is known as an entity set or entity typeexamplefor the college database defines earlier objects of concern
entitieslet us first be aware of the questionwhat are entities an entity is an object of concern used to show the things in the actual world eg table
we will explain here an example database application having college database and use it in showing several e-r modelling conceptscollege database
let us first look into some of the important features of er model entity relationship model is a high-level conceptual data model it permits us to
exampleconsider the following relationsrollnonameaddresscourseid100kanupriya234 saraswati viharcs1101rajni bala120 vasant
when every condition appears with equality condition only c natural join denoted by rswhen two join attributes have the similar name in both