Note:- Don't copy from other contents if any wrong i will downvote ER DlagramsIn this assignment you will develop an ER diagram for the given scenario. To complete this assignment,you will need MYSQL Workbench MYSQL Workbench is part of MYSQL Install which includes both MySQLServer and MYSQL Workbench They are available for free download in one package athttp:/dev.mysql.com/downloads/workbench/..ScenarloYou have been hired by the sales department of ABC Manufacturing. Mark Harris, the sales manager hasrequested that you develop an ER model for his customer relationship management (CRM) system that heis proposing The requirements for the database are:The model must store mailing and contact information for all clients.The clients may have multiple contacts.Each of these contacts may have a different addressThe model must store short description of each e-mail, conversation, or mailing to each clientThe model must attach the client to the assigned sales person.Harris believes four entities are required to accomplish the above tasks.TasksUsing your knowledge of database models and their design, accomplish the following tasksin MYSQL Workbench, create an ER diagram that meets the above requirements. Include both EntityClasses and attributes that are necessary, given the above requirements. Save your ER model as an.mwbfile.in a separate Microsoft Word document, describe the various relationships between the differententities in the ER diagramCite any sources in APA formatSubmission DetallsName your ER diagram file SU ITS2110 W2 A2_ LastName_Firstinitial.mwb.Name your document SU ITS2110 W2 A2 LastName_FirstinitialdocSubmit your ER diagram file and your document to the Submissions Area by the due date assigned

ER Dlagrams In this assignment, you will develop an ER diagram for the given scenario. To complete this assignment, you will need MYSQL Workbench MYSQL Workbench is part of MYSQL Install which includes both MYSQL Server and MYSQL Workbench They are available for free download in one package at http:/dev.mysql.com/downloads/workbench/..

ER Dlagrams In this assignment, you will develop an ER diagram for the given scenario. To complete this assignment, you will need MYSQL Workbench MYSQL Workbench is part of MYSQL Install which includes both MYSQL Server and MYSQL Workbench They are available for free download in one package at http:/dev.mysql.com/downloads/workbench/..

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: please use store procedures to answer the following question Create a procedure to update Job Title…

A: CREATE TABLE job(p_job_id varchar(2) primary key,p_new_job_title varchar(20)); /* Create few records…

Q: Solve the follow y=2x+3 y=-x+9 Edit View Inse

A: To solve this system of equations, we need to find the values of x and y that satisfy both equations…

Q: :means dismantle O adjust O service

A: Maintenance service basically means the Routine repair and replacement of the facilities or the…

Q: Select record from nutr_def where nutrdesc is Retinol

A: Structured query language -It is used to query the information based on the condition using select…

Q: What restrictions can you apply when you are creating views?

A: Introduction: A view's referenced tables must all be in the same database. - Any user-defined…

Q: Instructions: Circle T if the statement is true, F if the statement is false, or write the best…

A: Given: Instructions: Circle T if the statement is true, F if the statement is false, or write the…

Q: Every MapReduce job must have at least one reducer Select one: True False

A: The question is on: The statement "MapReduce job must have at least one reducer" is true or false.

Q: please extend your answer

A: Race condition When two threads access a shared variable at the same moment, a race condition…

Q: INSERT command is part of the Data Definition Language (DDL) Select one: True False

A: Insert – is used to insert data into a table. It is a Data Manipulation Command(DML)

Q: Using PHP

A: Given :- The server side technology PHP is mention in the above given question ,use of phpmyadmin…

Q: question 1 Create a procedure that accepts a customer id and retrieves the id of the products and…

A: ProcedureA stored procedure is a logical unit composed of one or more pre-compiled SQL statements.It…

Q: file / directory attribute contains the date of modification performed.

A: Refer to step 2 for the answer.

Q: To update formula in a table, press the A. F9 keys B. ALT+F9 keys C. SHIFT+F9 keys D. F8 keys

A: To update formula in a table, press theA. F9 keysB. ALT+F9 keysC. SHIFT+F9 keysD. F8 keys

Q: This MATLAP command clears all data and variable

A: As per the question statement, we need to find the command from the options given which clears all…

Q: Describe procedure of views saving reprogramming effort.

A: To be determine: Describe procedure of views saving reprogramming effort.

Q: Where is part C? Please answer part C

A: Que) Imagine that the vertical arrows below the devices are timelines and that the clocks of all…

Q: Table of contents

A: Given: Table of contents

Q: To create a stored procedure, use the CREATE PROCEDURE command. true false

A: Question. To create a stored procedure, use the CREATE PROCEDURE command. True False

Q: QUESTION 4 Convert the following ER diagram into a relational database schema, be certain to…

A: Convert ER diagram into relational database schema.

Q: When I remove the quotations it says Invalid string a string can have up 2048 characters

A: Here, the problem is due to misinterpretation of Microsoft Access what you are intended to. From the…

Q: Question 5 To make adjustments to your reference markers, you would navigate to the References tab…

A: The reference mark is the symbol that calls attention to an important sentence or idea. The endnote…

Question

Note:- Don't copy from other contents if any wrong i will downvote

ER Dlagrams
In this assignment you will develop an ER diagram for the given scenario. To complete this assignment,
you will need MYSQL Workbench MYSQL Workbench is part of MYSQL Install which includes both MySQL
Server and MYSQL Workbench They are available for free download in one package at
http:/dev.mysql.com/downloads/workbench/..
Scenarlo
You have been hired by the sales department of ABC Manufacturing. Mark Harris, the sales manager has
requested that you develop an ER model for his customer relationship management (CRM) system that he
is proposing The requirements for the database are:
The model must store mailing and contact information for all clients.
The clients may have multiple contacts.
Each of these contacts may have a different address
The model must store short description of each e-mail, conversation, or mailing to each client
The model must attach the client to the assigned sales person.
Harris believes four entities are required to accomplish the above tasks.
Tasks
Using your knowledge of database models and their design, accomplish the following tasks
in MYSQL Workbench, create an ER diagram that meets the above requirements. Include both Entity
Classes and attributes that are necessary, given the above requirements. Save your ER model as an.mwb
file.
in a separate Microsoft Word document, describe the various relationships between the different
entities in the ER diagram
Cite any sources in APA format
Submission Detalls
Name your ER diagram file SU ITS2110 W2 A2_ LastName_Firstinitial.mwb.
Name your document SU ITS2110 W2 A2 LastName_Firstinitialdoc
Submit your ER diagram file and your document to the Submissions Area by the due date assigned

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

What are the features of entries that are being adjusted? Please provide specifics.
Dataset url = 'https://raw.githubusercontent.com/justmarkham/DAT8/master/data/chipotle.tsv' 1. Import the dataset from url 2. Sort by the name of the item 3. What was the quantity of the most expensive item ordered? 4. How many times was a Veggie Salad Bowl ordered? 5. How many times did someone order more than one Canned Soda?
Create an alias the root user will use for the copy command that includes the recursive, archive, interactive, and verbose options
USING the SELECT statement, query the track table ordered by the bytes. Set the LIMIT to 5 and OFFSET to 5. What is the name of the last row returned? Snowballed Evil Walks Bossa Deixa Entrar
Note: ahmad is not member of ali group. another user called "ahmad" can execute "cd Ireports" command successfully. Select one: True False
1 rows returned in 0.00 seconds Download 7. In the OrderItems table, display the maximum item_price with the alias shown. 11.99 1 rows returned in 0.00 seconds Download Max Item Price
R language Show Which department has the highest admission on UCB admission dataset available in R, please answer it with code
The author plans the book chapters and book title. After planning the book author writes the book and send it to the reviewer..The reviewer gives the feedback to the author whether the further changes are required or not. If no changes required, author would send the book in hard and soft form to publishing house. Publishing house will check the book if its according to standard. If yes, then they will send the book for printing otherwise book will be sent to the reviewer for the final revision. The printed book will be sold to customer. The money received by the publishing house will be distributed to reviewer and author From the given problem statements, draw an activity diagram by making sure to have these elements where required Swimlanes Merge and fork nodes Decision nodes
i need the answer quickly
Complete the Where clause in the following statement, which should select only records whose LastName field begins with an uppercase letter A:Dim records = From name In NamesDataSet.tblNames Where Select name
Why are access restrictions needed today? Please list two access restrictions.
When is it acceptable to manually create an index?