Programming Homework Help
Programming Homework Help. 2. Write a SQL Query to calculate Amount Due.
Instructions for MiniProject3-2.docx
TASKS
- Using three tables (Course, Customer, Enrollment) create relationships. Database file named MiniProject3 is provided that has all three tables via canvas.
- Customer – Enrollment (1 to many)
- Enrollment – Course (many to 1)
- Write a SQL Query to calculate Amount Due.
- List lastLame, FirtsName, Phone, Course, CourseDate, Fees ((Hint: SELECT – to access fields from tables)
- List AmountPaid, CourseFees, AmountDue
- Use INNER JOIN (HINT: COURSE INNER JOIN ENROLLMENT ON COURSE.CourseNumber = ENROLLMENT.CourseNumber)
- Use WHERE to calculate Amount Due (HINT: ((([COURSE]![Fee]-[ENROLLMENT]![AmountPaid])>0));)
- Named the query as Amount Due Query