SIT772: Database and Information Retrieval- Deakin University- Saffron Gallery- IT Assignment Help

Assignment Task

Task

Question 1 Saffron Gallery is about to host an exhibition next month. A number of works of art (paintings, Sculptures, etc.) will be exhibited. Every art work will have a barcode, a title and a description.Each Art Work is created by a single artist. Every artist has a name, an address and a contact number. One artist may create more than one art work for the exhibition.People will come and visit the exhibition. As each person enters the exhibition, their name, address and phone number will be recorded. Each person will be given a unique barcode id. During their visit, people will nominate which art work they consider the best and this will be recorded by Uptown Gallery. People will be able to vote for more than one art work.

Exercise 1: Describe the elements (entities, attributes and relationships) of the table of this database system.

Exercise 2: Draw the Entity Relationship Diagram (ERD) of the generated tables.

Exercise 3: Write the SQL code to create the tables.

Question 2 You are given the Student 1, Student 2, and Course tables in the database below:

For each of the following exercises please provide a screenshot of SQL query execution. Exercise 1: Write the SQL code to create the above three tables, and insert the sample data into the tables. Exercise 2: Write the SQL query to find all students who have enrolled into a course in 2016 or later. Exercise 3: Write the SQL query to generate a list of all students who have the letter ‘a’ in their name (first name/last name). Exercise 4: Write the SQL query to find students who are enrolled for units offered in ‘Burwood’. Exercise 5: Write the SQL query to show only students who have enrolled in the ‘Database’ course or a course that has been offered in Geelong.

This BSBPMG530 – IT Computer Science has been solved by our Ph.D. Experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing style.