A weak entity set and its identifying relationship, Database Management System

Q. Define a weak entity set and its identifying relationship. List the necessary conditions for a meaningful identifying relationship set of a weak entity set.   

Entity is a thing which can be distinctly identified it then goes on to classify entities into regular entities and weak entities, a weak entity is entity whtity which existence depend on some other  entity in the sense that it cannot exist  if  that other does not exist,  According to figure an employee's dependents might be weak entities they cannot exist if the relevant employee does not exist. Properties: Entities- also relationship have properties. All entities or relationship of a given type have certain kinds of properties in common; for example, all employees have an employee number, a name, a salary and so on. Each kind of property draws its values from a corresponding value set (in other words, a type or domain ). Furthemore properties can be: Simple or Composite: For example, the composite property" employee name" might be made up of the simple properties. "First name", "Middle initial" and "Last name. Key: Unique possibly with some context; for example, a dependent's name might be unique within the context of a given employee. Single or Multi-valued: All properties shown in figure are simple valued but if, for example, a given supplier could have several distinct location, then "supplier city" might be a multivalued property. Missing:Unknown or not applicable as illustrated in figure. Bace or Derived: For example, "total quantity" for a given part might be derived as the sum of the individual shipment quantities for that part. Relationship: Relationship is an association entities. For example, there is a relationship called DEPARTMENT-EMPLOYEE between departments and employees, representing the fact that certain departments are said to be the participants in that relationship. The number of participanrs in a given relationship is called the degree of the relationship. Sol.(b) the genetalization and sdecialization diagram for a given problem is as shown in the figure below At lowest level entities become the subtype or categories to the supertype. Generalization is a form of abstraction that specifies that two or mre entities that share common attributes can be generalezed into higher level entity type called a super type or generic entity. Here in this example the lowest level entities such as motor cycle car vans and buses have several common attributes which can be generalized into the entity type VEHICLE as shown in figure. Generalization process can be viewed as inverse of specialization process. Therefore in figure we can view as a specialization of VEHICLE rather than viewing VEHICLE as a generalization of CAR, VANS, BUSES and MOTOR CYCLE. 

 

Posted Date: 7/11/2012 4:03:28 AM | Location : United States







Related Discussions:- A weak entity set and its identifying relationship, Assignment Help, Ask Question on A weak entity set and its identifying relationship, Get Answer, Expert's Help, A weak entity set and its identifying relationship Discussions

Write discussion on A weak entity set and its identifying relationship
Your posts are moderated
Related Questions
Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

The C_Artist  application will be developed using the C language (C99 standards) and will be able to compile without warnings and link and run in the Swinburne computer laboratorie

Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc

Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

Problem 1. Describe the Oracle Architecture with a neat labeled diagram, Also explain the individual components of the Architecture. 2. Write about the following Oracle 9i o