3253725 Assignment-1 Create views in oracle

Create VIEWS for the following in Oracle (views should be named as ViewA, ViewB etc).

You should also provide the CREATE VIEW statements you used to create the views in your Word document. View A. All the members represented in the database, and details of the skills they offer, listed in alphabetical order of last name. View B. A list of all the equipment available for loan, the contact details of the member who is loaning the equipment, and any specific information about the conditions of loan. View C. A list of attendees (name, phone number, and whether they are registered members or guests) who have signed up for Fran Forklift’s workshop on ‘Chainsaw use and maintenance’. View D. All the events (title, date) that were more popular (i.e. higher attendance) with guests than with registered members. View E. All the upcoming events (title, date, location) in a given postcode (e.g. 6150) for the next month (i.e. the whole of the next calendar month). View F. Details (title, description, date, location, leader name, instructions) of all the events that mention roses. View G. Names of any members who have organised, led or helped in more events than they have attended as participants. The result table should also show the number of events. View H. All the events (title, date, leader) that meet accessibility guidelines. View I. A list of guests who attended (or are signed up to attend) events that are not in their home suburb. The result table should also show their home suburb and the event suburb. View J. The number of unfilled places in each category of event that has been held so far.
To Download Click Here > 3253725 Assignment-1 Create views in oracle.pdf