Embedded Files
Goal: The purpose of this activity is to practice query writing skills and how to design the front and middle tiers of a Database Application
Goal: The purpose of this activity is to practice query writing skills and how to design the front and middle tiers of a Database Application
The GUI
The GUI
The Schema
The Schema
Display the count of each event type grouped based on the calendar months i.e., how many events of each type happening in the months for which the data is present in the database. You need to show the output only for those months which are present in the database. For EventConference we will consider the EvDate field while for the other two event types, Journal and Book, it will be the ActivityDate of the earliest/lowest activity (from ActivityHappens). You can show this query as three different queries for each event type.
End result
End result
SQL Codes (union with EventBook and EventJournal)
SQL Codes (union with EventBook and EventJournal)
Event books result
Event books result
Event Journals result
Event Journals result
Display the one upcoming event for each event type i.e., the event with the lowest date value but in the future from the current date. Assume the current date is “January 01, 2017”. For all event types, it will be the ActivityDate of the earliest/lowest activity (from ActivityHappens). You can show this query as three different queries for each event type.
Below is the SQL codes
When click on Event Conferences
When click on Event Books
Final Grade 100/100 = 21/21
Final Grade 100/100 = 21/21
Page updated
Google Sites
Report abuse