Database programming

Questions

 1. Discuss the importance of data models.

 2. What is a business rule, and what is its purpose in data modeling?  

  3. What languages emerged to standardize the basic network data model, and why was such standardization important to users and designers?

   4. Describe the basic features of the relational data model and discuss their importance to the end user and the designer.

  5. Explain how the entity-relationship (ER) model helped produce a more structured relational database design environment.

   6.Consider the scenario described by the statement “A customer can make many payments, but each payment is made by only one customer.” Use this scenario as the basis for an entity relationship diagram (ERD) representation.   

 7. Why is an object said to have greater semantic content than an entity?     

   8. What is the difference between an object and a class in the object-oriented data model (OODM)?

    9. How would you model Question 7 with an OODM? (Use Figure 2.4 as your guide.)

10. Describe the relationships (identify the business rules) depicted in the Crow’s Foot ERD shown in Figure P2.13.

Get answers Now

      

        

          

            

        

        

Company analysis

Tools and techniques for managing data

You have explored many options for managing data as well as its importance to the overall health of an organization in making well-informed decisions. Many organizations feel that they have to utilize powerful and expensive solutions, but there are also cheaper alternatives. For example, MS Excel can be a great tool to manage data and identify answers to any questions. Thus, whether your organization is big or small, all the tools need to be evaluated to determine the one that will work best, not only in managing the data but also in lowering the overall cost. Managing cost is important, as you do not want to implement a solution that will bankrupt the organization; that, in itself, is an ill-informed decision.Using the Internet, research tools and techniques of managing data.

Respond to the following:

What would be some of the mistakes or consequences of not investigating the costs associated with the organization’s information systems (data collection) choice? Besides going bankrupt, what other effects could it have on the organization? Could it lead to bad decision making? Explain.
What systems does your organization utilize, either as a whole or per department? Is this solution effective? Why or why not? Is there a solution that would be more effective? If not, explain why.
With the various solutions available today, which one do you think would work best for you? Meaning, which of these solutions (such as MS Excel or a decision-support system) would work best on the following criteria:
Ease of use
Interpretation of data
Sharing of data
Often, we think of business analytics as only for businesses. However, can any of these tools be used for personal decision making? Provide some examples of how you could utilize these tools.

Write your initial response in 300–500 words. Apply APA standards to citation of sources.

Get solution at a 30% discount