CREATING AN ERD: An organization’s customers may be individual persons or they may be companies. Each...

CREATING AN ERD: An organization’s customers may be individual persons or they may be companies. Each customer is given a customerID and has a DateJoined. Persons have a LastName, FirstName, and PersonAddress. Companies have a TradingName, TradingAddress, and PhoneNo. Customers may be service customers or purchase customers. Purchase customers have a CreditLimit stored for them. A customer may be both a service and a purchase customer. Service customers have maintenance contracts arranged for them. Each contract has a ContractNo, ContractDate, Cost, and EquipmentDetail. Calls made against each contract are recorded. Each call is given a CallNo within the contract. The DateMade and Duration of each call is stored.

Solutions

Expert Solution

Solution:

ER Diagram:

The entity relationship diagram represents the various entities and the relationship between them which helps us in understanding how the system works.

The entities are nothing but the real world objects.

These entities are connected using the relationships that are present between them.

Their attributes are mentioned with them and are the properties of the entities.

The ER diagram is represented as shown below.

ER Diagram:

venereology answered 1 year ago

Next > < Previous

Related Solutions

The chapter describes many companies’ individual marketing efforts that customize products for individual customers, such as...

The chapter describes many companies’ individual marketing efforts that customize products for individual customers, such as M&Ms, PUMA, and Harley-Davidson. Find and describe another example and discuss whether the cost of customizing is worth the value provided to consumers.

A study of persons (N = 1170) indicted for murder in Kentucky revealed that each individual...

A study of persons (N = 1170) indicted for murder in Kentucky revealed that each individual had an average number of 1.69 prior felony arrests. The standard deviation was 2.6. a. Determine the z score for a murder defendant who had two prior felony arrests. Under the normal curve, what statement could you make about this z score.

A study of persons (N=1170) indicted for murder in Kentucky revealed that each individual had an...

A study of persons (N=1170) indicted for murder in Kentucky revealed that each individual had an average number of 1.69 prior felony arrests. The standard deviation was 2.6 (20 points). a. calculate the 95 percent confidence interval for this distribution and write a statement about what it represents. b. determine the z score for a murder defendant who had two prior felony arrests. Under the normal curve, what statement could you make about this z score? An expert already answered...

Companies may abuse or ethically misuse information systems in regard to customers and employees. Have you...

Companies may abuse or ethically misuse information systems in regard to customers and employees. Have you or someone you know experienced such abuse? If so, how was it handled? If not, how would you begin to take steps to eliminate such abuse or misuse?

Describe an organization’s reasonable approach for handling upset customers respectfully and in a manner that results...

Describe an organization’s reasonable approach for handling upset customers respectfully and in a manner that results in the customers’ long-term commitment to an organization? Explain how the manager enable workers to reach customer service goals in their own way as long as their methods aren't harmful to the company. Describe what a manager should do if an employee is not meeting the organization’s customer service goals? Explain how a manager knows whether employees have sufficient motivation, training, and resources to...

In many cases, companies may charge a different price to different customers without any true cost...

In many cases, companies may charge a different price to different customers without any true cost differential to justify the discrepancy – this is referred to as price discrimination. Provide examples of how the three different types of price discrimination would apply. If you cannot find a real-life example, provide a hypothetical scenario for how the assigned company could apply each form of price discrimination. 1st Degree Price Discrimination, 2nd Degree Price Discrimination, 3rd Degree Price Discrimination

Most companies have both transactional and relational customers. How should companies treat transactional customers?

QUESTION 4 (a) The researcher is concerned that older persons may not be knowledgeable of the...

QUESTION 4 (a) The researcher is concerned that older persons may not be knowledgeable of the COFLU-20. As such, he is interested in investigating the association between the age of the respondents and their knowledge level. Table 2 below shows the knowledge level of respondents, by age group. Table 2 Age Group Knowledge Level Total Poor Satisfactory Good 18 - 25 33 16 13 62 26 - 34 30 18 12 60 35 - 44 29 14 12 55 45...

35. ________ is the process of creating and delivering desired goods and services to customers and...

35. ________ is the process of creating and delivering desired goods and services to customers and involves all of the activities associated with winning and retaining loyal customers. Select one: a. Marketing b. Personal selling c. Promotion d. Customer service

In order to compare the satisfaction of customers of 2 competitor companies of , 174 customers...

In order to compare the satisfaction of customers of 2 competitor companies of , 174 customers of company A and 355 customers of company B were chosen randomly. Customers were required to rate the companies from level 1 (least satisfaction) to 5 (maximum satisfaction). The results are included below. Check whether the difference in the mean level of customers' satisfaction of the two companies is statistical important at 1%. The results are included below: Company A Company B Sample Size ...

Subjects