mysql design

/in /by

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)