To expand the database design created in exercise 3 to incorporate following user view: CAT is required to send invoice to each participant. The details of invoice should be classes in which participant is enrolled, total fee for the adventure classes, name and address of participant. Given information: Following database design was developed for exercise 3: Explanation: Based on user view following Invoice table should be generated: Invoice ( InvoiceNum , ClassNum, TotalFees, LastName, FirstName, Address) In the above relation attributes LastName, FirstName and Address are already present in Participant table. Thus, only by including the PNumber as foreign key in Invoice table one should be able to get last name, first name and address of the participant. Therefore, Invoice relations should have the following structure: Invoice ( InvoiceNum , ClassNum, TotalFees, PNumber) Thus, DBDL for this user view will be as follows: Cumulative design after this user view will be as follows:

Question

Many IT implementations are operated as projects. Project stakeholders are vital aspects of the project team. Describe a project that you have worked on and the roles of each member on the team, and then answer the following questions. If you have never been on a project, find one online and answer the following questions. Why is it important to understand the role that each member plays on the team? What organization structure was in place for the project? Was the organizational structure optimal, and if so, why was it optimal? If it was not optimal, what structure would have been the optimal structure and why?

Answer 1

Question

Chapter 6, Problem 4CATC

To determine

To expand the database design created in exercise 3 to incorporate following user view:

CAT is required to send invoice to each participant. The details of invoice should be classes in which participant is enrolled, total fee for the adventure classes, name and address of participant.

Given information:

Following database design was developed for exercise 3:

Explanation:

Based on user view following Invoice table should be generated:

Invoice (InvoiceNum, ClassNum, TotalFees, LastName, FirstName, Address)

In the above relation attributes LastName, FirstName and Address are already present in Participant table. Thus, only by including the PNumber as foreign key in Invoice table one should be able to get last name, first name and address of the participant. Therefore, Invoice relations should have the following structure:

Invoice (InvoiceNum, ClassNum, TotalFees, PNumber)

Thus, DBDL for this user view will be as follows:

Cumulative design after this user view will be as follows:

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Many IT implementations are operated as projects. Project stakeholders are vital aspects of the project team. Describe a project that you have worked on and the roles of each member on the team, and then answer the following questions. If you have never been on a project, find one online and answer the following questions. Why is it important to understand the role that each member plays on the team? What organization structure was in place for the project? Was the organizational structure optimal, and if so, why was it optimal? If it was not optimal, what structure would have been the optimal structure and why?

This is solely for learning purposes. Please analyze the image for me. Thank you

this is for educational purposes, please anylyze the image for me