Question

Database designers must often make design compromises that are triggered by conflicting goals. Describe these challenges...

Database designers must often make design compromises that are triggered by conflicting goals. Describe these challenges and how the effect the database development process. Cite real life applications.

Homework Answers

Answer #1

Database designers often must make design compromises that are triggered by conflicting goals, such as adherence to design standards (design elegance), processing speed, and information requirements.

Design standards

The database design must conform to design standards. Such standards have guides in developing logical structures that minimize data redundancies, thereby minimizing the likelihood that destructive data anomalies will occur. These standards prescribe avoiding nulls to the greatest extent possible. In short, design standards allow you to work with well-defined components and to evaluate the interaction of those components with some precision. Without design standards, it is nearly impossible to formulate a proper design process, to evaluate an existing design, or to trace the likely logical impact of changes in design.

Processing speed

In many organizations, particularly those generating large numbers of transactions, high processing speeds are often a top priority in database design. High processing speed means minimal access time, which may be achieved by minimizing the number and complexity of logically desirable relationships. For example, a “perfect” design might use a 1:1 relationship to avoid nulls, while a higher transaction-speed design might combine the two tables to avoid the use of an additional relationship, using dummy entries to avoid the nulls. If the focus is on data-retrieval speed, it might also be forced to include derived attributes in the design.

Information requirements

The quest for timely information might be the focus of database design. Complex information requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. Therefore, the database may have to sacrifice some of its “clean” design structures and/or some of its high transaction speed to ensure maximum information generation.A design that meets all logical requirements and design conventions is an important goal.

Example

1.Order management system database.

2. Government Organizations

Government organizations around the world are constantly collecting data for research, defense, legislation, and humanitarianism purposes, to name a few. This data is collected, stored and analyzed using powerful and far-reaching database services.

3.Social Media

Every social media platform stores reams of user information in databases used to recommend friends, businesses, products, and topics to the end user. This cross-referencing of data is immensely complex and uses highly reliable and capable database software. For example, MySQL is used in Facebook data centers.

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
Database Management and Design Homework assignment Directions: Create an ERD for the following case. Make sure...
Database Management and Design Homework assignment Directions: Create an ERD for the following case. Make sure you use the proper cardinalities. Sweeping Bulldog (SB) is an online textbook exchange portal. It allows an individual or customer (student, faculty, staff, etc.) to sell their used textbooks directly to other people without going through the formal UTC book store. The portal allows the individual to drop off their books anytime, most probably at the end of one semester. The individual then receives...
Organizing Organizing is an important task of managers. Once the organization’s goals and plans are in...
Organizing Organizing is an important task of managers. Once the organization’s goals and plans are in place, the organizing function sets in motion the process of seeing that those goals and plans are pursued. When managers organize, they’re defining what work needs to get done and creating a structure that enables work activities to be completed efficiently and effectively by organizational members hired to do that work. As Starbucks continues its global expansion and pursues innovative strategic initiatives, managers must...
This assignment challenges students to formulate a professional response to in-depth issues contained in a real-life...
This assignment challenges students to formulate a professional response to in-depth issues contained in a real-life Video Business Case. Students will act as an independent professional business consultant reporting to senior managers of the company concerned. Students are expected to provide informed and robust advice to this business client. The video below is provided by Ernst and Young company. It refers to the issues faced by an organisation in the Maritime Safety Industry. Ernst and Young is required to solve...
urgent please provide 3 multiple choice questions with correct answers. Since the early days of Google,...
urgent please provide 3 multiple choice questions with correct answers. Since the early days of Google, people throughout the company have ques- tioned the value of managers. That skepticism stems from a highly techno- cratic culture. As one software engineer, Eric Flatt, puts it, “We are a company built by engi- neers for engineers.” And most engineers, not just those at Google, want to spend their time designing and debugging, not communicating with bosses or supervising other workers’ progress. In...
The Business Case for Agility “The battle is not always to the strongest, nor the race...
The Business Case for Agility “The battle is not always to the strongest, nor the race to the swiftest, but that’s the way to bet ’em!”  —C. Morgan Cofer In This Chapter This chapter discusses the business case for Agility, presenting six benefits for teams and the enterprise. It also describes a financial model that shows why incremental development works. Takeaways Agility is not just about the team. There are product-management, project-management, and technical issues beyond the team’s control. Lean-Agile provides...
Item 1 In the case below, the original source material is given along with a sample...
Item 1 In the case below, the original source material is given along with a sample of student work. Determine the type of plagiarism by clicking the appropriate radio button. Original Source Material Student Version I accept the point that whenever learning occurs, some medium or mix of media must be present to deliver instruction. However, if learning occurs as a result of exposure to any media, the learning is caused by the instructional method embedded in the media presentation....
LEADERSHIP IMPLICATIONS IN COMPLEX PROJECTS: THE BOEING DREAMLINER AND CEO JIM MCNERNEY In defense of criticism...
LEADERSHIP IMPLICATIONS IN COMPLEX PROJECTS: THE BOEING DREAMLINER AND CEO JIM MCNERNEY In defense of criticism of Boeing’s 787 production delays, CEO Jim McNerney explained: We are trying to come up with the strongest set of partnerships we can with the people that supply our major systems and structures. In defense, we are trying to respond to the pressures of governments buying fewer things at lower prices, with less favorable contract terms. And that pressure cannot just stop at Boeing....
Plagiarism Certification Tests for Undergraduate College Students and Advanced High School Students These tests are intended...
Plagiarism Certification Tests for Undergraduate College Students and Advanced High School Students These tests are intended for undergraduate students in college or those under 18 years of age. Read these directions carefully! The below test includes 10 questions, randomly selected from a large inventory. Most questions will be different each time you take the test, You must answer at least 9 out of 10 questions correctly to receive your Certificate. You have 40 minutes to complete each test, and you...
________ 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...
This case assignment draws from the Business Information Systems and the Systems Acquisition and Development modules...
This case assignment draws from the Business Information Systems and the Systems Acquisition and Development modules (Chapters 5 to 8). Its purpose is to provide you with experience in analyzing organizational information systems, making recommendations to improve these systems, and formulating a plan to execute on your recommendations. 1. Recommend one of your alternatives that is the best solution to the main issue and justify your recommendation. Your justification should be based on the key decision criteria and you must...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT