Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make a structured query language (SQL) for the following question in Access Database (ill put into access database myself, just need the SQL): (I have

Make a structured query language (SQL) for the following question in Access Database (ill put into access database myself, just need the SQL): (I have provided the necessary info in screenshots. Screenshot 1 is the relationships, 2 is Attendance table, 3 is Courses table, 4 is Employees table).

2a). List the course enrollment for each courseID during the period between #9/30/2003# and #5/31/2008#

2b). List all other courses that have the same prerequisite requirement as Introduction to Access (use subquery)

2c). Discount the cost by 20% (become 80% of its original cost) for those courses that have fewer than 5 employees ever enrolled.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

All Access Obje H Employee: NAL CMIA Ascending Tis X Del Relati 1/1/2000 $3100.00 $6.110.00 9/23 1998 3/1/1956 $2,800.00 2/23/1997 810N1997 $3,400.00 2/1/1957 $3.200.00 $0.00 Ary do

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_2

Step: 3

blur-text-image_3

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

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions