Question

reflect on some potential problems a database designer may encounter when trying to construct an ERD.

reflect on some potential problems a database designer may encounter when trying to construct an ERD.

Homework Answers

Answer #1

Some of the potential problems faced by the database designer would be:

(1) Debugging database will hard as it will require a lot of complex SQL commands to understand where the error is, a visualization tool for the database would help out in such a case.

(2) There are no proper notions for entity and relationship set, This ambiguity will itself lead to a set of other problems during database design, such as Use of Entity set vs attributes, Use of Entity sets vs relationship sets..etc. This ambiguity also leads to problems such as different traps (Fan Traps: Many relationships from a single entity, Chasm Traps: due to relationships with partial participation..etc).

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
What could be some potential problems when developing written job descriptions for call centre employees?
What could be some potential problems when developing written job descriptions for call centre employees?
A supplier that tells a potential buyer about its financial problems may accelerate its own demise....
A supplier that tells a potential buyer about its financial problems may accelerate its own demise. Potential buyers will shy away from the supplier while existing buyers will begin to qualify new sources. While our parents told us that honesty is the best policy, it is a policy that is sometimes buried deep in the back of a supplier's playbook. It is not that the supplier's personnel are inherently bad or dishonest. They are simply practicing self-preservation. What are some...
Now that suggestions on potential types of databases are considered, Park University wants to now understand...
Now that suggestions on potential types of databases are considered, Park University wants to now understand more on suggestions you may have designed/planning a model for the payroll database. Park University has requested information and has asked you to address the following questions and would really like to see a sketched draft of the logical model: When thinking about various stages of modeling for this payroll database, why is it important to go through three phases of modeling including the...
While the ancient world may seem remote and quite divorced from the problems of the present,...
While the ancient world may seem remote and quite divorced from the problems of the present, the study of ancient humanities can help us make sense of the world as it is today. The nature and impact of various cultural and religious developments, the responses of societies to complex social and economic challenges, the issues of justice, discrimination and violence were as much part of the ancient world as they are of our world today. Is it by morality, or...
Reflect back on your draft. Reread it. Analyze it. What are the strengths of your draft?...
Reflect back on your draft. Reread it. Analyze it. What are the strengths of your draft? What areas will need improvement? The Treatment of Special Needs Children Abstract            Special needs children are still on the receiving end of abuse despite the increased clamor against their mistreatment. Also, they are likely to face discrimination and abuse in their homes and their social spheres; they have limited opportunities for quality education and can find trouble getting adequate medical assistance. The management of...
read Seasons of Love chapter:measuring a child's life after suicide. please answer the questions : reflect...
read Seasons of Love chapter:measuring a child's life after suicide. please answer the questions : reflect on what happens to the families when there is a suicide in the family, based on the Seasons of Love chapter...how should people be told? What details are best left unshared? below is the story These theories may have a certain face-validity, but they often neglect environmental or contextual factors that are innate to answering the question of “why” a person might engage in...
________ client-centered therapy centers on the patient's goals and ways of solving problems. Select one: a....
________ client-centered therapy centers on the patient's goals and ways of solving problems. Select one: a. Rogers' b. Freud's c. Beck d. Ellis Question 2 Not yet answered Points out of 1.00 Flag question Question text A frequently prescribed drug therapy for managing one's depression is ____________. Select one: a. Adderall b. Lithium c. Prozac d. Thorazine Question 3 Not yet answered Points out of 1.00 Flag question Question text A major goal of modern inpatient psychiatric treatment is: Select...
Assignment: What are the main arguments in the article? Please answer within 5 hours. It is...
Assignment: What are the main arguments in the article? Please answer within 5 hours. It is extremely urgent!!!!!!!!!!!!!!!!!!!!!!!! --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- BIOETHICS. Bioethics as a field is relatively new, emerging only in the late 1960s, though many of the questions it addresses are as old as medicine itself. When Hippocrates wrote his now famous dictum Primum non nocere (First, do no harm), he was grappling with one of the core issues still facing human medicine, namely, the role and duty of the...
What topics are covered in the following article? Please answer within 5 hours. It is extremely...
What topics are covered in the following article? Please answer within 5 hours. It is extremely urgent!!!!!!!!!!!!!!!!!!!!!!!! --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- BIOETHICS. Bioethics as a field is relatively new, emerging only in the late 1960s, though many of the questions it addresses are as old as medicine itself. When Hippocrates wrote his now famous dictum Primum non nocere (First, do no harm), he was grappling with one of the core issues still facing human medicine, namely, the role and duty of the physician....
Mattel Responds to Ethical Challenges Business Ethics This case was written by Debbie Thorne, John Fraedrich,...
Mattel Responds to Ethical Challenges Business Ethics This case was written by Debbie Thorne, John Fraedrich, O. C. Ferrell, and Jennifer Jackson, with the editorial assistance of Jennifer Sawayda. This case was developed for classroom discussion rather than to illustrate either effective or ineffective handling of an administrative, ethical, or legal discussion by management. All sources used for this case were obtained through publicly available material. Mattel, Inc. is a world leader in the design, manufacture, and marketing of family...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT