Question: Using the business rules listed below construct and ERD diagram using Microsoft visio tool Business rules Every Customer can have more than one Device. Every

Using the business rules listed below construct and ERD diagram using Microsoft visio tool

Business rules

Every Customer can have more than one Device. Every Device can have only one OS. A Customer may have more than one Support Case. Every Customer may have more than one Mobile Application. A Support Case is created for one Customer and is assigned to one Staff. A Staff member may have multiple support cases A Mobile Application can have several versions. When multiple cases are open for the same issue a Support Case can be a master case that is used to group the duplicate Support Cases from other Customers. When the issue is required to be escalated to Engineering a software patch is then requested. A Support Case can be escalated to Engineering for patch/version to be created. A Customer can create a Support case by Email or a Webform. Once a Support Case is generated a Tier One staff member Categorizes the Support Case and assigns the Support Case to a Staff member.If the person working on the issue is unable to resolve the problem it gets escalated to Engineering group for the application. A Support Case can have only one Category, App, and Type of Issue.

Entity

Customer - FName,LName, Email (may have more than one), ID ,Address

Device ID - Type Manufacturer Model OS Version of OS

Mobile Application - ID, Name,Version, Status, Supported OS

Staff - ID, FName, LName, GroupID

Groups - ID, Name,

Support Case - ID, CustomerID, GroupID ,DeviceID, MobileAppID ,Description of Problem, Date Opened, Date Closed, Status ,Attachments (more than one), Urgency ,IsMaster MasterCaseID, StaffID ,Category (Lifestyle, Health, Games) App (Name of Apps) Type of Issue (Navigation, Crash, Installation)

SLA -ID, Level, Support, Urgency

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Customer/Product database modeling Things to consider: Purchase order (PO): is a legal document "Contract" issued by the buyer (customer) to the supplier, indicating specifications, quantities,...

Please draw this diagram with precision and I will definitely give thumbs up. Thank you system in an ER diagram. Super Sports (SS) is a sporting goods company head-quartered in Tempe, Arizona....

Lucky Preserves Lucky Preserves is a small shop in Mon Valley that has been in business over several years. The shop is owned by Carissa McNally, who has operated this business for over 20 years now....

Create an EER diagram using MySQL Workbench (Crow's Foot Notation) to support the described business scenario and its operations. After, translate the diagram into a DB schema consisting of tables...

The purpose of this assignment is to define a high-level standard Sales, Purchasing, and Inventory ERP system in an ER diagram. Super Sports (SS) is a sporting goods company head-quartered in Tempe,...

1. For the business rules given below, create a Crow's Foot diagram using Visio Business rules are as follows: Each employee may have many dependents Each dependent is related to only one employee...

Scenario For this course we will use the following Scenario for all 4 exercises. Restaurant Operation The owners of a small mom and pop pizza restaurant want to improve their operation, and (of...

The GCS database must support all of GCSs operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a...

Here are the steps you need to go through to do the project: Given the business rules above, create a logical-level Crows Foot ERD using Visio. Show all original entities and any associative entities...

SYS FISH HOUSE ACCOUNTING INFORMATION SYSTEM NEEDS 1. Identify the business processes you see at Sys 2. For each process, write a detailed description of the steps in the process or feel free to flow...

On September 1st, Year 1, Dexter's Drive-In issues a bond with a $80,000 face value and a 12% stated interest rate. The bond will pay every four months for two years, ending on September 1st, Year 3....

Which problem do you think is more serious at Google: possible racial discrimination or possible reverse descrimination? Why?

If the inherest rate paid on a bond is lower than the market inberest rate, the bond will sell for an amourt that is equal to mis maturly value. Hes Than 7 is madurly value. more than is maharity...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2 The role of economic theory in economics.

2. What advantages and disadvantages does IBMs program have for mentors? For protgs? For mentees?

2. This chapter discussed several trends that will influence the future of training. Based on future social, economic, political, or technological factors, identify one or two additional trends that...