1 A music festival is looking to create a database to manage the information related to their upcoming event. 2. ERD Diagram entities- The database will need to store information about the festival's performers, stages, and the schedule. Design your ER Diagram with all entity names, attribute names, primary and foreign keys, relationships, cardinality and participation indicated. You will need to normalise all of your entities, to resolve any many to many relationships. Observe the following restrictions when creating your scenario: - One (or more) of your entities must have a numeric field - One (or more) of your entities must contain an alphanumeric (varchar) field - One of your entities must contain a compound key - Do not have include cyclic relationship (A->B->C->A) Your attribute names, primary and foreign keys should be indicated as per the conventions given in the lecture slides (i.e. attributes as proper nouns, primary key underlined and foreign keys in italic All many to many relationships should be resolved, and you may wish to include a discussion of normalisation including the normal form that each entity is in and why that is optimal. 3. For each entity, you must create some example data for that entity. Include at least 10 rows of data for each entity. This data must be initially stored in a text file that will be imported into the database. 4. Write the SQL statements to create the table structures from your developed ERD. The structures should contain the attributes specified in your ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by your ERD. Write the SQL code to insert your data from (3) into the SQL table structures. 5. Write the SQL statements that provide the following database functionality: Query 1. Write an SQL statement that correctly uses the 'LIKE' symbol on an alphanumeric field to select a subset of data. Explain the purpose of your query for your database solution. ITECH1103 Assignment SQL Database Page 2 of 5 ITECH 1103 BIG DATA AND ANALYTICS Query 2. Write an SQL statement that correctly implements a JOIN statement over two or more entities to select a subset of data. Explain the purpose of your query for your database solution. Query 3. Write an SQL statement that correctly uses the '>' operator to select a subset of data for a single entity. Explain the purpose of your query for your database solution. Query 4. Write an SQL statement that correctly uses the 'GROUP BY' operator to select an aggregation of data (e.g. SUM, AVG, COUNT). Explain the purpose of your query for your database solution. Query 5. Write an SQL statement that correctly uses the 'IN' symbol to select a subset of data for a single entity. Explain the purpose of your query for your database solution. Query 6. Write an SQL statement that correctly uses the 'UPDATE' symbol to modify at least three rows of data in one of your tables. Explain the purpose of your query for your database solution. 6. Write a short section (two or three paragraphs) about some aspect of your scenario that might be too difficult or very complex to implement in an SQL database. ITECH1103 Assignment SQL Database Page 3 of 5 ITECH 1103 BIG DATA AND ANALYTICS Documentation requirements Make it and must include all these below 1. Prepare a report (single Word or PDF document) which contains the following: a). ER diagram based on your created scenario provide link b). Provide Statement of any resources used.