Write some Software
$30-250 AUD
Paiement à la livraison
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.
Nº du projet : #8466061
À propos du projet
Décerné à:
Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here Plus
5 freelances font une offre moyenne de 201 $ pour ce travail
Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation
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