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.
Read moreZero-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.
Read moreFree-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.
Read morePrivacy 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.
Read moreFair-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.
Read more