What is an associative entity

Assignment Help Management Information Sys
Reference no: EM132042828

Please answer each question with 250 min words for each.

1. What is an associative entity? When must a many-to-many relationship be modelled as an associative entity? Provide some examples demonstrate this issue.

2. Draw an ERD for an eyeglass store database with the following information:

a. Customers have prescriptions from eye doctors.

b. Customers buy frames that come from manufacturers

c. Customers are helped by a staff member

3. Draw seven E-R diagrams for seven different types of relationships as follows:

a. One to one relationship

b. One to many relationship

c. One to one or many relationship

d. One to one or zero relationship

e. One or many to one or many relationship

f. Many to many relationship

g. Zero or one to many relationship

In each E-R diagram, write two sentences (a) as you read from left to right and (b) as you read from right to left.

Reference no: EM132042828

Questions Cloud

What periodic interest payment does watson make : The bonds have a 9% coupon rate and interest is paid semiannually. The bonds were sold to yield 10%. What periodic interest payment does Watson make
What is the value of gt equity : There are two firms, Beautiful Widgets (BW) and Glamorous Thingamajigs (GT). Each has expected Net Operating Income (NOI) of $5 million each year forever.
How much of this is biblical and cultural : What do you think of when you use the word church and how much of this is biblical and cultural?
How should mach co account for the debt instrument : On 1 January 2011 mach Co purchases a debt instrument for its value of 1,000 shs. How should mach Co. account for the debt instrument over its five year term
What is an associative entity : What is an associative entity? When must a many-to-many relationship be modelled as an associative entity?
Bullets notes with a summary of the plot : QUESTIONS: What are the common traits attributed to Italians in Black Hand and Skyscrapers?
What equal amount will make her offer package equivalent : What equal amount will make her offer package equivalent to the studio's bonus. Use an interest rate of 4%.
Calculate the total year net cash flow : Jefferson Corporation is purchasing equipment with a 10-year life which will increase revenue by $38,000 per year and increase expenses by $21,000 per year.
Comparing the firm performance relative to its competitors : How does this calculation compare with a ratio analysis comparing the firm’s performance relative to its competitors?

Reviews

Write a Review

Management Information Sys Questions & Answers

  Why is it important to install memory sticks in pairs

Build a computer using a list of unique specifications and troubleshoot any problems that may come up during the building process.

  Discuss your rationale for choosing the specific firewall

From the first e-Activity, discuss your rationale for choosing the specific firewall in question, and determine the primary way in which a company could incorporate it into an enterprise network in order to enhance security.

  Explain the benefits of creating a cmio position

Develop a job description for the Chief Medical Information Officer (CMIO) position.Explain the benefits of creating a CMIO position.

  Describe three reasons users are still frustrated

Describe methods for determining if user frustration is caused by poor system design or from the natural frustration associated with learning a new software.

  Analyze the means in which data moves within organization

Analyze the means in which data moves within the organization and identify techniques that may be used to provide transmission security safeguards.

  Why is it necessary to strengthen the relationship

Why is it necessary to strengthen the relationship between business strategy and IT strategy? Give three examples of organizations that are successful because of such a strong relationship.

  What are your thoughts about conducting therapy

What are your thoughts about conducting therapy via the internet, How would you approach a student who either tried to friend you on Facebook, text with you or wanted to tweet with you on Twitter

  The theory of constraints and the supply chainin 1000 words

the theory of constraints and the supply chainin 1000 words explain how the theory of constraints applies to a supply

  Explain the relevant first amendment

Please write clearly. Give examples, analogies, explanations, etc., as appropriate. Take a few minutes to think about each problem before you write. It may help to outline your answer on scratch pages. You may write your answer for each problem as on..

  Examine the business intelligence and social analytics

Examine three ways you believe that social networks have "leveled the playing field" between major corporations and small businesses.

  Create a report summarizing erp systems

Create a report summarizing ERP systems and explain how an ERP system can directly influence Cold Cream's revenues.

  Draw an initial context-level data-flow diagram

What people or other information systems will provide data inputs to your information system? List a few.Draw an initial context-level Data-Flow Diagram.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd