Question

In: Computer Science

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:


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...
Why is it important that materials handling be aligned with an organization’s objectives, customers, and products?...
Why is it important that materials handling be aligned with an organization’s objectives, customers, and products? Please use example to explain what environmentally friendly packaging mean? How should a firm adopt the environmentally friendly packaging strategies?
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?
This database experience project has two parts: (1) creating the presentation-layer ERD, (2) developing the semantic...
This database experience project has two parts: (1) creating the presentation-layer ERD, (2) developing the semantic integrity constraints (meta-data) for your data. The deliverable will include a title page with your name, your client’s name, and all sections as part of one file (.pdf). Create the ERD Review the business rules described in your project files and create a presentation-layer ERD illustrating the entities/relationships needed to support your database design with accompanying data definitions. Use any graphical tool you prefer...
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
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...
Most companies have both transactional and relational customers. How should companies treat transactional customers?
Most companies have both transactional and relational customers. How should companies treat transactional customers?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT