ITA Refund Request System Phase 2

1.Purpose:

In the first 6 lectures, we discussed what a relational database is and how to design a relational database in three high level modeling notations.

In this assignment, you need to analyze the requirements of the ITA Refund Request System and design a relational database schema using an E/R diagram conversion. After this assignment, you should have an indepth understanding of how to go from the business requirements of a given system to the design of a corresponding relational database schema using E/R modeling.

2. Deliverables and Evaluation Method:

The detailed specification of the ITA Refund Request System Requirements can be found in ITA_System_2016_spec.pdf.

For this assignment, the individual submission of each student must include:

Part I: Relational Database Design using E/R modeling

1. An E/R diagram for the given system.

2. A relational database schema you converted from the E/R diagram that you have created. For each relation in the database, provide a name, a list of attributes and specify a key.

Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.