Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
WOUND-WAIT
Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples
What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.
Explain Hierarchical Model ? Hierarchical Model - It was established to model several kinds of hierarchical organizations which exist in the real world. It uses tree structur
Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is
Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve
Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep
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
Can a domain, assigned to a data element be changed? Yes. We can do so by just overwriting the entry in the field domain.
Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd