Question: Give me an example ofQ 1 . Reverse engineer the ERD that corresponds to the intercollegiate database Q 2 . Show the contents of result

Give me an example ofQ1. Reverse engineer the ERD that corresponds to the intercollegiate database
Q2. Show the contents of result set T3 :
T1(EventPlanLine JOINEventPlanLine.locno=Location.locno Location)
T2 RESTRICTT1.locno=L100(T1)
T3 PROJECTplanno, lineno, location (T2)
Q3. Create a SQL query that lists the event number, customer name, plan number, employee
name, facility name, work date, and activity for event plans. The result should show only
event plans with a work date in October 2023.
Q4. For events with work dates in October 2023, create a query that lists the location number,
location name, number of event plan lines, and the sum of the hours in which the location is
used.

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 Programming Questions!