mysql-design

you need change or make it correction section 3, 4, and 5 from my docs format file(attached file). you can see example from attached pdf file. draw detail ERD with hierarchy in section7

Website: https://www.biographyonline.net/people.html

SECTION 3: REQUIREMENTS (0.5 points)

• Be sure you have a statement for each entity describing the attributes that the entity must have from the customer perspective. (0.25 total)
  • An entity instance of E1 is in relation R with (zero or one, exactly one, zero or more, one or more) entity instances of E2
  • An entity instance of E2 is in relation R with (zero or one, exactly one, zero or more, one or more) entity instances of

Be sure you have two statements for each relationship: E1 R E2 (0.25 points)

SECTION 4: ENTITIES (0.25 points)

• You must include a list of entities (including bridge entities)
• If the name is not self evident include in parentheses an explanation
• Be sure the names are singular, noun phrases and they follow the same conventions
• You must have between 8-10 entities

SECTION 5: RELATIONSHIPS (0.25 points)

• You must include a list of relationships, in the format ENTITY 1 NAME relationship name ENTITY 2 NAME
• If the name is not self evident include in parentheses an explanation
• Be sure the names of the relationships are third person verb phrases and they follow the same conventions
• You must have between 8-10 relationships
• All the entities used for relationships must have the same name as those in section 4

SECTION 7: DETAILED ERD (1.75 points)

• Starts on a new page.
• The ERD must be done using an approved design software (e.g. MySQL Workbench)
• You must include a picture (or more) of the design in the document. Be sure it is big enough so all text is clearly readable.
• Attach also the source file for your design.

Please be sure your diagram includes:

• ENTITIES (0.75 points)
  • Entity name (follow conventions, relevant) 0.25 points
  • Attributes 0.25 points
  • Constraints (PK, UQ, NN) 0.25 points
• RELATIONSHIPS (1 point)
  • Relationship names (0.2 points)
  • Relationship types (0.2 points)
  • Relationship strength (0.2 points)
  • Relationship participation for each entity (0.2 points)
  • FK in the child entity (0.2 points)