Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ERD Development Develop an ERD for the following problems. Show the ERD with entity types, relationship types multiplicities, attributes, the primary keys Visio or other

image text in transcribed

ERD Development Develop an ERD for the following problems. Show the ERD with entity types, relationship types multiplicities, attributes, the primary keys Visio or other tool , and placement of foreign keys. Develop the ERDs in A consulting company named Electronic Marketing Group (EMG) plans to create a database system, named EMGDB, to keep track of the information about its employees, clients, projects Each employee has a Social Security Number, name, address, phone number, position, and salary. Each employee also has an account for the internal computer network (Intranet). For example, Jennifer Furman's account name is jfurman; Beth Kim's account name is bkim. EMG has a lot of clients from all over the country. Bellaware and SWAN are two of the biggest clients. Each client has a company name, address, phone number, contact person, specialization (e.g., retailer, rental, telecommunication, etc.) Each employee works on projects requested by its clients. Each project is assigned a unique number and given a project name. For example, a project for SWAN company is assigned a project number P9820 and named SWAN web page design. Each project has a clearly defined schedule (consisting of a starting date and a due date), the total cost, and a brief statement for the project requirement in a text field (note that a detailed requirement specification is beyond the scope of this database purpose). Each project has several employees who work on the project, but each employee may work on only one project at a time. Some employee may not have any project to work on. Each project is associated with exactly one client company. But any client may have multiple projects at a given time. For example, SWAN has over five different projects with EMG now and

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions