Reference no: EM132356179

Database Assignment -

Question 1 -

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

Exercise 2: Draw a ER diagram for generated database tables?

Exercise 3: Sql code to write table:

For create Artist table:

For create vistor table:

For create Vote table:

For create Vote Worker:

For relationship creation:

Question 2 -

Exercise 1: Write a query to find all students enrolled into course in 2016 or later?

Exercise 2: Write a query to generate a list of all students who have letter 'a' in their name (first name /last name)?

Exercise 3: Write a query to find students who enrolled for units offered in 'Burwood'?

Exercise 4: Write a query to show only to students who have enrolled to 'database' or a course that has been offered in 'Geelong?

Attachment:- Database Assignment File.rar