looking for someone with experience with ER models and powerdesigner
Task 1: Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities containing simple valued attributes, identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. All composite and multivalued attributes should be converted to entities.
Task 2: Based on the ER diagram from Task 1, you are expected to apply generalization/specialization technique to generate an Enhanced-ER (EER) diagram. The EER diagram should specify the completeness and disjointness constraints on the generalization/specialization.
Task 3: You are expected to convert the EER diagram from Task 2 to a logical data model in the third normal form. The logical data model should include relations, fields, primary and foreign keys.
Task 4: You are expected to convert the logical data model from Task 3 to a physical data model. You can make reasonable assumptions about the types of the attributes in the model.
Task 5: You are expected to list the tables which can be indexed from the physical data model and justify your answer.
5 freelance font une offre moyenne de $201 pour ce travail
I have been doing this for the last 20 years. I can get this done quick with the best quality. This can be done pretty quick. Would like to hear more from you. You can also look me up on linkedin