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
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...
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...
Given the following business rules, create an entity relationship diagram. A booking is placed for one...
Given the following business rules, create an entity relationship diagram. A booking is placed for one or more travelers. e.g. A mom may place a booking for herself and her two kids. A traveler may place many bookings. e.g. you may place many bookings over the years. Requirements: draw the ERD with crow-foot notation Provide at least two attributes for each entity identify the PK for each entity Label the FK for each entity determine the relationship type with the...
Prepare an entity-relationship diagram for the database in a following company: Holiday Travel Vehicles sells new...
Prepare an entity-relationship diagram for the database in a following company: Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicle arrives at Holiday Travel Vehicles, a new vehicle record is created. Included in a new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost. When a customer arrives at Holiday Travel Vehicles, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed to,...
- 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...
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....
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...
Create a State machine diagram, class diagram and a sequence diagram A description of the System...
Create a State machine diagram, class diagram and a sequence diagram A description of the System Hjolaleidir.is - Better Biking routes The group “Better biking routes” has got the idea of making the website: hjolaleidir.is for cyclists in the greater Reykjavik area. The group “Better biking routes” want to make the website accessible for a broad spectrum of users. They are catering to users who want information about good routes from a place to a destination and users who wish...
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...