Question: Tech Support Using Crow's Foot Model, provide all appropriate cardinalities using the following business rules: Buch staff is part of one of the five IT

 Tech Support Using Crow's Foot Model, provide all appropriate cardinalities using
the following business rules: Buch staff is part of one of the
five IT Teams (Helpdesk, Server, Network, Desktop, Email) and a team may
have many staff members Bach user will have the ability to submit

Tech Support Using Crow's Foot Model, provide all appropriate cardinalities using the following business rules: Buch staff is part of one of the five IT Teams (Helpdesk, Server, Network, Desktop, Email) and a team may have many staff members Bach 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 TicNum L. Staffin TicTitle assigns to TicDescription StaffName TicOpenDate TicClosed Date UserEmail Staffis TeamName N 3 submits belongs to Ticket_Topic ToplD TicNum 00 1 8 User L Team to submit Ticket_Topic ToplD 8 1 TIeNum 4 User () Team UserEmail TeamName User Name Team Description UserPhone Topic ToplD Top Title TopDescription 1. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 1 a. (1,1) b.(ON) O c (1,3) 2. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 2 O a (1.1) O b. (0) O C(1,3) e It 3. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 3 O a. (1,1) O b.(ON) O c (1,3) 4. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 4 O a. (1,1) O b. (ON) O C(1,3) 5. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 5 O a. (1,1) O b. (0) O c.(1,3) 6. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 6 O a. (1,1) b. (ON) C. (1,3) 7. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 7 O a. (1,1) O b. (ON) O c (1,3) 8. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for number 8 O a. (1,1) O b.(ON) O C(1,3)

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!