Explain how functional dependencies may be used to indicate: • The entity sets student and teacher have a one-to-one relationship set. • Between entity setsstudent and teacher, there is a many-to-one connection set.

LOGICAL DATABASE DESIGN The above EER-Diagram represents a University Library Membership (see Diagram 5). A member can borrow as many books from the library. Derive relations for logical model from the above EER-Diagram. Please identify any primary key or foreign key in the derive relations (if applicable).

PART 1The goal of this assignment is to design a conceptual schema using the (E)ER Data model.(E)ER data modelDesign a schema that incorporates the specification described below as efficiently as possible.You should submit a written diagram of your schema design using the notation given in theclass. In this diagram, indicate all the classes, subclasses, relationships (weak & strong),relationship cardinalities and degrees, total participations, attributes, and primary keys. Inaddition, specify whether each attribute is single-valued or multi-valued, stored or derived, andatomic or composite. In your design, you can make and state reasonable assumptions if they arenot specified in the specification.Design SpecificationYelp is a local business directory service and review site with social networking features. Itallows users to give ratings and review businesses. You are going to design the database systemfor Yelp (www.yelp.com). It should store and manage the following information but…

2) A relation schema R is defined tot be in 2NF if every nonprime attribute of R is blank the primary key of R.A) transitively dependent on B) fully functionally dependent onC) a candidate key of D) partially functionally dependent onE) part of

Is it true that associated entities are also weak? Why do you think that is? Is there anything unique about their "weakness" if this is the case?

What is the difference between a recurring group and an attribute that may take on many values?

Relationships in a use case diagram are a powerful mechanism to organize and reuse requirements. There are three main types of relationships in use case diagrams:1.Actor to actor—This is the generalization relationship and represented by the inheritance arrow in Figure 6.1. This relationship was also discussed in the previous chapter (notably Figure 5.3).2.Actor to use case—The relationship between an actor and a use case is called an association, also occasionally called "communication" because it represents a communication between the actor and the system. This association is represented by a straight line in Figure 6.1. The association is an interface through which an actor interacts with the system. Occasionally, an association line may have an arrowhead (not shown in Figure 6.1), representing the actor initiating the use case. This direction on the association relationship is only shown if absolutely necessary.3.Use case to use case—There are three specific relationships permitted…

Explain how functional dependencies can be used to indicate the following: A one-to-one relationship set exists between entity sets student and Instructor. A many-to-one relationship set exists between entity sets student and instructor.

Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information.   Remember the ERD will eventually turn into the design for a database from a top down view.  Make sure you resolve any many to many conflicts.  Label an identifier or primary key and all pertinent attributes given.   If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity.  Therefore, all entities should end up with at least an identifier and another attribute that makes sense.  You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common.  Make sure you show entities, relationships, cardinality, and optionality.  Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons.  Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…

Question 3Discuss in detailed explanation that the concept that an attribute that is part of a composite primary key is also a candidatekey.