In a relational database, a weak entity is an entity that cannot be uniquely identified by its attributes alone; therefore, it must use a foreign key in conjunction with its attributes to create a primary key.
Wikipedia
why do we need weak entity in database when we can make it strong entity?
SpecializationThe process of designating sub groupings with in an entity set is called specialization.Weuse IS A relationship to represent specialization.ISA relationship may also be referred as super class-subclassrelationshipExample: Person IS A EmployeePerson IS A CustomerEmployee IS A ManagerGeneralizationHere the design process take place in bottom up manner.Multipleentity sets are synthesized into a higher level entity set on the basis of common features.Example: Employee and Customer entities can be synthesized into a higher level entity Person.Attribute inheritanceThe attributes of higher level entity set are inherited by lower level entity set.AggregationAggregation is an abstraction in which relationship sets are treated as higher level entity sets. Here a relationship set is embedded inside an entity set, and these entity sets can participate in relationships.
An entity set may not have sufficient attributes to form a primary key is called weak entity set. One with primary key is called strong entity set.
DBMS: Data Base Management Systemgeneralization and specialization are important relationships that exist betweena higher level entity set and one or more lower level entity sets.1. generalization is the result of taking the union of two or more lower level entity sets to produce a higher level entity sets.specialization is the results of taking subsets of a higher level entity set to form a lower level entity sets.2. In generalization,each higher level entity must also be a lower level entity.In specialization,some higher level entities may not have lower-level entity sets at all.3. Specialization is a Top Down process where as Generalization is Bottom Up process.
In a generalization-specialization hierarchy, it must be possible to decide which entities are members of which lower level entity sets. In a conditiondefined design constraint, membership in the lower level entity-sets is evaluated on the basis of whether or not an entity satisfies an explicit condition or predicate.User-defined lower-level entity sets are not constrained by a membership condition; rather, entities are assigned to a given entity set by the database user. Condition-defined constraints alone can be automatically handled by the system. Whenever any tuple is inserted into the database, its membership in the various lower level entity-sets can be automatically decided by evaluating the respective membership predicates. Similarly when a tuple is updated, its membership in the various entity sets can be re-evaluated automatically
Days of the week.
me2
They are sets with a finite number of elements. For example the days of the week, or the 12 months of the year. Modular arithmetic is based on finite sets.
Days of the week underwear.
In an Entity-Relationship (E-R) diagram, an entity set is typically represented by a rectangle. Each rectangle contains the name of the entity set, which corresponds to a collection of similar entities. Attributes of the entities can be depicted as ovals connected to the rectangle, while relationships between different entity sets are shown using diamonds. This visual representation helps in understanding the structure and relationships within a database.
Doing 12 sets of bench press and 12 sets of dumbbell flies in a week may lead to overtraining, especially if recovery and overall volume aren't managed properly. It's essential to balance intensity and volume to avoid injury and ensure proper muscle recovery. A total of 6 sets of each exercise per week might be more appropriate for most individuals, allowing for adequate recovery while still promoting muscle growth. Ultimately, individual goals, training experience, and recovery capacity should guide your decision.
7 Millions