Question

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 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.  

Homework Answers

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
- Develop an entity-relationship model. (ERD) Assuming that you are working for the public housing agency...
- Develop an entity-relationship model. (ERD) Assuming that you are working for the public housing agency of the city, and you have been charged with keeping track of who is living in the agency's developments over time. To help you in this task, you have decided to use a relational database for your record keeping. Your task is to design a database that allows you to capture the facts described below: • The city has three public housing developments. You...
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc....
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc. is a local real estate company that is specialized in leasing office space to businesses. The company does not own all the properties it leases. The company has its own suppliers and customers. We refer to the person or the company that owns the office space as a supplier. A customer is the person or the company that rents the office space. Emerald Realty...
A University wants to create an ER Diagram for its business model in the blank space...
A University wants to create an ER Diagram for its business model in the blank space provided below It provides the following business rules. All the relationship and cardinalities need to be shown properly based on the business rules given below. Any assumptions you make should be clearly mentioned. Students can take many courses but will need to take at least one course. Courses will have at least one but likely many students. Student can rent up to 3 books...
Write a scope statement based on the information below: Analysis Design Implementation Collect list of 20...
Write a scope statement based on the information below: Analysis Design Implementation Collect list of 20 projects Gather detailed requirements for desired outputs from the database Enter project data Gather information on projects Create fully attributed, normalized data model Test database Define draft requirements Create list of edit rules for fields, determine default values, develop queries, and determine formats for reports Make adjustments, as needed Create entity relationship diagram for database Develop list of queries required for database Conduct user...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in 3rd normal form. Please indicate any assumptions that you have made. Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed a list...
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...
Complete and correct answer is required to give full credit,thank you Consider the following set of...
Complete and correct answer is required to give full credit,thank you Consider the following set of requirements for an airline database that is used to keep track of flights, passengers, employees etc. for an airline. You will be graded not only on the correctness and completeness of the design but also on its quality. 1)     It is important to keep track of each passenger's name, address, phone number and meal preference (values could be vegetarian, sea-food, italian, anything). At times, it...
You are asked to design a database to support a Instant Recruitment System of casual staff...
You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version 1 (entities and data only) and version 3 (entities, attributes and relationships with cardinalities and participation constraints). 20 points of the grade will be based on evaluating your assumptions - you must give a detailed list of your assumptions identifying anchor concepts, data associated with the anchor and data that has more than one anchor participating in it. Remember, we are not talking out...
SkyMall SkyMall is a specialty publishing firm headquartered in Phoenix, Arizona. Founded in 1990, the company...
SkyMall SkyMall is a specialty publishing firm headquartered in Phoenix, Arizona. Founded in 1990, the company produces a quarterly in-flight publication, SkyMall, with an annual circulation of approximately 20 million copies distributed in airplane seat pockets. SkyMall is a multi-channel, direct marketer offering products through direct marketers and manufacturers through its SkyMall catalog. The SkyMall catalog is seen by approximately 88% of all domestic air passengers in the United States, reaching more than 650 million air travelers annually. SkyMall also...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT