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)

Our guarantees

Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Get your paper done by an expert