Make up a scenario from a subject/industry area of your choosing, and invent a single relation that has at least one partial dependency (i.e. one that is in 1NF, but not 2NF). Supply your relation below using the proper notation from class. Explain why the dependency(s) is/are a problem specifically in the scenario you chose. Normalize your relation to 2NF   Do the same thing as you did above, but this time start with a relation that has no partial dependencies, and at least one transitive dependency (2NF but not yet 3NF). Normalize to 3NF.

"Weak entity type" means what? Does it hide something? What's "attribute"?How would an ER chart show sia? Please draw.

Can you define the weak entity type for me? Is there a secret to it? Provide an instance Just what does it mean to specialize in attribute?Where does ia fit into an ER diagram? Provide Illustration or Diagram

i need a own Scenario (not from internet) to create an ERD. which should have atleast three entities and must have many to many relationship. JUST need a scenario statement.

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.…