Question

Create a conceptual model using either an entity-relationship diagram or a crow’s foot notation to keep...

Create a conceptual model using either an entity-relationship diagram or a crow’s

foot notation to keep track of potential customers for new products.

You need to design the database so that the features of the new product are captured. You also

want to know what employee contacted the potential customer, the details that are known about

the customers, and which of the new products, specifically, a customer might be interested in.

For the new products themselves, you need to keep track of which employees are responsible for

promoting them.

State any assumptions of business rule

Homework Answers

Answer #1

The ER diagram to keep track of potential customers for new products is: In this diagram, we have three entities: Employee, Potential Customer and New Product. Each entity is having its own attributes as provided in oval shapes connected to them. The relationship between entities is described by using diamond shapes between two entities. This is a database used to capture the new products features and other information. The assumptions for this business rule are:

1. The business is based on the instant price collection for the new products when serviced or delievered to the customer.

2. The customers can return the new products within 24 hours of purchase.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Create a conceptual model using either an entity-relationship diagram or a crow’sfoot notation. State any assumptions...
Create a conceptual model using either an entity-relationship diagram or a crow’sfoot notation. State any assumptions of business rules. Create a conceptual model using either an entity-relationship diagram or a crow’sfoot notation. State any assumptions of business rules. Suppose you want to design a database to keep track of potential customers for new products. You need to design the database so that the features of the new product are captured. You also want to know what employee contacted the potential...
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the...
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the three narratives below. Use Lucid Chart or another ERD diagramming tool to create your diagram. You do not need to create the databases, but to design it using applicable business rules according to your judgment. Submit a PDF of the Entity Relationship Diagram for each database. Remember to identify in your diagrams: All the main entities and the main attributes for each entity The...
Using ER Assistant, develop an EER model for the following situation, using the EER notation associated...
Using ER Assistant, develop an EER model for the following situation, using the EER notation associated with ER Assistant. A technology company provides offerings to its customers. Offerings are of two separate types: products and services. Offerings are identified by an offering ID and an attribute of description. In addition, products are ­described by product name, standard price, and date of first release; services are described by name of the company’s unit responsible for the service and conditions of service....
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate is seeking your assistance in designing a database for her business. One of her employees has experience in developing and implementing Access-based systems, but has no experience in conceptual or logical data modeling. So, at this point Tanya only wants you to develop a conceptual data model for her system. You are to use our entity-data diagramming notation - Crows foot symbols. Tanya has...
Database Management and Design Homework assignment Directions: Create an ERD for the following case. Make sure...
Database Management and Design Homework assignment Directions: Create an ERD for the following case. Make sure you use the proper cardinalities. Sweeping Bulldog (SB) is an online textbook exchange portal. It allows an individual or customer (student, faculty, staff, etc.) to sell their used textbooks directly to other people without going through the formal UTC book store. The portal allows the individual to drop off their books anytime, most probably at the end of one semester. The individual then receives...
The Business Case for Agility “The battle is not always to the strongest, nor the race...
The Business Case for Agility “The battle is not always to the strongest, nor the race to the swiftest, but that’s the way to bet ’em!”  —C. Morgan Cofer In This Chapter This chapter discusses the business case for Agility, presenting six benefits for teams and the enterprise. It also describes a financial model that shows why incremental development works. Takeaways Agility is not just about the team. There are product-management, project-management, and technical issues beyond the team’s control. Lean-Agile provides...
After reading the following article, how would you summarize it? What conclusions can be made about...
After reading the following article, how would you summarize it? What conclusions can be made about Amazon? Case 12: Amazon.com Inc.: Retailing Giant to High-Tech Player? (Internet Companies) Overview Founded by Jeff Bezos, online giant Amazon.com, Inc. (Amazon), was incorporated in the state of Washington in July 1994, and sold its first book in July 1995. In May 1997, Amazon (AMZN) completed its initial public offering and its common stock was listed on the NASDAQ Global Select Market. Amazon quickly...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills, online shopping, coffees, vouchers, food,...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT