Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ticket un 6 assigns to TicNum TicTitle TicDescription TicOpen Date TicClosed Date UserEmail StaffID Staff Staffin StaffName TeamName 7 () 2 3 submits belongs to

image text in transcribed
image text in transcribed
image text in transcribed
Ticket un 6 assigns to TicNum TicTitle TicDescription TicOpen Date TicClosed Date UserEmail StaffID Staff Staffin StaffName TeamName 7 () 2 3 submits belongs to Ticket_Topic TopD TicNum 4 1 8 Team User UserEmail UserName UserPhone TeamName Team Description Topic Topi Top Title TopDesctiption 1. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 1 Tech Support Using Crow's Foot Model, provide all appropriate cardinalities using the following business rules: Each staff is part of one of the five IT Teams (Helpdesk, Server, Network, Desktop, Email) and a team may have many staff members Each user will have the ability to submit as many tickets as needed, and each ticket must be tied to a single user. Each ticket is assigned to at least one topic area but no more than three topics per ticket. A topic can include many tickets. . Ticket 5 6 Staff StaffID StaffName Team Name assigns to TicNum TicTitle TicDescription TicOpen Date TicClosed Date User Email StaffiD W 2 submits belongs to Ticket_Topic Topi Tic Num Eco 1 Topla TicNum 8 4 User Team UserEmail User Name UserPhone TeamName Team Description Topic ToplD TopTitle TopDescription 1. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 1 O a. (1,1) O b. (ON) O c. (1,3) 2. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 2 3.(1,1) b. (ON) O c. (1,3)

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

Moving Objects Databases

Authors: Ralf Hartmut Güting, Markus Schneider

1st Edition

0120887991, 978-0120887996

More Books

Students also viewed these Databases questions

Question

Did the team members feel that their work mattered

Answered: 1 week ago

Question

3. What may be the goal of the team?

Answered: 1 week ago