What is an associative entity

Assignment Help Computer Engineering

Reference no: EM133477641

Problem: Computer Science Project Management

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

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

i. Customers have prescriptions from eye doctors.
ii. Customers buy frames that come from manufacturers
iii. Customers are helped by a staff member.

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

i. One to one relationship
ii. One to many relationship
iii. One to one or many relationship
iv. One to one or zero relationship
v. One or many to one or many relationship
vi. Many to many relationship
vii. 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: EM133477641

Questions Cloud

Post your opinion of the statistical test : post your opinion of the statistical test that was covered that you feel would be the most useful (just in general)

What symptoms are associated with the disease : What symptoms are associated with the disease? How is the disease treated? How are the symptoms relieved?

Explain how your leadership skills influence the culture : Explain how your leadership skills influence the culture of your organization. - Explain how your values and beliefs contribute to the culture

Describe the chi-square test of independence : Describe the chi-square test of independence. Explain what this test measures and how it is similar to and different from the chi-square goodness-of-fit test

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

Effects of metabolic toxins on cellular respiration : The following assignment will be for marks. It is important you are able to display an ability to complete scientific investigations on a variety of course conc

Determine factors affecting decision implementation : Apply decision-making techniques. - Determine factors affecting decision implementation. - Evaluate resources and actions required for implementation.

Why is shoulder strengthening more important imobolization : Why is shoulder strengthening more important than imobolization?

Write a summary on non-verbal communication : Write a summary on non-verbal communication and what we can learn from it. For your summary please look at the videos and article linked below.

User Account

All Pages