Question

I have "schedule" (guest, volunteer etc) and "Inventory" (food,bedding,cleaning stuff etc inventory)as an entity so what could be attributes to these two entities? And also give partial and transitive dependencies between the attributes in normalization process? please hurry

Answer 1

DEFINITION:

1. Functional Dependency : Functional dependency is a relationship that exists when our attribute uniquely determines another attribute.
2. Non Prime Attributes : A non prime attribute is an attribute that does not belong to any Candidate Key.
3. Candidate Key : A Candidate key is a column or a set of columns in a table that can uniquely identify any database record without refering to any other data. Each table have one or more Candidate key.

PARTIAL DEPENDENCY:

Partial Dependency is one kind of functional dependency when non prime attributes is functionally dependent on a part of the Candidate key.

TRANSITIVE DEPENDENCY:

It always relate to the attribute outside the Candidate key. When an indirect relationship causes functional dependency it is called Transitive Dependency.

schedule attributes:

for each schedule we would be having a N no of guest and M no of volunteer. A schedule would be having a date, time and location as a attribute.

inventory attributes;

for each event we would require some basic amenity like living space for each guest and volunteers, that include food for each, cleaning stuff, no of bathroom allotted to a group of people,

Partial dependency:(scheduler)

when attributes inside entity are functionally dependent, hence we can say that no of volunteers would be functionally dependent upon the no of guest, hence partial dependency.

(inventory)

No of guest and volunteers would determine the bedding, cleaning stuff and a group of people would determine the no of bathrooms hence partial dependency.

Transitive dependencies:

We can say that a date and time employs guests(as every schedule would be having guest list) and guests would employ volunteer(volunteers required is proportional to guest) hence date and time is a transitive dependency on volunteers.

(inventory):

guest and volunteers employs we need bathroom and bathroom employs we need cleaning stuff. hence guest and volunteers is a transitive dependency upon cleaning stuff.

remember that :

if we allote 5 people to one bathroom we need one cleaning kit but if we have 8 people we need 2 cleaning kit.

HOPE THAT IT HELPS